Xml 70-461

Front 1

XML stands for _ ?

Back 1

eXtensible Markup Language

Front 2

What was XML designed for?

Back 2

XML was designed to transport and store data, with focus on what data is, not how it is displayed and looks.

XML does not DO anything. XML was created to structure, store, and transport information.

Front 3

What are the components of XML?

Back 3

The characters making up an XML document are divided into markup and content.

Markup: like “<contact-info>” and “&” Describes the structure.
-Tag
-Element
-Attribute

Content: like “Jane Smith” and “[phone]”.
Also known as text or character data
Text is the document's content.

Sometimes markup can also represent content, as in the case of references

Front 4

What is an XML Tag?

Back 4

Tag - A markup construct that begins with < and ends with >. Tags signify the opening and closing of an element or attribute.
Tags come in three flavors:

start-tags; for example: <section>
end-tags; for example: </section>
empty-element tags; for example: <line-break />

Front 5

What is an XML Element?

Back 5

Element - The logical units of information in an XML document. They begin with a start-tag and end with a matching end-tag or consists only of an empty-element tag.
An example of an element is:
<Greeting>Hello, world.</Greeting>. with Hello World being content.
Another is <line-break /> this is an empty element.

Front 6

What is an XML Attribute?

Back 6

Attribute - An attribute specifies a single property for an element, using a name/value pair. XML tags also are used to mark the start and end of Attributes.
XML attribute values must be quoted – using "..." or '…'

<img src="madonna.jpg" alt='Foligno Madonna, by Raphael' /img>

Front 7

How is an XML structure generally described and why?

Back 7

XML documents form a tree structure that starts at "the root" and branches to "the leaves".
<class_list> root element or parent
<student> element or child
<name>Robert</name> sub_element or subchild
<grade>A+</grade> sub_element or subchild
</student>
<class_list/>

Front 8

What is the one element that all XML documents must contain?

Back 8

XML documents must contain a root element. This element is "the parent" of all other elements.

Front 9

When using XML, is case sensitivity important>

Back 9

Yes! - XML is case sensitive unicode taext.

Front 10

How do you retrieve the results of a SQL query as XML?

Back 10

By specifying the FOR XML clause in the query.

Front 11

What are the four modes of a FOR XML clause?

Back 11

RAW
AUTO
EXPLICIT
PATH

Front 12

Explain the RAW mode

Back 12

The RAW mode generates a single <row> element per row in the rowset that is returned by the SELECT statement. You can generate XML hierarchy by writing nested FOR XML queries.

Front 13

Explain the AUTO mode

Back 13

The AUTO mode generates nesting in the resulting XML by using heuristics based on the way the SELECT statement is specified. You have minimal control over the shape of the XML generated. The nested FOR XML queries can be written to generate XML hierarchy beyond the XML shape that is generated by AUTO mode heuristics.