Question

Can we use untyped XML data type in the following situations?

(a) You have schema for your XML data and you want the server to validate your XML data according to the XML schema

(b) You want to take advantage of storage and query optimizations based on type information

(c) You want to take better advantage of type information during compilation of your queries

(d) You do not have a schema for your XML data

I got this question in final exam.

Enquiry is from Working With XML Data topic in division Beyond Relational of SQL Server

Answer 1

The correct option is (d) You do not have a schema for your XML data

The best explanation: Untyped XML type does not have schema.