SQLConfiguration 





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 of his users are complaining that data is lost.
He does some research and finds out that his transactions are using the lowest isolation level. What level are his transactions using?
Please select the best answer.
  A. READ COMMITTED
  B. READ UNCOMMITTED
  C. REPEATABLE READ
  D. SERIALIZABLE

2. Margaret creates a transaction within a transaction. Her first (outermost) transaction rolls back data and the second (innermost) transaction commits data. What will be the outcome?
Please select the best answer.
  A. Both transactions are committed.
  B. Only the first (outermost) transaction is committed.
  C. Both transactions are rolled back.
  D. Only the second (innermost) transaction is committed.


3. If the SET IMPLICIT_TRANSACTIONS option is NOT set to ON, what will happen?
Please select the best answer.
  A. The database will not support implicit transactions.
  B. The database will support explicit transactions only.
  C. The database will support auto-commit transactions.
  D. The database will 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?
Please select the best answer.
  A. READ COMMITTED
  B. READ UNCOMMITTED
  C. REPEATABLE READ
  D. SERIALIZABLE
Score =
Correct answers:


Beginning T-SQLBeginning T-SQL