Google News
logo
SQL Server - Quiz(MCQ)
Which of the following mode indicates the intention of the transaction to read all of the resources lower in the hierarchy?
A)
IS
B)
IX
C)
SIX
D)
All of the above

Correct Answer :   SIX


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.

Advertisement