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