XML Master Professional Database Administrator I10-003 Exam Questions

Select which of the following is not a correct description regarding dynamic context defined by XQuery 1.0.

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.

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

[XQuery]

{fn:doc("example.xml")/example/record/data[@condition="good"][2]}

{fn:doc("example.xml")/example/record/data[2][@condition="good"]}

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.

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.

Assume that perfect fidelity of a complete XML document is required in a certain XML document. Select the most suitable method for providing perfect XML document fidelity when storing an XML document using the following methods. Here "perfect XML document fidelity" means that an XML document retrieved from the XMLDB is exactly the same as the original XML document prior to XMLDB insertion, completely identical when compared using binary, including empty element notations, whitespace locations, etc.