Knowledge check

Choose the best response for each of the following questions.

Check your knowledge

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.