C2090-619 Online Practice Questions and Answers

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

A. The temp table will be created in datadbs1.

B. The temp table will be created in root dbspace.

C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Which type of device does Primary Storage Manager support?

A. File

B. Tape

C. Directory

D. Named pipe

What kinds of Table Level Restores can be done by the archecker utility?

A. Only logical restore.

B. Only physical restore.

C. Only point in time restore.

D. Physical, logical, and point in time restores.

Which object can be compressed?

A. dictionary table

B. temporary table

C. attached b-tree index

D. detached b-tree index

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

To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

A. Shrink

B. Repack

C. Compress

D. Defragment

Which two statements are true?

A. Temporary dbspaces can have different page sizes.

B. Separate temporary dbspaces are required for each buffer pool.

C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.

D. If rootdbs is mirrored then all the temporary spaces must be mirrored.

E. If DBSPACETEMP is not configured then temporary space will never be used.

Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?

A. UPDATE STATISTICS DISTRIBUTIONS ONLY

B. UPDATE STATISTICS LOW DROP DISTRIBUTIONS

C. UPDATE STATISTICS LOW REMOVE DISTRIBUTIONS

D. UPDATE STATISTICS MEDIUM REMOVE DISTRIBUTIONS