← Quiz: Concurrency Control: all 10 questions
Quiz: Concurrency Control · Question 7 of 10
In strict 2PL, which locks are held until the transaction commits or aborts?
In strict 2PL, which locks are held until the transaction commits or aborts?
- A.Only shared locks
- B.Exclusive (write) locks
- C.No locks
- D.Only locks on indexes
Answer & explanation
Correct answer: Exclusive (write) locks
Holding write locks to the end stops others reading uncommitted data, so there are no cascading rollbacks.
Can you get the rest right without peeking?
Take the timed Quiz: Concurrency Control quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →