IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 11:

  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.
  A. When the number of qualifying rows of the inner and outer table are both large.

• Question 12:

  DB2 does not take system checkpoints in which circumstance?

  A. During an application rollback.
  B. At the end of a successful restart.
  C. When switching from one active log data set to another.
  D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.
  A. During an application rollback.

• Question 13:

  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.
  B. REORG with SHRLEVEL CHANGE would automatically detect which threads need to be canceled before switch phase.

• Question 14:

  In which situation does adding a referential constraint place a table space containing data into check-pending status?

  A. When a primary key is defined on a table with no unique index.
  B. When a foreign key is defined on a table with the ENFORCED option.
  C. When a foreign key is defined on a table and a corresponding primary key has not been defined.
  D. When a foreign key is defined on a table with NOT ENFORCED option and a unique index has not been defined.
  B. When a foreign key is defined on a table with the ENFORCED option.

• Question 15:

  When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered to MEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?

  A. DB2 does not allow the command.
  B. DB2 applies the changes immediately.
  C. DB2 allows the command only if the table is empty.
  D. DB2 places the table space in AREOR (Advisory Reorg).
  D. DB2 places the table space in AREOR (Advisory Reorg).

• Question 16:

  What trace class will show deadlock information?

  A. Audit class 3.
  B. Statistic class 3.
  C. Accounting class 1.
  D. Performance class 8.
  B. Statistic class 3.

• Question 17:

  When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?

  A. DIAGNOSE
  B. DSN1COMP
  C. DSN1PRNT
  D. DSN1LOGP
  B. DSN1COMP

• Question 18:

  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.
  C. It is derived from the sysplex timer (store clock).

• Question 19:

  What would be a reason for altering the clustering index of a table?

  A. To increase free space.
  B. Because the clustering index has to match the primary index.
  C. To choose a clustering index to favor batch sequential processing.
  D. To choose a clustering index to promote sequential inserts at the end of the table space.
  C. To choose a clustering index to favor batch sequential processing.

• Question 20:

  Which DB2 trace has potentially the highest level of overhead, and should typically be run in specific situations and only for short durations?

  A. The DB2 audit trace.
  B. The DB2 statistics trace.
  C. The DB2 accounting trace.
  D. The DB2 performance trace.
  D. The DB2 performance trace.