IBM Informix 12.10 System Administrator (C2090-619) Free Practice Test

Question 1

Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

A. On-disk encryption

B. High-Availability Data Replication

C. Server-to-server distributed query communication

D. Column level encryption

E. Enterprise Replication

Correct Answer: B,E

Question 2

Which object can be compressed?

A. temporary table

B. dictionary table

C. detached b-tree index

D. attached b-tree index

Correct Answer: C

Question 3

Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

A. AUTO_PERF

B. AUTO_ENABLE

C. AUTO_TUNE

D. AUTO_CONFIG

Correct Answer: C

Question 4

Which Informix utility is used to print information about runtime statistics for all threads in the server?

A. onstat -g sta

B. onstat -g act

C. onstat -g rea

D. onstat -g cpu

Correct Answer: D

Question 5

Which SQL statement is valid to monitor database server sessions?

A. EXECUTE FUNCTION task ("onstat","-g ses");

B. EXECUTE FUNCTION task ("check server","sessions");

C. EXECUTE FUNCTION task ("check sessions","all");

D. EXECUTE FUNCTION task ("view sessions","all");

Correct Answer: A

Question 6

Which storage manager allows specification of a larger size than others for
BAR_XFER_BUF_SIZE?

A. Informix Primary Storage Manager (PSM)

B. Informix Archive Restore Storage Environment (IARSE)

C. Informix Storage Manager (ISM)

D. Informix Secondary Storage Manager (ISSM)

Correct Answer: A

Question 7

Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

A. AUTO_AIOVPS

B. DIRECT_IO

C. AUTO_READAHEAD

D. DBUPSPACE

Correct Answer: C

Question 8

For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

A. The query or query block must refer to a subset of the tables in the AQT.

B. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

C. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

D. The query or query block must include at least 2 fact tables.

Correct Answer: D

Question 9

When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

A. LOW_MEMORY_RESERVE

B. LOW_MEMORY_SVR

C. LOW_MEMORY_PRESERVE

D. LOW_MEMORY_MGR

Correct Answer: A

Welcome to TestSimulate

IBM Informix 12.10 System Administrator (C2090-619) Free Practice Test