SQLConfiguration
SQLConfiguration
SiteMap
Database Creation
Cursors Views
Business Rules
Transactions Locks
«Prev
Next»
Business Rules
Transaction Locking
Transaction Isolation - Quiz
Error Handling Testing
Server Interaction
Assign Use Variables
SQL Raising Errors
SQL Server Functions
SQL-Server Triggers
SQL Triggers-Quiz
Enforcing Business Rules
Creating Triggers - Exercise
Testing SQLserver Trigger
Stored Procedures
Stored Procedures - Exercise
Stored Procedure - Quiz
Modifying Procedures
Error Handling
Accessing Remote Data
Enterprise Manager Server
Adding Remote Login
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 Servers 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
Correct answers:
Your Score: 0
Submit
Quiz Explanation