DRAG DROP -
You plan to deploy two stored procedures name USP_1 and USP_2 that read data from a database.
Your company identifies the following requirements for each stored procedure:
✑ USP_1 cannot allow dirty reads.
✑ USP_2 must place range locks on the data to ensure read consistency.
You need to identify which isolation level you must set for each stored procedure. The solution must minimize the number of locks.
Which isolation level should you identify?
To answer, drag the appropriate isolation level to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
Select and Place:
Drag Drop You P 1 (38.52 KiB) Viewed 103 times
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!