Which isolation level should you use?

You are developing an application that reads and writes data from a SQL Server database.
You need to ensure transactional data integrity.
Which isolation level should you use?

You are developing an application that reads and writes data from a SQL Server database.
You need to ensure transactional data integrity.
Which isolation level should you use?

A.
Serializable

B.
ReadCommitted

C.
ReadUncommitted

D.
Normal

Explanation:
Serializable provides the highest level of data integrity.
https://msdn.microsoft.com/en-us/library/system.data.isolationlevel(v=vs.110)



Leave a Reply 3

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


null

null

Wrong answer is highlighted. It is indeed “serializable” as stated in the explanation.

puvpul

puvpul

null is right

Larsen

Larsen

Answer is A, Serializable