🎴 Flashcard Mode
DB2 Database Fundamentals Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?
AnswerClick to flip back
A
The row-level Share lock will automatically be converted to a row-level Up-date lock
💡 Explanation:
When an application holds a Share (S) lock on a row and wants to update it, DB2 automatically attempts to upgrade or convert the existing row-level Share lock to an Exclusive (X) or Update (U) lock. The application does not manually release it first.