Specifying locking hints in which parameter in an SQL clause can modify locking behavior in SQL Server?
A)SELECT
B)WITH
C)LOCK
D)HINT

Question

Quizplus · Accepted Answer

Locking hints are specified in the WITH clause in SQL Server. This allows for greater control over the locking behavior during query execution. The WITH clause can be used in various SQL statements such as SELECT, UPDATE, DELETE, and INSERT. Options such as NOLOCK, READPAST, and UPDLOCK can be specified to modify the locking behavior.

Specifying Locking Hints in Which Parameter in an SQL Clause