DB2 10.1 DBA for Linux UNIX and Windows: C2090-611

You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?

A. Assign the value ON to the DB2_HADR_ROS registry variable.

B. Assign the value ON to the DB2_HADR_SNAP registry variable.

C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.

D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.

By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

A. Drop and reload the table.

B. Drop and recreate the index.

C. Reorganize the table to cluster its data according to that index.

D. Reorganize the table to cluster its index according to that query plan.

When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

A. They are automatically dropped.

B. They are marked as "Move Pending."

C. They are marked as "Dropped Pending."

D. They are automatically moved to the new table space.