Limited-Time Offer: Enjoy 50% Savings! Ends in 00h 00m 00s Coupon code: 50OFF
Skip to content

Free XML Master Professional Database Administrator I10-003 Exam Questions

Page: 1 / 7 Total 39 questions

Want more questions? Get Premium Access.

Question 1

Assume that a certain XMLDB can perform a validation check using DTD when inserting an XML document. Select two of the following that are unsuitable when using the xml:id attribute to manage the uniqueness of XML document elements. Assume that the XMLDB can properly process the xml:id attribute, and that an error is reported when a violation of the xml:id specification occurs.

Correct Answer: B. Duplication errors in the values of the xml:id attribute cannot be detected unless a validation check is performed; D. Duplication errors in the values of the xml:id attribute cannot be detected when the XMLDB does not support XML namespaces

Question 2

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

Correct Answer: B. <result> <example> <record> <data>80</data> </record> <record> <data>90</data> </record> </example> </result>

Question 3

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.

Correct Answer: D. Whitespace of neither (1) nor (2) is removed

Question 4

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.

Correct Answer: D. <result> <record date='2007-05-15'> <data condition='bad'>50</data> <data condition='bad'>80</data> <data condition='good'>250</data> </record> <record date='2007-05-16'> <data condition='bad'>60</data> <data condition='good'>90</data> <data condition='good'> 150</data> </record> </result>

Question 5

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.

Correct Answer: D. <result> <record date='2007-05-15'> <data condition='bad'>50</data> <data condition='bad'>80</data> <data condition='good'>250</data> </record> <record date='2007-05-16'> <data condition='bad'>60</data> <data condition='good'>90</data> <data condition='good'> 150</data> </record> </result>

Question 6

Select which of the following is not a correct description regarding XQuery 1.0 or SOL standards.

Correct Answer: A. XQuery 1.0 defines a method to output data within RDB (relational database) tables in XML format