Quiz: read committed

Q1. For a SELECT query running under read committed, locks are held….

  •  For the duration of the statement
  •  For the duration of the transaction
  •  For a very short time
  •  Until the Deadlock Monitor wakes up
For a very short time

Q2. SELECT queries running under read committed like to use….

  •  Exclusive locks
  •  Key range locks
  •  Shared locks
  •  Schema modification locks
Shared locks

Q3. Queries running under read committed may read the same row multiple times.

  •  True
  •  False
True

Q4. Queries running under read committed may miss some rows and not read them at all.

  •  True
  •  False
True

Q5. Queries running under read committed always use row level locks.

  •  True
  •  False
The engine may decide to start with a page level lock, and lock escalation is possible as well.

Q6. Fill in the blank: Read committed is a transaction ______ level in SQL Server.

isolation

Q7. Read committed is the default isolation level in SQL Server, EXCEPT in…

  •  Azure SQL Database
  •  SQL Server Failover Cluster Instances
  •  SQL Server RDS (Amazon)
  •  On-premises SQL Server installations
Azure SQL Database. Note: there’s an additional correct answer not in this list, which is readable secondaries in Availability Groups! Check out the course on Snapshot Isolation Against Readable Secondaries for more information on that.
Back to: Read Committed is Bonkers – Webcast Recording (46 minutes) > Quiz

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu