XML I10-003 - XML Master Professional Database Administrator Exam
Page: 3 / 8
Total 39 questions
Question #11 (Topic: )
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.
Select "A" and "CB if the child element of the result element is both A and C. If the result
element is an empty element, select answer "D."
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.
Select "A" and "CB if the child element of the result element is both A and C. If the result
element is an empty element, select answer "D."
A. <person name="John Smith"> <favorite item="color">blue</favorite> <favorite item="color">red</favorite> <favorite item-'pet">dog</favorite> </person>
B. <person name="Harold Jones"> <favorite item="color">yellow</favorite> <favorite item="color">red</favorite> <favorite item="fruit''>orange</favorite> </person>
C. <person name="Nancy Williams"> <favorite item="color">yellow</favorite> <favoriteitem="color">pink</favorite> <favoriteitem="color">light blue</favorite> </person>
D. The result element is an empty element
Answer: B
Question #12 (Topic: )
Select the correct result of executing the following [XQuery] on [example xml] referenced in
a separate window.
[XQuery]
<result>{
for $record in fn:doc("example.xml")/example/record
return
<record>{ fn:data($record/data) }</record>
}</result>
a separate window.
[XQuery]
<result>{
for $record in fn:doc("example.xml")/example/record
return
<record>{ fn:data($record/data) }</record>
}</result>
A. <result> <record>50</record> <record>60</record> </result>
B. <result> <record>5080250</record> <record>6090150</record> </result>
C. <result> <record>50 80 250</record> <record>60 90 150</record> </result>
D. An error occurs
Answer: C
Question #13 (Topic: )
Assume that you wish to improve the response time when executing the following [XQuery]
on a certain XMLDB.
Which one of the answers below is not an appropriate point to be checked?
Assume that the XMLDB does not have any automated optimization functions related to the
answer choices.
on a certain XMLDB.
Which one of the answers below is not an appropriate point to be checked?
Assume that the XMLDB does not have any automated optimization functions related to the
answer choices.
A. Revise the [XQuery] expression
B. Revise the configuration of the relevant XML data index
C. Investigate the disk capacity size used by the XMLDB
D. Investigate the influence of any exclusive access controls performed by other processes when executing the [XQuery]
Answer: C
Question #14 (Topic: )
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.
or constraint definitions for values using restriction of simple types.
A. Because XML Schema includes data types having infinite precision, you must consider consistency with the XMLDB implementation when you wish to use these data types
B. You must register a DTD with the XMLDB prior to using DTD-compatible XML Schema data types (xs:NMTOKEN,etc.)
C. You can define candidates of the value by using restriction of the XML Schema simple types
D. You can define a character string pattern for valid value with regular expressions by using restriction of the XML Schema simple types
Answer: B
Question #15 (Topic: )
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.
[XML-I10-003-6.0/XML-I10-003-25_2.png]
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.
[XML-I10-003-6.0/XML-I10-003-25_2.png]
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
