Google News
logo
SQL Server - Quiz(MCQ)
Which of the following mode has exclusive range and exclusive resource lock?
A)
RangeI_N
B)
RangeX_X
C)
RangeS_S
D)
RangeS_U

Correct Answer :   RangeX_X


Explanation : RangeX-X locks are exclusive resource locks acquired on Index key values from a specific range when the transaction modifies a key value from the Index.

Advertisement