IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 131:

  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.

  Correct Answer: C

• Question 132:

  What IBM provided stored procedure will access DB2 real time statistics tables?

  A. DSNAEXP

  B. DSNAIMS

  C. DSNACCOX

  D. DSNLEUSR

  Correct Answer: C

• Question 133:

  The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?

  A. Filter factor information.

  B. Stage 1 and stage 2 information.

  C. Number of columns used in an index.

  D. Number of times an SQL statement is executed.

  Correct Answer: D

• Question 134:

  Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)

  A. Append

  B. Inline LOBs

  C. Member cluster

  D. Volatile table

  E. Include columns

  Correct Answer: AC