IBM
C2090-312 · Question #5
What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?
The correct answer is A. KEEPDYNAMIC(YES) and CACHEDYN=YES. See the full explanation below for the reasoning.
Question
What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?
Options
- AKEEPDYNAMIC(YES) and CACHEDYN=YES
- BKEEPDYNAMIC(NO) and CACHEDYN=NO
- CKEEPDYNAMIC(NO) and REOPT(ALWAYS)
- DKEEPDYNAMIC(YES) and REOPT(ALWAYS)
How the community answered
(58 responses)- A83% (48)
- B5% (3)
- C9% (5)
- D3% (2)
Community Discussion
No community discussion yet for this question.