Question

Which of the following statement would import additional schema or schema components into an existing collection object?

(a) IMPORT XML SCHEMA COLLECTION

(b) ALTER XML SCHEMA COLLECTION

(c) UPDATE XML SCHEMA COLLECTION

(d) ADD XML SCHEMA COLLECTION

I have been asked this question in an interview.

My question is based upon Working With XML Data in chapter Beyond Relational of SQL Server

Answer 1

The correct answer is (b) ALTER XML SCHEMA COLLECTION

Explanation: ALTER XML SCHEMA COLLECTION adds new schema components to an existing XML schema collection.