nerdexam
IBM

C2090-619 · Question #20

Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

The correct answer is D. AUTO_READAHEAD. See the full explanation below for the reasoning.

Question

Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

Options

  • ADIRECT_IO
  • BDBUPSPACE
  • CAUTO_AIOVPS
  • DAUTO_READAHEAD

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    8% (3)
  • C
    17% (6)
  • D
    72% (26)

Community Discussion

No community discussion yet for this question.

Full C2090-619 Practice