IBM
C2090-312 · Question #172
Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
The correct answer is A. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in. See the full explanation below for the reasoning.
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
How the community answered
(37 responses)- A81% (30)
- B11% (4)
- C3% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.