Explanation:SQL Server allows only one Sch-M lock on an object at a time. 10. Which of the following mode has exclusive range and exclusive resource lock ?
A. RangeX_X
B. RangeS_U
C. RangeS_S
D. RangeI_N
Answer:A
Explanation:SQL Server allows only one Sch-M lock on an object at a time. 10. Which of the following mode has exclusive range and exclusive resource lock ?
A. RangeX_X B. RangeS_U C. RangeS_S D. RangeI_N
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. Sanfoundry Global Education & Learning Series – SQL Server.