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)- A5% (1)
- B16% (3)
- C74% (14)
- D5% (1)
Community Discussion
No community discussion yet for this question.