On what type of index would an ALTER INDEX ADD COLUMN be allowed?

A. An XML index.

B. An auxiliary index.

C. A user defined catalog index.

D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.

The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used to gather the I/O information needed for the objects in database NEWBILL?

A. START TRACE(AUDIT) PLAN(NEWBILLPL)

B. START TRACE(IO) CLASS(ALL) PLAN(NEWBILLPL)

C. START TRACE(PERFM) CLASS(3) PLAN(NEWBILLPL)

D. START TRACE(ACCT) CLASS(1,2,3) PLAN(NEWBILLPL)

In using plan stability, what storage space requirement should be of carefully monitored?

A. MINSTOR

B. DSNDB07

C. DSNDB01.SPT01

D. DSN_STATEMNT_TABLE

How do you enable parallelism in a dynamic SQL statement?

A. BIND with DEGREE(1)

B. BIND with DEGREE(ANY)

C. Use SET CURRENT DEGREE = ANY

D. Use SET CURRENT DEGREE = '1'

What is the maximum levels of backup that DB2 plan stability can support?

A. 1

B. 2

C. 3

D. 4

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.

What must be done in order to audit read access to a table?

A. AUDIT ALL must be set on the table and an audit trace must be started.

B. An EDITPROC must be defined on the table and an audit trace must be started.

C. DATA CAPTURE CHANGES must be set on the table and the DB2 log must be captured.

D. A security label column should be defined on the table within a trusted context.

What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);

A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.

B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.

C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.

D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.

The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?

A. It shows how many keys are rejected when issued during the SORTBLD phase.

B. It shows the elapsed time of the SWITCH phase when issued during the SWITCH phase.

C. It indicates how many parallel tasks are involved to build indexes when issued during the BUILD phase.

D. It shows an actual and estimated time of how far it has proceeded in the current iterations when issued during the LOG phase.

In a data sharing environment, how is the LRSN value created?

A. It is selected from the DB2 catalog.

B. It is generated from a sequence object.

C. It is derived from the sysplex timer (store clock).

D. It is derived from combining RBAs from multiple members.