This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the following questions.
What is the purpose of Multi-Version Concurrency Control (MVCC)?
MVCC blocks read access to a table if the table needs to be dropped or truncated.
MVCC allows multiple versions of PostgreSQL Flexible Server to access the same underlying database.
MVCC uses snapshots to prevent one transaction from blocking another or from another transaction blocking it.
What is the default isolation level in Azure Database for PostgreSQL?
Read uncommitted.
Read committed.
Repeatable read.
Transactions with what lock type are blocked when you run a SELECT statement?
SELECT statements block no other lock types.
ACCESS SHARE.
ACCESS EXCLUSIVE.
You must answer all questions before checking your work.
Was this page helpful?