We're so confident of our products that we provide no hassle product exchange.
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
1. Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?
A) The MON_GET_EXTENT_MOVEMENT_STATUS table function.
B) The MON_GET_ACTIVITY_DETAILS table function.
C) The MON_DB_SUMMARY administrative view.
D) The MON_BP_UTILIZATION administrative view.
2. Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?
A) One composite clustering index and one dimension block index.
B) One index that serves as both the dimension block index and the composite block index.
C) One composite block index and one unique index.
D) One index that serves as both the dimension block index and the composite clustering index.
3. In which situation would you NOT use a redirected restore?
A) To move table space containers onto different physical devices.
B) To restore a backup image from one operating system to another.
C) To restore a backup image to a target machine that is different from the source machine.
D) To redefine the paths of a defined storage group.
4. You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?
A) Issue a LIST UTILITIES statement with the 'SUSPEND <utility ID>' option specified.
B) Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.
C) Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.
D) Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.
5. The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
A) CREATE INDEX sales_idx ON sales (region)
B) CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
C) CREATE INDEX sales_idx ON sales (region, sales_person)
D) CREATE INDEX sales_idx ON sales (sales_person)
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: B | Question # 5 Answer: C |
By Julius
