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

Which operation typically requires a Share (S) lock?

Answer options

• A. INSERT
• B. SELECT
• C. DELETE
• D. UPDATE

Correct answer: D

Explanation

The correct answer is D, as an UPDATE operation often requires a Share (S) lock to ensure that the data being modified is not simultaneously accessed by other transactions. Options A (INSERT), C (DELETE), and B (SELECT) typically do not require a Share (S) lock, as they either add new data or read existing data without the need for such a lock.