C2090-612 Online Practice Questions and Answers

What START TRACE command provides detailed lock suspend and lock contention trace information?

A. START TRACE(AUDIT)

B. START TRACE(STATS) CLASS(1)

C. START TRACE(PERFM) CLASS(30) IFCID(44,45)

D. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)

Which statement is NOT true?

A. REORG table space to materialize pending definition changes for a table space.

B. REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase.

C. DSNACCOX can be used for collecting data for table space and index space for getting recommendations when to run REORG, RUNSTATS or COPY.

D. REORG of index space could be eliminated because the list prefetch of index leaf pages in DB2 V10 is based on non-leaf page information.

When is a merge scan join a well performing access path?

A. When the number of qualifying rows of the inner and outer table are both large.

B. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

C. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

D. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.

Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL statement cache?

A. MERGE

B. INSERT

C. SELECT

D. OPEN

When is changing an index from non-clustering to clustering NOT allowed?

A. If the table space is defined as member cluster.

B. If the data is not ordered by the new clustering index.

C. If the new clustering index is for a table that uses hash organization.

D. If the new clustering index OBID is greater than the old clustering index OBID.

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 statement about encoding schemes is correct?

A. A view can have columns with different encoding schemes.

B. A table can have columns with different encoding schemes.

C. A table space can have tables with different encoding schemes.

D. All objects in the subsystem must use the same encoding schemes.

Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);

A. The index must be partitioned.

B. The index must use page size > 4K.

C. The index must be defined as UNIQUE.

D. The index must be defined as CLUSTER.