Transactions Locks «Prev  Next»

Transactions and Isolation Levels - Quiz

Each question is worth one point. Select the best answer for each question.
 
1. Fred finds out that many users are reporting inconsistent query results. He discovers the session is using the lowest isolation level. Which isolation level is being used?
Please select the best answer.
  A. READ COMMITTED
  B. READ UNCOMMITTED
  C. REPEATABLE READ
  D. SERIALIZABLE

2. Margaret creates a transaction within a transaction. The outer transaction rolls back, and the inner transaction commits. What is the outcome?
Please select the best answer.
  A. Both transactions are committed.
  B. Only the outer transaction is committed.
  C. All work is rolled back.
  D. Only the inner transaction is committed.

3. If SET IMPLICIT_TRANSACTIONS is NOT ON, what happens by default?
Please select the best answer.
  A. Implicit transactions are required for SQL Server to support transactions.
  B. Only explicit transactions are supported.
  C. The session uses autocommit behavior by default.
  D. SQL Server does not support transactions.

4. What is SQL Server’s default isolation level?
Please select the best answer.
  A. READ COMMITTED
  B. READ UNCOMMITTED
  C. REPEATABLE READ
  D. SERIALIZABLE

5. Which isolation level has the highest risk of blocking (among these choices)?
Please select the best answer.
  A. READ COMMITTED
  B. READ UNCOMMITTED
  C. REPEATABLE READ
  D. SERIALIZABLE