C2090-612 Online Practice Questions and Answers

Which DSNZPARM will define the number of RID Blocks in the RID Pool?

A. NUMTCB

B. MAXRBLK

C. CONDBAT

D. URLGWTH

A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?

A. Add a new index on COL4.

B. Perform a ALTER INDEX IX1 ADD COLUMN (COL4).

C. Add a new UNIQUE index on COL1, COL2, COL3, COL4.

D. Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).

The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing threads in DB2. Which command could assist in identifying the remote locations from where such threads were triggered?

A. -DISPLAY LOCATION(*) DETAIL

B. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL

C. -DIS THD(*) TYPE(INACTIVE) LOCATION(*) DETAIL

D. -DIS THD(*) TYPE(POSTPONED) LOCATION(*) DETAIL

Which DB2 performance feature is designed specifically to reduce the number of indexes that need to be created?

A. Inline LOBs.

B. Include columns.

C. Hash row access.

D. Direct row access.

Which DSNZPARM parameter controls the number of locks that may be acquired on a table space?

A. NUMLKUS

B. MAXUSRS

C. NUMLKTS

D. MXDTCACH

DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?

A. The DB2 subsystem was at some point in in NFM.

B. The DB2 subsystem can still fall back to DB2 Version 8.

C. Coexistence is allowed with a DB2 9 data sharing group member.

D. The asterisk (*) indicates objects created in NFM can no longer be accessed.

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 of the following does NOT make a view a read-only view?

A. The outer fullselect contains a GROUP BY clause.

B. The first SELECT clause specifies the keyword DISTINCT.

C. The only table referenced is a system maintained temporal table and a period-specification is specified.

D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.

For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

A. Catalog tables

B. Directory tables

C. Auxiliary tables

D. Declared global temporary tables

An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?

A. Issue a RECOVER POSTPONED command.

B. Issue a START command with ACCESS(RW).

C. Recycle the system with the system parameter LBACKOUT=NO.

D. Issue a STOP command and then a START command with ACCESS(RW).