C2090-619試験無料問題集（130題）「IBM Informix 12.10 System Administrator 認定」

出題：1

What is the purpose of the ifx_getMartStat() function?

A. To display status information about the Informix Warehouse Accelerator and all the data marts.

B. To display statistics about the workers and coordinators defined for the accelerator.

C. To display update statistics information about the data mart and its tables.

D. To display status information about the data mart.

正解：D 解答を投票する

出題：2

An Enterprise Replication server is a primary server for shared-disk secondary servers.
The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

A. CDR_MAX_FLUSH_SIZE

B. CDR_LOG_LAG_ACTION

C. CDR_TSINSTANCEID

D. CDR_MAX_TXNS

正解：A 解答を投票する

出題：3

Given these statements are executed:

which statement is true?

A. The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

B. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAP expressions are evaluated by
Informix Warehouse Accelerator (IWA).

C. The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).

D. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and
OLAP expressions are evaluated by Informix database server.

正解：D 解答を投票する

出題：4

Which communication protocol needs additional configuration besides onconfig and sqlhosts?

A. IPCSHM

B. SOCSSL

C. TLITCP

D. IPCSTR

正解：B 解答を投票する

出題：5

After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

A. karin and dave

B. karin and sarah

C. sarah

D. karin, dave and sarah

正解：C 解答を投票する

出題：6

In addition to examining the Connection Manager log file, what are two ways to monitor the
Connection Manager status? (Choose two.)

A. onmode

B. onmonitor

C. onstat

D. OpenAdmin Tool

E. oncmsm

正解：C,D 解答を投票する

出題：7

Which statement accurately describes the selective row-level auditing feature in Informix?

A. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

B. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

D. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

正解：D 解答を投票する

出題：8

Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

A. SHMVIRTSIZE

B. CKPTINTVL

C. CLEANERS

D. RA_PAGES

正解：C 解答を投票する

C2090-619試験無料問題集「IBM Informix 12.10 System Administrator 認定」