XML I10-003 Exam Practice Test Instant Access

Question 1

Assume that [testmixsd] (referenced in a separate window) has been defined. Without rewriting this XML Schema Document ([testml-xsd]), create a new, separate XML Schema Document to partially change the schema definition replacing the phone element with a cellPhone element. As a result, the following [XML Document] will be valid against the new schema.

Which of the following correctly descnbes the new XML Schema Document?

Assume that the XMLDB or XML parser correctly processes the XML Schema schema Location attribute.

[XML Document]

John Smith

000-1111-2222

A<xs:schema xmlns:xs='http://www.w3.org/2001/XMLSchema'>
<xs:import schemaLocation='testml.xsd' />
<xs:element name='cellPhone' type='xs:string' />
</xs:schema>

B<xs:schema xmlns:xs='http://wvwv.w3.org/2001/XMLSchema'>
<xs:include schemaLocation='testmLxsd' />
<xs:element name='cellPhone' substitutionGroup='phone' type='xs:string' />
</xs:schema>

C<xs:schema xmlns:xs='http://www.w3.org/2001/XMLSchema'>
<xs:redefine schemaLocation-'testml.xsd'>
<xs:element name='cellPhone' base='phone' type='xs:string' />
</xs:redefine>
</xs:schema>

DThis type of definition cannot be created using XML Schema

Answer : B

Question 2

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

[XQuery]

{fn:doc("example.xml")/example/record/data[@condition="good"][2]}

{fn:doc("example.xml")/example/record/data[2][@condition="good"]}

A<result>
<data condition='good'>90</data>
<data condition='good'>90</data>
</result>

B<result>
<data condition='good'> 150</data>
<data condition='good'> 150</data>
</result>

C<result>
<data condition='good'>90</data>
<data condition='good'> 150</data>
</result>

D<result>
<data condition='good'>150</data>
<data condition='good'>90</data>
</result>

Answer : D

Question 3

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]?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 4

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.

ABecause XML Schema includes data types having infinite precision, you must consider consistency with the XMLDB implementation when you wish to use these data types

BYou must register a DTD with the XMLDB prior to using DTD-compatible XML Schema data types (xs:NMTOKEN, etc.)

CYou can define candidates of the value by using restriction of the XML Schema simple types

DYou can define a character string pattern for valid value with regular expressions by using restriction of the XML Schema simple types

Answer : B

Question 5

Select the correct result of executing the [XQuery] on [example xml] referenced in a separate window. Do not consider indents (ignorable white space such as line feeds, tabs, etc.) in [example.xml] or the execution results.

A<result>
<dept>Sales Department</dept>
<name>John Smith</name>
<dept>Engineering Department</dept>
<name>Harold Jones</name>
</result>

B<result>
<dept>Sales Department</dept>Sales Department
<name>John Smith</name>John Smith
<dept>Engineering Department</dept>Engineering Department
<name>Harold Jones</name>Harold Jones
</result>

C<result>
<dept>Sales Department</dept>Sales Department
<group/>
<title/>
<name>John Smith</name>John Smith
<dept>Engineering Department</dept>Engineering Department
<name>Harold Jones</name>Harold Jones
</result>

D<result>
<dept>Sales Department</dept>Sales Department
<group>Group No1</group>
<title>Group Leader</title>
<name>John Smith</name>John Smith
<dept>Engineering Department</dept>Engineering Department
<name>Harold Jones</name>Harold Jones
</result>

Answer : D

Question 6

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 attribute of the record element must be unique within the XML document, and further that the level attribute of the scenario element must reference the value of the level attribute of the record element.

[XML Document]

Select which answer correctly belongs in (1) of the [XML Schema] document below.

AOption A

BOption B

COption C

DOption D

Answer : D

Question 7

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.

ADo not create an index

BCreate an index for $A/@type

CCreate an index for $B/@type

DCreate an index for both $A/@type and $B/@type

Answer : B

XML I10-003 XML Master Professional Database Administrator Exam Practice Test