C2090-614 Online Practice Questions and Answers

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

A. Call the ADMIN_MOVE_TABLE procedure.

B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.

C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.

D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.

When will the existing data for a new partition be visible to applications querying a range-partitioned table?

A. After the ALTER TABLE ... ADD statement is executed.

B. After the ALTER TABLE ... ATTACH statement is executed.

C. After the ALTER TABLE ... ADD and SET INTEGRITY statements are executed.

D. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed.

What statement regarding Asynchronous index cleanup (AIC) is correct?

A. AIC removes all invalid index entries that refer to the attached partitions.

B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

C. AIC activates a newly attached partition after the index entries have been synchronized.

D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).

Which statement about compression dictionaries is FALSE?

A. Page-level dictionaries are stored in hidden rows within the table.

B. Table-level dictionaries are stored in hidden rows within the table.

C. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.

D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

Which would not significantly benefit from having the RUNSTATS command run on it?

A. Tables that have had little change.

B. Tables where a new index has been created.

C. Tables that have been reorganized (using REORG).

D. Tables that have been populated with a LOAD operation.

Which tool provides the simplest method for monitoring buffer pool hit ratios?

A. The BP_HITRATIO administrative view.

B. The BP_WRITE_IO administrative view.

C. The MON_GET_BUFFERPOOL table function.

D. The MON_GET_PAGE_ACCESS_INFO table function.

Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

A. logarchopt1

B. failarchpath

C. mirrorlogpath

D. overflowlogpath

You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?

A. The INSPECT utility

B. The db2pd command

C. The db2dart command

D. The database recovery history file