You have a table that contains an XML column named XMLDatal. The column contains the
following nodes: • Title • Description • Author • Weight • NumPages You need to design a
stored procedure that will return only the title and description in a tabular result set. The
solution must be developed by using minimum amount of effort. How should you extract the
information?

A.
Use FOR XML PATH in a select statement.

B.
Use XMLDatal.Exists () in a select statement.

C.
Execute sp_preparedocument.

D.
Use XMLDatal.Query () in a select statement.

Explanation: