IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 44

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

Answer options

• A. No other applications can access the table
• B. Only uncommitted read (UR) applications can access the table
• C. The lock owner and other applications can read, but not update, the locked table
• D. The lock owner can both read and update data. Other applications can read the table
• E. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Correct answer: A, E

Explanation

Option A is correct because a super exclusive (Z) lock prevents any other applications from accessing the locked table. Option E is also correct, as this type of lock is indeed acquired during specific situations like altering or dropping the table or its index. The other options are incorrect because they describe access permissions that are not applicable under a super exclusive (Z) lock.