Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows

Question 1

How can you remove all effects of compression from an index?

A. Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer thatcompression is no longer used.

B. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.

C. Execute the ALTER INDEX statement to turn compression off.

D. Execute the ALTER TABLE statement to turn compression off.

Correct Answer: B

Question 2

Which tool should be used to give you lock wait information from the DB2 memory sets?

A. db2support

B. db2mtrk

C. db2fodc

D. db2pd

Correct Answer: D

Question 3

How is the time that an agent waits for log records to be flushed to disk calculated?

A. LOG_END_TIME divided by TOTAL_COMMITS

B. LOG_FLUSH_TIME divided by TOTAL_COMMITS

C. LOG_WAIT_TIME divided by TOTAL_COMMITS

D. LOG_WRITE_TIME divided by TOTAL_COMMITS

Correct Answer: D

Question 4

The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:

What commands must be run to enable real-time statistics collection on the SAMPLE database?

A. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

B. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON; UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

C. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

D. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON; UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

Correct Answer: D

Question 5

Which statement describes a way to minimize the impact of a RUNSTATS operation?

A. Limit the number of pages and rows processed by using page-level or row-level table sampling.

B. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.

C. Reduce I/O by using a shadow table space for statistics collection.

D. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.

Correct Answer: A

Question 6

Which table space is NOT created by default when the CREATE DATABASE command is executed?

A. SYSCATSPACE

B. SYSTOOLSSPACE

C. TEMPSPACE1

D. USERSPACE1

Correct Answer: B

Question 7

Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?

A. RESTORE DATABASE

B. RESTORE TABLESPACE

C. ROLLFORWARD DATABASE

D. RESTART DATABASE

Correct Answer: A

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

Latest Update

Useful Links

Contact Us