IBM
C2090-312 · Question #172
C2090-312 Question #172: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #172. The question stem and answer options stay visible for context.
Question
Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
Options
- AThe table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in
- BThe PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic
- CThe PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic
- DThe table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.