PrepAway - Latest Free Exam Questions & Answers

which of the following will dynamically change the LOCK…

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST
database configuration parameter for a database named SAMPLE to AUTOMATIC?

PrepAway - Latest Free Exam Questions & Answers

A.
UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

B.
UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

C.
CONNECT TO sample;
UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE;
CONNECT RESET;

D.
ATTACH TO db2inst1;
UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;
DETACH;


Leave a Reply