Which isolation level should recommend?

You need to recommend an isolation level for usp_UpdateOrderDetails.

Which isolation level should recommend?
A . Read committed
B . Repeatable read
C . Read uncommitted
D . Serializable

View Answer

Answer: B

Explanation:

* Scenario: Databasel will also contain a stored procedure named usp_UpdateOrderDetails. The stored procedure is used to update order information. The stored procedure queries the Orders table twice each time the procedure executes. The rows returned from the first query must be returned on the second query unchanged along with any rows added to the table between the two read operations.

* REPEATABLE READ

Specifies that statements cannot read data that has been modified but not yet committed by other transactions and that no other transactions can modify data that has been read by the current transaction until the current transaction completes.