PrepAway - Latest Free Exam Questions & Answers

Which isolation level shouldyou use?

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database. You
need to prevent the application from reading data that is locked by other transactions. You also need to prevent
exclusive range locks. Which isolation level shouldyou use?

PrepAway - Latest Free Exam Questions & Answers

A.
ReadCommitted

B.
Serializable

C.
Repeatable

D.
ReadUncommitted

Explanation:
SQL Server Isolation Levels
(http://msdn.microsoft.com/en-us/library/ms189122(v=sql.105).aspx)
(http://msdn.microsoft.com/en-us/library/ms173763.aspx)


Leave a Reply