You are writing a query that returns data from tables in a SQL Server 2005 database. Some of the data is stored in relational columns, and some of the data is stored in XML data type columns. Your query needs to return a relational result set that contains data from relational fields and attribute values from XML data type columns. Which two methods of the XML data type should you
use? (Each correct answer presents part of the solution. Choose two.)
A.
the value() method
B.
the exist() method
C.
the query() method
D.
the nodes() method
E.
the modify() method