Câu 38: 70-464: Developing Microsoft SQL Server 2012/2014 Databases

You need to modify usp_GetOrdersAndItems to ensure that an order is NOT retrieved by usp_GetOrdersAndItems while the order is being updated. What should you add to usp_getOrdersAndItems?

1. A. Add SET TRANSACTION ISOLATION LEVEL SERIALIZABLE to line 44 — đáp án hiện tại
2. B. Add WITH (UPDLOCK) to the end of line 42
3. C. Add SET TRANSACTION ISOLATION LEVEL SNAPSHOT to line 44
4. D. Add WITH (READPAST) to the end of line 42