Exercises

1.	What is the document maximum size of an SQL Server XML data type? 1GB 3GB 4GB Unlimited None of the above
2.	Which of these is a method allowing changes to data within an XML data type? exist() exists() change() modify() update()
3.	Which of these are valid XML data type methods ? exist() exists() change() query() update()
4.	Which are valid modes for the FOR XML clause? RAW AUTO PATH EXPLICIT All of the above
5.	What does XSD stand for? X-ray Definitional Schema XML Definitional Schema XML Schema Definition None of the above All of the above

Answers

1.	Exercise 1 solution e. None of the above is the correct answer. The document physical size limitation on XML data types in a SQL Server database is 2GB. I did manage to bulk load an XML document of over 4GB but I had a few problems with some aspects of SQL Server functionality other than loading.
2.	Exercise 2 solution d. modify() is the correct answer. The modify() method allows changes to the XML document data stored within an XML data type.
3.	Exercise 3 solution a. exist() and d. query() are both correct answers. The exist() method checks for the existence of XML data type data. The exists() method is a misspelling of the exist() method and thus does not exist. The modify() method allows changes to XML data type data, and thus c. change() and e. update() are both non-existent methods. The query() method allows retrieval and data from XML data types.
4.	Exercise 4 solution e. All of the above is the correct answer. RAW mode returns a single XML element for each record returned by a query. AUTO mode is more sophisticated than RAW mode, returning a single layer of nested elements for each table in a join query. EXPLICIT mode allows for complete control over how XML is displayed, allowing for return of properly structured XML document hierarchical data. PATH mode is a more sophisticated and easier to use option than EXPLICIT mode.
5.	Exercise 5 solution c. XML Schema Definition is the correct answer. Obviously all other answers are therefore incorrect. An XSD (XML Schema Definition) can be used to generically impose schema structure onto an XML data type, using a SQL Server schema collection.