Google News
logo
SQL Server - Quiz(MCQ)
Which of the following part of the XML data stored in an XML column is very important for locking?
A)
Hierarchy
B)
Degree of Structure
C)
Granularity
D)
None of the above

Correct Answer :   Granularity


Explanation : When the granularity is large, locking large XML instances for updates causes throughput to decline in a multi user scenario.

Advertisement