A2090-544 Online Practice Questions and Answers

Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

A. User-defined function calls will be disabled.

B. In a partitioned environment, infinite communications will be enabled between partitions.

C. In a partitioned environment, communications will not be buffered.

D. Non-fenced routines can be invoked, however automatic database maintenance will be disabled.

Which command CANNOT be used to explicitly build a compression dictionary for a table?

A. REORG

B. LOAD

C. INSPECT

D. IMPORT

Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?

A. SORTHEAP

B. SHEAPTHRES_SHR

C. SHEAPTHRES

D. SORTHEAP_SHR

What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?

A. Issue a RESTORE DATABASE command with the REDIRECT option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

B. Issue a RESTORE DATABASE command with the REDIRECT option;issue a RESTORE DATABASE command with the CONTINUE option;

C. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a RESTORE DATABASE command with the CONTINUE option;

D. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

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;

A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?

A. Code the application to issue a LOCK TABLE statement.

B. Code the application to issue a LOCK ROW statement.

C. Increase the group commit count.

D. Increase the size of the lock list.

What new security authorities have been introduced in DB2 V9.7?

A. WLMADM, ACCESSCTRL, SECADMIN

B. EXPLAIN, SECADMIN, DATAACCESS

C. SECADMIN, ACCESSCTRL, SQLADM

D. WLMADM, SQLADM, EXPLAIN

If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?

A. ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'

B. ALTER TABLESPACE tbsp1 ADD ('/db2/filesystem1')

C. ALTER DATABASE ADD STORAGE FOR tbsp1 ('/db2/filesystem1')

D. ALTER TABLESPACE tbsp1 EXTEND USING ('/db2/filesystem1')