C2090-612 Online Practice Questions and Answers

If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?

A. The next sort step will perform two sorts.

B. There are multiple sorts in the plan step.

C. One sort in the plan step will accomplish two tasks.

D. Two sorts are performed on the new table of a star join.

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

A. MINSTOR

B. DSNDB07

C. DSNDB01.SPT01

D. DSN_STATEMNT_TABLE

When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?

A. DB2

B. RACF

C. USER

D. DEFINER

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.

In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?

A. Index

B. Table

C. Schema

D. Database

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

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)

Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?

A. Issue ALTER TABLESPACE with a valid SEGSIZE > 0

B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE > 0

C. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0

D. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0

Unnecessary REORGs of indexes may be avoided by which of the following?

A. Use the SYSIBM.SYSINDEXSPACESTATS table.

B. Use the REPORT utility to determine the degree of organization.

C. Use the CHANGELIMIT keyword when creating an image copy of the index.

D. Use the CHECK INDEX utility to find out if the index needs to be reorganized.

Using the -SET LOG command, what logging characteristics CANNOT be modified?

A. The number of minutes between the start of successive checkpoints.

B. Add a newly defined active log data set to the active log inventory.

C. Altering DB2 from dual active logging mode to single active logging mode.

D. The number of log records that DB2 writes between the start of successive checkpoints.