IBM C2090-614 Exam Questions & Answers

Which statement about compression dictionaries is FALSE?

A. Page-level dictionaries are stored in hidden rows within the table.

B. Table-level dictionaries are stored in hidden rows within the table.

C. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.

D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

Given the following CREATE TABLE statement:

Which statement is correct?

A. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

B. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:

The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production. At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?

A. Reduce the size of the BP_AUDITING buffer pool.

B. Increase the size of the BP_AUDITING buffer pool.

C. Change the page size of the BP_AUDITING buffer pool to 16 or 32 K.

D. Replace the BP_AUDITING buffer pool with a block-based buffer pool.