Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
70-461 XML Copy

70-461 XML Copy

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
43 cards
()
Section 1

Preview this deck

ORDER BY

Front

1 / 43

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (43)

Section 1

(43 cards)

ORDER BY

Front

which clause does the FOR XML come after?

Back

FOR XML PATH

Front

What FOR XML option is described below? Allows you to manually define the XML returned. Uses standard XML XPath expressions to define the elements and attributes of the XML you are creating.

Back

An XML secondary index that is useful if your queries specify path expressions. It speeds up the exist() method better than the Primary XML index. Such an index also speeds up queries that use value() for a fully specified path.

Front

What is a path index?

Back

sys.sp_xml_preparedocument @hdoc OUTPUT, @xml sys.sp_xml_removedocument @hdoc

Front

What is the stored procedure used to prepare DOM presentation of XML? What is the stored procedure used to remove the DOM presentation?

Back

For, Let, Where, Order By, Return

Front

What are FLWOR expressions?

Back

primary XML index

Front

What is the first index that you create on an XML column called?

Back

Used for providing uniquely named elements and attributes in an XML document. Declared at the top to distinguish an XML document from different business areas, departments, companies, etc. Format: xmlns:co

Front

What are namespaces?

Back

A document with a predefined schema. Usually in XSD.

Front

What is a typed XML document?

Back

The direction of travel. For Example child::

Front

In XQuery, what is the axis?

Back

element-centric

Front

By default in FOR XML PATH mode, what is the default centric format?

Back

specifies the criterion for selecting nodes. For example: child::name

Front

In XQuery, what is the node test?

Back

WITH xmlnamespaces('[namespace name]' AS [Alias Name])

Front

In SQL, what is the syntax for specifying a namespace?

Back

@x.query('data(root/a/c)')

Front

What is the XQuery function to returns all the value for 3 for the following XML object? SET @x = ' <root> <a>1<c>3</c> <d>4</d> </a> <b>2</b> </root> '

Back

attribute-centric element-centric flag value of 11

Front

In the OPENXML flag parameter, what does a value of 1 indicate? What does a value of 2 indicate? How do you shred for xml that has both element-centric and attribute-centric values?

Back

@x.query('data(*)') * @x is an XML variable

Front

What is the XQuery function to returns all data values for an XML object?

Back

XQuery is much richer than XPath expressions, an older standard, which you can use for simple navigation only. With XQuery, you can navigate as with XPath; however, you can also loop over nodes, shape the returned XML instance, and much more.

Front

What's the high level difference between XPATh and XQuery

Back

idoc - An XML DOM document handle, returned by sp_xml_preparedocument rowpattern - An XPath expression to find the nodes you want to map to rows of a rowset returned flags - Mapping between XML nodes and rowset columns (optional)

Front

What are the parameters for the OPENXML function?

Back

attribute-centric fragment No

Front

By default, are the values of FOR XML RAW element-centric or attribute-centric? By default does this produce a document or fragment? Is this XML nested?

Back

Processing instructions, which are information for applications that process XML, are written similarly to elements, between less than (<) and greater than (>) characters, and they start and end with a question mark (?), like <?PItarget data?>

Front

What does a ? signify in XML?

Back

varchar/nvarchar

Front

What data type is passed to the XQuery .query function?

Back

The most widely used metadata description. XSD documents are XML documents that describe the metadata of other XML documents

Front

What is XSD (XML Schema Description)?

Back

FOR XML

Front

What clause is used to convert a query result set to XML?

Back

You have to use subqueries in the SELECT part of the query in the PATH mode. Subqueries have to return a scalar value in a SELECT clause

Front

In FOR XML PATH mode, how do you create XML with nested elements for child tables?

Back

Primary XML Indexes. They can only be created on tables with a clustered primary key.

Front

When creating XML index, what kind of indexes need to be created first?

Back

WITH

Front

In the OPENXML statement, what clause is used to describe the rowset returned and is similar to the CREATE TABLE statement?

Back

@x.query('*') * @x is an XML variable

Front

What is the XQuery function to returns the complete XML sequence for an XML object?

Back

, ROOT('[Root Name]')

Front

What FOR XML option allows you to specify a root element?

Back

Converting XML to tables.

Front

What is shredding XML?

Back

A document has a single root node

Front

What is the difference between an XML document and an XML fragment?

Back

FOR XML RAW

Front

What FOR XML option is described below? Every row from returned rowsets converts to a single element named row, and columns translate to the attributes of this element.

Back

An XML secondary index that is useful for queries that retrieve one or more values from individual XML instances by using the value() method.

Front

What is a property index?

Back

An XML secondary index that is useful if queries are value-based and the path is not fully specified or it includes a wildcard.

Front

What is a value index?

Back

Further narrows down the search. For example: [@name='Bob']

Front

In XQuery, what is the predicate?

Back

, TYPE To store the xml in an xml variable or in a table. Also when using sub queries and nesting.

Front

What is the directive in FOR XML to set the output to be of XML type? When would this be necessary?

Back

FOR XML Auto

Front

What FOR XML option is described below? Gives you nice XML documents with nested elements, and it is not complicated to use

Back

When elements have attributes. These values are enclosed in quotation marks.

Front

What is attribute-centric presentation?

Back

When XML values are in nested elements of the original element.

Front

What is element-centric presentation

Back

Prefix the alias name with the @ symbol.

Front

In FOR XML PATH mode how do you generate attribute-centric XML?

Back

, ELEMENTS

Front

What FOR XML option allows you to specify a element-centricity?

Back

You should use the XMLSCHEMA directive in the FOR XML clause.

Front

How can you get an XSD schema together with an XML document from your SELECT statement?

Back

PATH VALUE PROPERTY

Front

What are the types of secondary XML indexes that you can create after creating the primary index?

Back

The sequence of columns in the select clause and the sequence of items in the order by clause. They should be in a one-to-many order.

Front

What items need to be in order in a FOR XML Auto query to ensure proper nesting?

Back

OPENXML

Front

What function provides a rowset over in-memory XML documents by using Document Object Model (DOM) presentation?

Back