PrepAway - Latest Free Exam Questions & Answers

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

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

PrepAway - Latest Free Exam Questions & Answers

A.
The dynamic statement cache is enabled.

B.
The client application contains some explainable statements.

C.
The PLAN_TABLE and DSN_STATEMENT_CACHE tables must be created using a EBCDIC
encoding scheme.

D.
Both PLAN_TABLE and DSN_STATEMENT_CACHE_TABLE exist on the DB2 server and the
table names are qualified with the current SQLID
that is used when running the application.

Explanation:


Leave a Reply