PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply