IBM DB2 9.7 Advanced DBA for LUW 認定 000-544 試験問題:

1. Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?

A) CREATE UNIQUE INDEX xtab1 ON tab1 (c4, c3, c2, c1);
B) CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4);
C) CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3, c4);
D) CREATE UNIQUE INDEX xtab1 ON tab1 (c3) INCLUDE (c1, c2, c4);

2. Which tool or command will display only the automatic storage paths in an existing backup image?

A) db2dart
B) db2ckbkp
C) INSPECT
D) db2pd

3. Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?

A) DB2_SET_MAX_CONTAINER_SIZE
B) DB2_LIMIT_AS_CONTAINER_BLOCKS
C) DB2_TRUNCATE_AS_STORAGE
D) DB2_ALLOCATION_SIZE

4. Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

A) GET DATABASE CONFIGURATION
B) LIST INDOUBT TRANSACTIONS
C) GET CURRENT ACTIVE LOGFILE
D) LIST LOGFILES

5. A DBA migrating an existing database to DB2 9.7 wants to allow the primary and secondary recovery logs to be used with non-buffered IO. Which statement is true?

A) The DB2_LOGGER_NON_BUFFERED_IO registry variable must be set to AUTO.
B) This behavior is automatically enabled by default.
C) The DB2_LOGGER_AUTO_BUFFERED registry variable must be set to YES.
D) The DB2_LOGGER_BUFFERED registry variable must be set to OFF.

質問と回答：