MVCC Internals: Snapshots Quiz Home › PostgreSQL DBA › MVCC Internals: Snapshots 🔄 Postgres Database Administration – MVCC Internals: Snapshots 20 questions · 15 min timer · Explanations included · Free 1. In PostgreSQL's MVCC model, what is the primary purpose of a transaction snapshot? To manage the allocation of transaction IDs. To ensure data consistency across distributed databases. To optimize query execution plans. To determine the visibility of tuples for a transaction. None Show Hint A snapshot in MVCC is used to determine which tuples are visible to a transaction, ensuring consistency and isolation. 2. Which PostgreSQL command is used to manually trigger the cleanup of old tuples to prevent transaction ID wraparound? VACUUM CHECKPOINT ANALYZE REINDEX None Show Hint The VACUUM command is used to clean up old tuples and prevent transaction ID wraparound by freezing tuples. Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Click Submit to see your final score! Previous Start Quiz Next Time's up
