Unit 8

Question 1

Consider the following code:

16
XML Validation: XML instance must be a document.

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.

Answer 1

SELECT ErrorData.value(‘(Error/@ErrorNumber)[1]’, ‘int’) AS ErrorNumber

Question 2

Which method would you use to split the nodes of the current xml data type into rows?

Answer 2

nodes()

Question 3

What is used to structure the data in an XML document?

Answer 3

XML Tags

Question 4

Code a statement that defines a variable named @EventData that can hold XML data

Answer 4

DECLARE @EventData xml;

Question 5

What is the name of the language that’s designed to query an XML document?

Answer 5

XQUERY

Question 6

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

Answer 6

root element

Question 7

An element that is contained within another element is called what?

Answer 7

child element

Question 8

Which statement do you use to add an XML Schema Definition to a database?

Answer 8

CREATE XML SCHEMA COLLECTION

Question 9

Consider the following code:

16
XML Validation: XML instance must be a document.

Which of the following statements could you use to determine if the @ErrorData variable contains the ErrorMessage element? Assume that the @ErrorData variable is declared with the xml data type and that it contains the XML data shown in the example.

Answer 9

IF @ErrorData.exist(‘/Error/ErrorMessage’) = 1

Question 10

When you use the Query Editor to run a query that returns an xml type, the Management Studio displays the XML data in blue with underlining to indicate that it is what?

Answer 10

a link

Question 11

You can code one or more ________________ within the start tag of an element.

Answer 11

attributes

Question 12

If you want to make sure that the data you attempt to store in the xml data type is valid, you can

Answer 12

specify an XSD for the xml data type when you define a column or variable

Question 13

Which of the following defines a table column named ErrorData that can contain XML data and that will be validated using an XML schema named ErrorDataSchema? Assume that the column can’t contain null values.

Answer 13

ErrorData xml (ErrorDataSchema) NOT NULL

Question 14

What can you call an element that contains other elements?

Answer 14

parent element

Question 15

What can you use to convert XML data into relational data?

Answer 15

OPENXML statement

Question 16

What can you use to create an XML Schema Definition for an XML document?

Answer 16

XML Editor

Question 17

What can you use to convert relational data that’s stored in a database to XML?

Answer 17

FOR XML clause of the SELECT statement

Question 18

What is the name of the language that’s designed to insert, update, or delete nodes from an XML document?

Answer 18

XML DML

Question 19

An XML schema can prevent all but one of the following from being stored in a column or variable declared with the xml type. Which one?

Answer 19

a null value

Question 20

What can you call the set of rules that an XML document must follow to be valid?

Answer 20

XML schema

Question 21

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

Answer 21

value()

Question 22

A well-formed XML document can have only one of which type of element?

Answer 22

root

Question 23

Which of the following INSERT statements inserts a row into a table named ErrorLog that consists of an identity column and a column that contains XML data?

Answer 23

INSERT INTO ErrorLog VALUES(‘An error occurred’);