C2090-611

C2090-611 practice questions, page 2 of 5, with answer review and explanations.

Question 6

Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

  1. db2set ALT_DIAGPATH=/db2data/db2dump2
  2. db2set SECONDARY_DIAGPATH=/db2data/db2dump2
  3. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
  4. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Question 7

What is the MAX_LOG database configuration parameter used for?

  1. To limit how many log files a single transaction can span.
  2. To limit the percentage of primary log space a running transaction can consume.
  3. To limit the total number of primary and secondary log files a database can consume.
  4. To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.

Question 8

What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

  1. CPU cycles
  2. Elapsed time, in milliseconds
  3. Processing instructions performed
  4. Timerons

Question 9

In IBM Data Studio, where can you schedule script-based jobs?

  1. Job Console
  2. Job Manager
  3. Task Manager
  4. Utilities Console

Question 10

The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows: What commands must be run to enable real-time statistics collection on the SAMPLE database?

  1. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
  2. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
  3. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
  4. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;