🎙 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 10 of 10

Why do MVCC databases let long reports run without blocking updates?

Why do MVCC databases let long reports run without blocking updates?

  1. A.Readers see an older committed version of rows while writers create new versions
  2. B.Reports are run without any transaction
  3. C.Updates are queued until the report ends
  4. D.MVCC uses exclusive locks for reads
Answer & explanation

Correct answer: Readers see an older committed version of rows while writers create new versions

Keeping multiple versions means readers and writers do not wait for each other.

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 →