nerdexam
IBM

C2090-610 · Question #140

What is the purpose of the Query Tuner?

The correct answer is B. To provide recommendations and analysis for tuning a single query. See the full explanation below for the reasoning.

Question

What is the purpose of the Query Tuner?

Options

  • ATo automatically capture and stop rogue queries.
  • BTo provide recommendations and analysis for tuning a single query.
  • CTo provide recommendations and analysis for tuning up to 100 queries.
  • DTo recommend indexes and to guide DBAs through the process of creating new indexes.

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    80% (16)
  • C
    10% (2)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice