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

Question

Quizplus · Accepted Answer

Locking hints can be specified in the WITH clause of an SQL statement in SQL Server. This allows for greater control over the locking behavior of the query, which can improve performance in certain scenarios. The other options listed (SELECT, LOCK, TRANS, HINT) do not have a specific parameter for specifying locking hints.

Specifying Locking Hints in Which Parameter in an SQL Clause