IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows - A2090-611 Exam Practice Test

A. It saves dynamic SQL stored in the package cache to an external file.

B. It removes all dynamic SQL statements from the package cache.

C. It causes all SQL statements in the package cache that are currently in use to be recompiled.

D. It removes only inactive SQL statements from the package cache.

A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.

B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.

C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.

D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.

A. Using the INSERT INTO and the INCREMENTAL indexing mode allows DB2 to increase the concurrency of table access during the LOADoperation because LOAD will always append the inserted data to the end of the table and the new index pages are also added to the end ofthe existing index when using INCREMENTAL indexing mode.

B. Using the COPY NO option means the data in any table within table space TBSP_1 cannot be updated or deleted until either a table spacebackup of TBSP_1 or a full database backup is completed.

C. Using the COPY NO and ALLOW READ ACCESS options means that the existing table data is only readable until the index build phase begins,since no copy of the existing data is made during the LOAD.

D. Using the ALLOW READ ACCESS option along with INCREMENTAL indexing mode means that the newly inserted data can be accessedbecause of the new CURRENTLY COMMITTED semantics.

A. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;

B. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE
STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;

C. ALTER TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;

D. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;

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

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

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

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

A. CONNECT

B. DBADM

C. SQLADM

D. SECADM