nerdexam
IBM

C2090-312 · Question #192

When would DB2 NOT use list prefetch?

The correct answer is C. RUNSTATS TABLESPACE without table sampling. See the full explanation below for the reasoning.

Question

When would DB2 NOT use list prefetch?

Options

  • AFast log apply operations.
  • BReading leaf pages of a disorganized index.
  • CRUNSTATS TABLESPACE without table sampling.
  • DIncremental image copies of a table space defined with TRACKMOD YES.

How the community answered

(33 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    85% (28)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice