XML Master Professional Database Administrator I10-003 Exam Questions

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

{ fn:data($record/data) }

}

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

Assume that when inserting an XML document, a certain XMLDB can be configured to eliminate whitespace (ignorable white space such as line feeds, tabs, etc.) that is defined as [element content whitespace] in the XML Information Set (Infoset).

Select the correct description regarding the elimination of [Whitespace] when inserting the following [XML Document] under this whitespace elimination configuration.

Assume that a validation check is performed when the XML Document is inserted.

Assume that a certain XMLDB has an HTTP listener function, and can receive XML documents via HTTP protocol.

In this case, the XMLDB follows [Procedure] below to identify the character encoding method of the XML document received.

[Procedure]

(1) If the XML document character encoding method can be determined from the HTTP request header, process the XML document character encoding according to the HTTP request header information.

(2) If the XML document character encoding method cannot be determined from the HTTP request header, identify the character encoding from the XML document itself

Select which is correct as the identified character encoding resulting from the procedure above when the XMLDB receives a well-formed XML document according to [Conditions] below. Assume that the XMLDB follows RFC3023.

[Conditions]

The actual character encoding method for XML document is "UTF-16;" however, no XML declaration is specified.

The HTTP request header defines "Content-Type: text/xml." however, the charset parameter is not defined in this Content-Type header field.

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 from choices A through C the answer that is included in the result element as the result of executing the [XQuery] on [example.xml] referenced in a separate window. (multiple answers possible) For example, select only "B" if the child element of the result element is "B" only.

Assume that a certain XMLDB requires disk capacity in excess of the size of an XML document when storing the XML document to accommodate XML node information and other information (such as management considerations, etc.)

The following describes the capacity needed:

When eliminating ignorable whitespace in the XML document 1.5 times the XML document file size. When not eliminating ignorable whitespace in the XML document 2.0 times the XML document file size. At the initial stage, the total size of the XML document files to be stored is 1GB. At the operating stage, repeated additions and deletions of XML documents will result in a projected disk requirement of plus or minus 10% compared to the prior year. Assume that the disk size configured at initial stage cannot be changed for two years. The required disk capacity will be calculated according to these conditions; however, to provide a safety margin, the decision has been made to set aside the equivalent of twice the maximum required disk capacity as calculated above. Select the value representing the required disk capacity when ignorable whitespace is not eliminated from the XML document. Do not consider any facts or conditions other than those given above.