C2090-619 Online Practice Questions and Answers

Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

A. STATAUTO

B. STATFORCE

C. FORCE AUTO

D. STATCHANGE

Which threshold setting applies when configuring automatic memory management?

A. SHMTOTAL

B. BUFFERPOOL

C. SHMVIRTSIZE

D. DS_TOTAL_MEMORY

Which two statements are true? (Choose two.)

A. Logical log files must always reside in rootdbs.

B. Having too little log space does not affect performance.

C. Having too much log space does not affect performance.

D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

Which statement is true for starting Connection Manager?

A. Only user root and informix.

B. Any user of the DBSA group.

C. Any user who is granted privileges to connect to the sysadmin database.

D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

The purge policy CANNOT be executed for a rolling window table utilizing which method?

A. By calling the syspurge function.

B. By the purge_tables task of the Scheduler.

C. By setting up the server to automatically run the purge policy.

D. By running ALTER FRAGMENT with the PURGE NOW predicate.

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

A. LOW_MEMORY_SVR

B. LOW_MEMORY_MGR

C. LOW_MEMORY_RESERVE

D. LOW_MEMORY_PRESERVE

Which statement is true about log salvaging?

A. ontape cannot perform salvage of logs.

B. Log salvaging cannot be avoided if onbar is used for restore.

C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

A. Informix OpenAdmin Tool does not support multiple languages.

B. Ontape backup can be taken using Informix OpenAdmin Tool.

C. Informix cluster cannot be managed using Informix OpenAdmin Tool.

D. Informix OpenAdmin Tool cannot be used to run the equivalent of onstat commands.

E. SQL explorer feature provides Query Drill Down functionality to analyze SQL statements.

Which statement about Storage Provisioning is true?

A. Only raw devices can be extended.

B. Only cooked devices can be extended.

C. Only unmirrored spaces can be extended.

D. Mirrored and unmirrored spaces can be extended.

Where must the HA_FOC_ORDER configuration parameter be set?

A. Any server in the cluster.

B. The primary server only.

C. The SDS secondary only.

D. The HDR secondary only.