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?

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?

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 0

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