D. You use the modify() method in the SET clause of an UPDATE statement to alter the content of an XML document. query() is used to return untyped XML from a positioned query. value() returns the SQL data from within the defined XML. exist() determines whether XML exists to match up with the positioned query provided. nodes() is used as the source for a query that returns multiple pieces of data for reporting purposes.
2.
B.value() returns the SQL data from within the defined XML. This would allow you to combine it with other SQL data. You use the modify() method within the SET clause of an UPDATE statement to alter the content of an XML document. query() is used to return untyped XML from a positioned query. exist() determines whether XML exists to match up with the positioned query provided. nodes() is used as the source for a query that returns multiple pieces of data for reporting purposes.
3.
D. The default setting for SQL batches that allow for ad hoc queries is disabled. In the preceding endpoint definition, no setting is supplied, and therefore the ad hoc query capability is turned off.
4.
B, D. To create a secondary XML index, you must first have a primary XML index created. The best secondary index in this scenario is for paths. An index configured for values would perform well in queries that do not provide path information. Queries based on multiple XML values would benefit from a properties index.
5.
D. The ELEMENTS keyword provides all the output in element format, with no attributes. XSINIL adds the namespace prefix to the resulting XML.