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

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 which of the following is not a correct description regarding XQuery 1.0 or SOL standards.

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 which of the following is not a correct description regarding XML Schema data types or constraint definitions for values using restriction of simple types.

Assume that you wish to improve the response time when executing the following [XQuery] on a certain XMLDB. Which one of the answers below is not an appropriate point to be checked? Assume that the XMLDB does not have any automated optimization functions related to the answer choices.

See separate window.

Assume you wish to execute a query on [example.xml] (separate window) to obtain a record element that includes a data element having a value equal to or greater than 100 and less than 200. Select the correct result of executing the [XQuery] (separate window). The expected result would be "C;" however, the query may not be processed as expected.

Assume that [testmixsd] (referenced in a separate window) has been defined. Without rewriting this XML Schema Document ([testml-xsd]), create a new, separate XML Schema Document to partially change the schema definition replacing the phone element with a cellPhone element. As a result, the following [XML Document] will be valid against the new schema.

Which of the following correctly descnbes the new XML Schema Document?

Assume that the XMLDB or XML parser correctly processes the XML Schema schema Location attribute.

[XML Document]

John Smith

000-1111-2222