← Back to exam page

Free C2090-318 – DB2 12 System Administrator for z/OS Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 7 questions

Question 4

Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?

Select an option, then click Submit answer.

  • ○

    Parallelism for DPSI is disabled
  • ○

    The DB2 optimizer will not consider DPSI for access path selection
  • ○

    DB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism
  • ○

    DB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used
Question 5

To initiate a system checkpoint without modifying the current LOGLOAD value, which of the following should be issued?

Select an option, then click Submit answer.

  • ○

    -SET LOG BOTH
  • ○

    -SET LOG RESUME
  • ○

    -SETLOGLOGLOAD(O)
  • ○

    -SET LOG BOTH CHKTIME(10) LOGLOAD(500000)
Question 6

Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?

Select an option, then click Submit answer.

  • ○

    DWQT
  • ○

    VDWQT
  • ○

    VPSEQT
  • ○

    VPPSEQT