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: