IBM Exam Questions

What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?

What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the
cache?

A.
KEEPDYNAMIC(YES) and CACHEDYN=YES

B.
KEEPDYNAMIC(NO) and CACHEDYN=NO

C.
KEEPDYNAMIC(NO) and REOPT(ALWAYS)

D.
KEEPDYNAMIC(YES) and REOPT(ALWAYS)

Explanation: