Select the correct result of executing the following [XQuery] on [example xml] referenced in a separate window.
[XQuery]
for $record in fn:doc("example.xml")/example/record
return
}
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.
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 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.
A certain store engages in Internet commerce, managing customer information via XMLDB. Customers register as a user through a webpage, and are allowed to view their own information so they can edit their information themselves through a webpage interface. The store's Web application saves the customer information in an XMLDB, and retrieves data from the XMLDB as necessary. The XML data including customer information is as shown in [CUSTOMER.xml] referenced in a separate window.
The XMLDB account when the Web application connects to the XMLDB is WEBAPP.
A person at the store is in charge of processing payments (access to all registered customer information), and this person's XMLDB account is COUNTER.
A person at the store is in charge of product shipments (access to all registered customer information except for payment information ("payment element")), and this person's XMLDB account is SHIPPER.
Do not consider XMLDB accounts other than those noted above.
Each account authorization in the XMLDB is presently configured as follows: The WEBAPP account has permission to update and view [CUSTOMER xml]
Other accounts have permission to view [CUSTOMER.xml]
Which is the most appropriate method in this situation regarding XMLDB account authorizations'?
Assume that this XMLDB has a view creation function (function to show only certain XML data in response to a certain query)
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!