XML I10-003 XML Master Professional Database Administrator Exam Practice Test

Select the correct result of executing the [XQuery] on [example xml] referenced in a separate window.

See separate windows.

Assume you wish to execute an XQuery on [example.xml] (separate window) to obtain [Output Result] (separate window).

Select the correct XQuery to obtain [Output Result],

Each data element of [Output Result] shows the number of data elements for each [example xml] record element having an attribute value equivalent to the condition attribute value.

Select the correct result of executing the [XQuery] on [example xml] referenced in a separate window.

See separate window.

A certain Web application displays user information according to user input via Web browser. The XML data managing user information is as shown in [example.xml] (separate window). The following [XQuery] is executed when the Web application retrieves user information from [example xml].

[XQuery]

{

fn:doc("example.xml")//data[userid = "(1)"][password = "(2)"]

}

At this time, the Web application completes the [XQuery] by replacing (1) and (2) with the user input character string, and executes the query.

No character escapes (e.g. convert "<" to "<") are performed for character string input by the user. Select two of the following that produces the query execution result in [Execution Result] (separate window) when the character string is as shown in each answer choice.

Consider the structure of XML when storing date information as XML data. You must aggregate data for each calendar year from this XML data. Assume that statistical values related to the storage and retrieval of date information in a certain XMLDB is as follows:

[Date Information XML Structure A]

2007-04-OK/date>

[Date Information XML Structure B]

2QQ741

[Statistical Values] (assumed)

The search for one date node (XML structure A) or one y node (XML structure B) takes one microsecond in either case, regardless of search path.

With respect to structure A, two microseconds are required for each date node to determine whether the date element value matches the search year.

With respect to structure B, one microsecond is required for each y node to determine whether they element value is the same as the search year value.

The number of date elements at the initial state is 2000.

The number of date elements will increase with future updates; however, this is not a consideration for this question.

Insertion of a new date element under structure A takes 10 microseconds.

Insertion of a new date element under structure B takes 20 microseconds.

Do not consider any facts or conditions other than those noted above.

When the average number of new date element insertions per month is 20, and the average number of calendar date information searches per month is 10, which is the most effective XML structure in improving overall execution efficiency for insertions and searches?

Assume that a certain XMLDB can be configured to [Simple Validation Mode] when inserting an XML document.

[Simple Validation Mode] checks for (1) through (4) below, and will not insert any non-conforming XML document into the XMLDB.

[Simple Validation Mode] does not check for anything other than (1) through (4) below.

[Simple Validation Mode]

(1) The XML document is a well-formed XML document

(2) No elements or attributes not declared in the XML Schema are present in the XML document

(3) Elements within the XML document follow the number of occurrences (root element (document element) must occur once) defined in the XML Schema

(4) Attributes within the XML document follow the allowed occurrences defined in the XML Schema

Select the correct result of inserting the following [XML Document] via [Simple Validation Mode] when using the [XML Schema] referenced in a separate window.

Assume that for [XML Document] referenced in a separate window, you wish to create an XML Schema document that defines that the value of the level attribute of the record element must be unique within the XML document, and further that the level attribute of the scenario element must reference the value of the level attribute of the record element.

[XML Document]

Select which answer correctly belongs in (1) of the [XML Schema] document below.