nerdexam
IBM

C2090-312 · Question #182

What is necessary in order to enable optimization hints?

The correct answer is A. ASYSIBM.PLAN_TABLEtable. See the full explanation below for the reasoning.

Question

What is necessary in order to enable optimization hints?

Options

  • AASYSIBM.PLAN_TABLEtable.
  • BINSERT authority on SYSIBM.SYSQUERY table.
  • CA required index on the PLAN_TABLE used for optimization hints.
  • DADSN USERQUERY TABLE table under the schema in which hints will be created.

How the community answered

(55 responses)
  • A
    76% (42)
  • B
    7% (4)
  • C
    13% (7)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice