📝 Question
#1741
Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
✓
Correct Answer
A. Higher-level lock
💡
Explanation
Operations acquire lower-level locks while they execute, but release them when they complete; the corresponding transaction must however retain a higher-level lock in a two-phase manner to prevent concurrent transactions from executing conflicting actions.
⌨️ Press
A
B
C
D
to select