Select the correct result of executing the [XOuery] on [example xml] referenced in a separate window.
Answer : A
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"]}
Answer : D
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.
Answer : B
An [XQuery] was executed to join [eventList.xml] and [sessionUst.xml] (referenced in a separate window) and obtain the following [Expected Execution Result].
However, executing this [XQuery] resulted in an error.
Answer : C
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]
Answer : B
Consider the execution of [XQuery] as referenced in a separate window.
Assume that the following index is used when executing this [XQuery] on a certain XMLDB.
[Index Usage Standards] (assumed)
Use only the most efficient index when an index for both $A/@type and $B/@type is created.
If only one index is created, use that index.
Do not use an index if none is created.
Assume the following circumstances regarding the statistical values related to the execution of this [XQuery].
[Statistical Value] (assumed)
When creating an index for $A/@type, the response time when updating $A/@type data is one millisecond longeron average.
When creating an index for $B/@type. the response time when updating $B/@type data is one millisecond longeron average.
When creating an index for either $A/@type or$B/@type, or when creating an index for both, the response time of [XQuery] execution is at least two milliseconds shorter on average.
Of all of the values of $A/@type, the rate of inclusion of identical values is 1% on average. Of all of the values of $B/@type, the rate of inclusion of identical values is 2% on average. The ratio of $A/@type data update, $B/@type data update, and [XQuery] execution is 1:1:1 on average.
When the number of data items for both $A/@type and $B/@type are extremely large and almost identical, which is the most effective method for improving overall execution efficiency? Assume that this XMLDB has no other automated optimization functions than those described above. Assume that no other queries are executed.
Answer : B
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.
Answer : B, F