70-464 Question 1

Developers report that usp_UpdateSessionRoom periodically returns error 3960.

You need to prevent the error from occurring. The solution must ensure that the stored
procedure returns the original values to all of the updated rows.

What should you configure in Procedures.sql?

A. Replace line 46 with the following code:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLEB.
B. Replace line 46 with the following code:
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
C. Move the SELECT statement at line 49 to line 57.
D. Move the SET statement at line 46 to line 53.

Answer: A



Category: 70-464 Exam Questions

you are at 70-464 Question 1

For more questions you can browse 70-464 Exam Questions.

Recent Post