Advanced SQL
Q86 / 100

What problem does "MVCC" (Multi-Version Concurrency Control), used by databases like PostgreSQL and MySQL InnoDB, solve?

Correct! Well done.

Incorrect.

The correct answer is B) It allows readers to see a consistent snapshot of data without blocking writers (and vice versa) by maintaining multiple versions of rows, avoiding many lock contention issues

B

Correct Answer

It allows readers to see a consistent snapshot of data without blocking writers (and vice versa) by maintaining multiple versions of rows, avoiding many lock contention issues

Explanation

MVCC keeps multiple row versions so that read operations can proceed against a consistent snapshot while writes create new versions, reducing the need for read locks and improving concurrency.

Progress
86/100