See separate window.
[PRODUCTS xml] (separate window) and [STOCKLIST.xml] (separate window) are output in XML format from RDB (relational database) data.
Assume that you wish to use an XOuery processor to get [Output Result] (separate window) from this XML data.
Which of the following is an XOuery that cannot retrieve [Output Result]?
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 for which the condition attribute value is "good," and for which the element value is 100 or less. 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.
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.
Select which of the following is not a correct description regarding static context defined by XQuery I 0.
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 element must be unique within the XML document. Which of the following correctly describes the XML Schema document?
[XML Document]
100
250