1. Which method would you use to parse an xml data type that has been stored in a database into multiple columns?

a. value

b. nodes

c. modify

d. query

2.

Code example 18-1 16 XML Validation: XML instance must be a document.

(Refer to code example 18-1.) Which of the following SELECT clauses could you use to retrieve the value of the ErrorNumber attribute? Assume that the XML document in the example is stored in a column named ErrorData.

	a.	SELECT ErrorData.value('(Error/@ErrorNumber)[1]', 'int') AS ErrorNumber
	b.	SELECT ErrorData.value('(Error/ErrorNumber)[1]', 'int') AS ErrorNumber
	c.	SELECT ErrorData.value('(Error/ErrorNumber)', 'int') AS ErrorNumber
	d.	SELECT ErrorData.value('(Error/@ErrorNumber)', 'int') AS ErrorNumber

3. What can you use to convert relational data thats stored in a database to XML?

	a.	FORXML statement
	b.	FOR XML clause of the SELECT statement
	c.	OPEN XML clause of the SELECT statement
	d.	OPENXML statement

4.The highest-level element in an XML document is called the what?

	a.	child element
	b.	super element
	c.	parent element
	d.	root element