100% Pass Guarantee with IBM A2090-544 Dumps!

Which command will prevent prefetching during crash recovery?

A. db2set DB2_AVOID_PREFETCH=OFF

B. db2set DB2_AVOID_PREFETCH=ON

C. db2set DB2_RECOVERY_PREFETCHING=NO

D. db2set DB2_RECOVERY_PREFETCHING=YES

Given a database created as follows:

If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/ foreign key relationship between column C1 in table T1, and column C1 in table T2?

A. CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

B. CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;

C. CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

D. CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k;

The table STORESALES was created with the following statement:

Which is true when the following statement is executed? CREATE UNIQUE INDEX index_partIDcustID ON storesales (partID, custID)

A. A unique partitioned index is created successfully.

B. A unique non-partitioned index is created successfully.

C. The index creation fails because it does not contain the column from the table partitioning key.

D. A non-unique partitioned index is created successfully.