You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com stores information consumed by ABC.com’s e-commerce application via SQL
Azure.
You have generated a stored procedure, which is employed to read and modify the value of all the
goods offered on ABC.com’s e-commerce site. You have been instructed to make sure that while
the stored procedure executes, other transactions are prevented from updating goods information.
A.
You should consider setting the transaction isolation level of the stored procedure to Read
committed.
B.
You should consider setting the transaction isolation level of the stored procedure to
Repeatable read.
C.
You should consider setting the transaction isolation level of the stored procedure to Read
uncommitted.
D.
You should consider setting the transaction isolation level of the stored procedure to
Serializable.
Explanation:
http://technet.microsoft.com/en-us/library/ms173763.aspx
B – Repeatable read.
RR specifies that no other transactions can modify data that has been read by the current transaction until the current transaction completes.
I think the correct answer is
D (SERIALIZABLE)
Statements cannot read data that has been modified but not yet committed by other transactions.
No other transactions can modify data that has been read by the current transaction until the current transaction completes.
Other transactions cannot insert new rows with key values that would fall in the range of keys read by any statements in the current transaction until the current transaction completes.
Cannot be B (REPEATABLE READ) as it says : Other transactions can insert new rows that match the search conditions of statements issued by the current transaction.