Answers to Exam Prep Questions


1.

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.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net