PrepAway - Latest Free Exam Questions & Answers

Which locking hint should you use?

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.
TABLOCKX

B.
NOLOCK

C.
READCOMMITTED

D.
REPEATABLEREAD


Leave a Reply