PrepAway - Latest Free Exam Questions & Answers

Which two methods of the XML data type should you use?

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.)

PrepAway - Latest Free Exam Questions & Answers

A.
the value() method

B.
the exist() method

C.
the query() method

D.
the nodes() method

E.
the modify() method


Leave a Reply