You have a Microsoft SQL Azure database.
You have the following stored procedure:
You discover that the stored procedure periodically fails to update HR.Employees.
You need to ensure that HR.Employees is always updated when up_employees executes.
The solution must minimize the amount of time required for the stored procedure to execute and the number of locks held.
What should you do?
You Have A Micr 1 (48.75 KiB) Viewed 84 times
A. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SNAPSHOT
B. Add the following line of code to line 13: WITH (UPDLOCK)
C. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
D. Add the following line of code to line 08: WITH (UPDLOCK)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!