🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Only shared locks
  2. B.Exclusive (write) locks
  3. C.No locks
  4. 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 →