What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the droppedtable.

B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.

C. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE option to restore the

database and recover the dropped table.

D. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

Which statement is correct for a user who holds SECADM authority?

A. A user who holds SECADM authority can only grant and revoke database object privileges.

B. A user who holds SECADM authority can grant and revoke all database level authorities and database object privileges.

C. A user who holds SECADM authority can only grant and revoke DBADM and SECADM database level authorities.

D. A user who holds SECADM authority can only grant and revoke label based access control (LBAC) security labels.

Which of the following table types is NOT supported by the load utility?

A. A Temporal table

B. A Range Partitioned table

C. A Global Temporary table

D. A Multidimensional Clustering table

Which statement about updating index statistics with the RUNSTATS command is true?

A. It requires a full index scan.

B. It can be accomplished by sampling the index.

C. It must be executed against all indexes for the table.

D. It cannot be accomplished without scanning the associated table.

What can be used to provide input to the Design Advisor?

A. An XML file.

B. A query workload file.

C. The database configuration file.

D. The database manager configuration file.

Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

A. db2pd

B. db2dart

C. db2look

D. db2mimic

What are two purposes of the SET INTEGRITY statement? (Choose two.)

A. To bring a table out of "Set Integrity Pending" state by performing the required integrity processing on the table.

B. To bring a table out of "Set Integrity Pending" state by performing only check constraint processing on the table.

C. To bring a table out of "Set Integrity Pending" state without performing the required integrity processing on the table.

D. To bring a table out of "Set Integrity Pending" state by performing only referential integrity constraint processing on the table.

E. To bring a table out of "Set Integrity Pending" state by performing only referential integrity and check constraint processing on the table.

Given the following statement:

How many constraints are present in the DEPARTMENT table?

A. 1

B. 2

C. 3

D. 4

What information can be obtained by analyzing EXPLAIN data?

A. Access type, index use, and work load

B. Index use, work load, and join methods

C. Work load, access type, and join methods

D. Join methods, index use, and access type

If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

A. Crash recovery

B. Version recovery

C. Disaster recovery

D. Roll-forward recovery