You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
You are creating a database named PartsDB for information about part numbers and sales.
You create a table using the following statements:
CREATE TABLE PartsDB.Units
(
Id int CONSTRAINT UnitID PRIMARY KEY,
Information xml
);
You want the XML data in the Information column to have the root node of <Unit_Information>
How can you achieve this?
A.
By configuring an XML index.
B.
By configuring Data Definition Language (DDL) trigger.
C.
By configuring an XML schema collection.
D.
By configuring a Cursor.
Explanation: