Explanation:SIX stands for Shared with intent exclusive and can modify some (but not all) resources lower in the hierarchy by placing IX locks on those individual resources. 9. Which of the following lock is incompatible with all lock modes ?
A. Intent exclusive (IX)
B. Schema stability
C. Schema modification
D. Bulk update
Answer:A
Explanation:SIX stands for Shared with intent exclusive and can modify some (but not all) resources lower in the hierarchy by placing IX locks on those individual resources. 9. Which of the following lock is incompatible with all lock modes ?
A. Intent exclusive (IX) B. Schema stability C. Schema modification D. Bulk update
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 ?