C2090-612

C2090-612 practice questions, page 3 of 6, with answer review and explanations.

Question 11

The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recent activity with no recent RUNSTATS execution?

  1. SYSIBM.SYSCOPY
  2. SYSIBM.SYSTABLES
  3. SYSIBM.SYSINDEXES
  4. SYSIBM.SYSTABLESPACESTATS

Question 12

Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

  1. The DB2 audit trace.
  2. The DB2 statistics trace.
  3. The DB2 connection trace.
  4. The DB2 accounting trace.

Question 13

What is a consideration when specifying DATA CAPTURE CHANGES?

  1. Can be specified for capturing changes to an XML object.
  2. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified.
  3. REFRESH TABLE statement is not allowed with a table defined with DATA CAPTURE CHANGES.
  4. You cannot turn on DATA CAPTURE CHANGES if the table space is in advisory REORGpending.

Question 14

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

  1. MINSTOR
  2. DSNDB07
  3. DSNDB01.SPT01
  4. DSN_STATEMNT_TABLE

Question 15

What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?

  1. KEEPDYNAMIC(YES) and CACHEDYN=YES
  2. KEEPDYNAMIC(NO) and CACHEDYN=NO
  3. KEEPDYNAMIC(NO) and REOPT(ALWAYS)
  4. KEEPDYNAMIC(YES) and REOPT(ALWAYS)