Question

Point out the wrong statement.

(a) Typed XML type and Untyped XML both have XML schema to validate the Data

(b) Typed XML type has advantage of storage and query optimizations where as Untyped XML type does not have this advantage

(c) Typed XML types can be validated at both client side and Server side where as Untyped XML types does not have option to validate on server side as they do not have any schema

(d) None of the mentioned

I had been asked this question at a job interview.

I would like to ask this question from Working With XML Data topic in section Beyond Relational of SQL Server

Answer 1

Correct answer is (a) Typed XML type and Untyped XML both have XML schema to validate the Data

To explain I would say: Untyped XML type is preferred in scenario when you have schema, but you do not want the server to validate the data.