Database - SQL Server 2000 - Discussion

Discussion :: SQL Server 2000 - General Questions (Q.No.4)

4. 

The strictest transaction isolation level provided by SQL Server is called:

[A]. REPEATABLE READ.
[B]. SERIALIZABLE.
[C]. READ COMMITTED.
[D]. READ UNCOMMITTED.

Answer: Option B

Explanation:

No answer description available for this question.

Anand said: (Oct 21, 2010)  
Serializable only security mode thats why.

Pankaj Desai said: (Feb 20, 2015)  
The highest isolation level, serialize, guarantees that a transaction will retrieve exactly the same data every time it repeats a read operation, but it does this by performing a level of locking that is likely to impact other users in multi-user systems.

Whereas the lowest isolation level, read uncommitted, may retrieve data that has been modified but not committed by other transactions. All of the concurrency side effects can happen in read uncommitted, but there is no read locking or versioning, so overhead is minimized.

Gursimran said: (Sep 2, 2016)  
Thank you so much for explanation @Pankaj Desi.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.