Question 26

Answer B is correct. modify() is used to specify XML DML statements to perform updates. query() is used to query over an XML instance, value() is used to retrieve a value of SQL type from an XML instance, exist() is used to determine whether a query returns a non-empty result, and nodes() is used to shred XML into multiple rows to propagate parts of XML documents into rowsets.

For more information, see the following sources:

• Chapter 4, "Supporting the XML Framework"

• SQL Server 2005 Books Online: "SQL Server Database Engine, Using XML in SQL Server, xml Data Type, xml Data Type Methods"

• "XML Options in Microsoft SQL Server 2005," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5xmloptions.asp

• "XML Support in Microsoft SQL Server 2005," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5xml.asp

• Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, XML Best Practices for Microsoft SQL Server 2005.