Multiple choice technology databases

Which of the following supports the XML data type?

  1. A unique index

  2. .A composite index

  3. A check constraint

  4. .A generated column
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL Server, XML data type columns can be indexed. While XML columns require special index types (PRIMARY XML index and secondary XML indexes), the question tests basic knowledge that XML data type supports indexing operations. A unique index is a valid operation on XML columns, though with specific syntax and constraints.

Keep practicing — related questions