PrepAway - Latest Free Exam Questions & Answers

Which locking hint should you use to prevent users from modifying any data in the table while the stored proce

You have a stored procedure that is used to set up maintenance tasks. The stored procedure executes every night. The stored procedure contains three critical data manipulation language (DML) statements that operate against a single table. You need to prevent users from modifying any data in the table while the stored procedure executes. Which locking hint should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
NOLOCK

B.
READCOMMITTED

C.
REPEATABLEREAD

D.
TABLOCKX


Leave a Reply