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
Answer is A. Repeatable
+1
Seconded!
I go for B: Option A still allows for phantom reads. see also https://docs.oracle.com/cd/B19306_01/server.102/b14220/consist.htm
Although the link is from Oracle the theoretical uderpinnings are identical for Oracle and Microsoft.
nope
https://msdn.microsoft.com/en-us/library/ms709374(v=vs.85).aspx
“maintain data integrity including retrieving identical sets across reads in all
situations that use transactions”=> identical reads in all situations
min. isolation lvl for read identical result is ReadCommitted – soo answer D seems to be correct.