You have a Microsoft SQL Azure database. You have the following stored procedure: You discover that the stored procedur
Posted: Mon Oct 17, 2022 4:50 pm
You have a Microsoft SQL Azure database.
You have the following stored procedure:
You discover that the stored procedure periodically fails to update Person.Contact.
You need to ensure that Person.Contact is always updated when UpdateContact 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?
A. Add the following line of code to line 12: WITH (UPDLOCK)
B. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
C. Add the following line of code to line 08: WITH (UPDLOCK)
D. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SNAPSHOT
You have the following stored procedure:
You discover that the stored procedure periodically fails to update Person.Contact.
You need to ensure that Person.Contact is always updated when UpdateContact 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 (56.92 KiB) Viewed 107 times
B. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
C. Add the following line of code to line 08: WITH (UPDLOCK)
D. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SNAPSHOT