Question

Limitations of the XML Data Type are:
1. It cannot be compared or sorted. This means an XML data type cannot be used in a GROUP BY statement.
2. It cannot be used as a key column in an index.
3. The value() method of the XML data type returns a scalar value, so it can be specified anywhere where scalar values are allowed
4. All of the options

Answer 1

Correct Answer - Option 4 : All of the options

The correct answer is option 4.

Limitations of XML,

•  It can't be used as a SQL variant instance's sub instance.
• It cannot be compared or sorted. 
• The stored representation of XML data type instances can't exceed 2 GB.
• It can't be used as key coloumn in an index.
• It can't be used as paramenter to any scalar, built-in functions.
• XML Elements can be nested upto 128 levels.

Hence all options correct. 

 

• XML is not designed for access speed, it can't be used as a subtype. XML documents are structured to be loaded in their entirety before being used as a database. Any time the parser reads in the markup, it has to do a syntax check. Modern databases, on the other hand, are designed for fast data updates and lookups.qlvariant instance.
• XML syntax is verbose and redundant compared to other text-based data transmission formats such as JSON.