Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress…

You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail? A. Simple table space with one table. B. Segmented table space with one table. C. Classic partitioned table space with one…

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create? A. 1 B. 4 C. 5 D. 6

What is a potential consideration when using triggers? A. They are not invoked by the LOAD REPLACE utility. B. When using views, the underlying tables cannot have a trigger defined. C. RI and check constraints are evaluated prior to any…

In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used? A. GBP32 B. SCA C. LOCK D. GBP0

Which DSNZPARM parameter controls the number of locks that may be acquired on a table space? A. NUMLKUS B. MAXUSRS C. NUMLKTS D. MXDTCACH

If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts? A. SYSADM B. DBADM C. SECADM D. INSTALL SYSOPR

Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table? A. Using a view. B. Using a VALIDPROC. C. Using multi-level security. D. Using masks and permissions.

You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized? A. Audit trace class(4) B. Monitor trace class(6) C. Performance trace class(3) D. Accounting trace class(1,2,3,7,8)

The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be…