Complete the code to describe the main purpose of MVCC.
MVCC helps to manage [1] in database systems.
MVCC stands for Multi-Version Concurrency Control, which helps manage concurrent access to the database by multiple users without conflicts.
Complete the sentence to explain how MVCC handles reads.
In MVCC, readers see a [1] of the data without waiting for writers to finish.
MVCC provides readers with a consistent snapshot of the data, so they can read without being blocked by writers.
Fix the error in the statement about MVCC's version management.
MVCC stores only a single [1] of each data item to handle concurrency.MVCC stores multiple versions of data items, not just a single one, to allow concurrent access without locking.
Fill both blanks to complete the MVCC transaction behavior.
A transaction in MVCC reads data from [1] and writes create [2].
In MVCC, transactions read from a snapshot of the database and writes create new versions of data to avoid conflicts.
Fill all three blanks to describe MVCC's conflict resolution.
MVCC resolves conflicts by [1] old versions, [2] transactions, and [3] snapshots.
MVCC keeps old versions, isolates transactions, and uses snapshots to manage concurrent access without locking.