nerdexam
IBM

C2090-312 · Question #132

Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?

The correct answer is C. The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC. See the full explanation below for the reasoning.

Question

Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?

Options

  • AThe dynamic statement cache is enabled.
  • BThe client application contains some explainable statements.
  • CThe PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC
  • DBoth PLAN_TABLE and DSN_STATEMENT_CACHE_TABLE exist on the DB2 server and the

How the community answered

(19 responses)
  • A
    5% (1)
  • B
    16% (3)
  • C
    74% (14)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice