Which isolation level uses multiversion concurrency control (MVCC) snapshots to present a consistent view of the database as of the transaction start time?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

Which isolation level uses multiversion concurrency control (MVCC) snapshots to present a consistent view of the database as of the transaction start time?

Key points

  • SNAPSHOT isolation level utilizes MVCC snapshots for consistency
  • PostgreSQL's MVCC implementation uses REPEATABLE READ for this purpose
  • MVCC ensures transactions see a snapshot of the database at the start time
  • This prevents data changes affecting the transaction's view

Ready to go further?

Start full exam Practice more questions

Related questions