最新的IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - 000-614免費考試真題

A. One composite clustering index and one dimension block index.

B. One composite block index and one unique index.

C. One index that serves as both the dimension block index and the composite block index.

D. One index that serves as both the dimension block index and the composite clustering index.

A. The first time the CREATE STOGROUP statement is executed.

B. The first time the database is accessed after the migration.

C. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.

D. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.

A. EXPLAIN_FROM_DATA

B. EXPLAIN_FROM_SECTION

C. EXPLAIN_FROM_CATALOG

D. EXPLAIN_FROM_ACTIVITY

A. The MON_GET_PAGE_ACCESS_INFO table function.

B. The MON_GET_BUFFERPOOL table function.

C. The BP_HITRATIO administrative view.

D. The BP_WRITE_IO administrative view.

A. It helps identify data access patterns to aid in storage planning.

B. It helps reduce storage costs for infrequently accessed data.

C. It helps reduce redundant I/O.

D. It helps improve data compression ratios.

A. SYSUSERDEFAULTWLM

B. DEFAULT_USER

C. SYSDEFAULTUSERWORKLOAD

D. SYS_DEFAULT_USER_WORKLOAD