Developing Microsoft SQL Server Databases — Question 13

You need to modify the Orders table to store the XML data used by the retailers.
Which statement should you execute?

Answer options

• A. ALTER Orders ADD originalOrder XML (ValidateOrder);
• B. ALTER Orders ADD originalOrder XML;
• C. ALTER Orders ADD originalOrder varchar(max);
• D. ALTER Orders ADD originalOrder varbinary(max);

Correct answer: D

Explanation

The correct answer is D because the Orders table needs to store XML data, which can be done using varbinary(max) to hold the binary representation of XML. Options A and B suggest adding XML directly, which may not be suitable for all XML data types, while option C uses varchar(max) which is not appropriate for XML storage.