Which isolation level should you use?

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity including retrieving identical sets across reads in all situations that
use transactions.
Which isolation level should you use?

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity including retrieving identical sets across reads in all situations that
use transactions.
Which isolation level should you use?

A.
Repeatable

B.
Serializable

C.
ReadUncommitted

D.
ReadCommitted

Explanation:
REPEATABLE READ
Specifies that statements cannot read data that has been modified but not yet committed by other
transactions and that no other transactions can modify data that has been read by the current
transaction until the current transaction completes.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


nex-54

nex-54

Is this correct?
What about phantom reads? Shouldn’t we use Serializable?

LT-83

LT-83

Yep it is repeatable read.

PIEL

PIEL

B, phantom reads