You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01.
You have received instruction from the CIO to write a query that returns data from tables in a Certkiller -DB01. Several data is stored in relational columns and in XML data type columns. You need to write a query that return a relational result set that consists of data from relational fields and attribute values from the XML data type columns.
Which methods should you use? (Choose all that apply)
A.
The exist() method should be used receive a relational result.
B.
The nodes() method should be used receive a relational result.
C.
You should make use of the query() method to receive a relational result.
D.
You should make use of the modify() method to receive a relational result.
E.
You should make use of the value() method.
Explanation:
query() – Provides the ability to execute an XPATH or XQUERY expression and returns the resulting XML fragment.
value() – Provides the ability to execute an XPATH or XQUERY expression and returns a single scalar value that is converted into a SQL type. exist() – Provides the ability to execute an XPATH or XQUERY expression to check for the existence of nodes. If the query returns a node collection, the exist() methods returns true; otherwise, the exist() method returns false.
modify() – Provides XML data-manipulation capabilities. nodes() – Provides the ability to execute an XPATH or XQUERY expression and returns the resulting XML fragment shredded into row set.