XML I10-003 Exam Questions Instant Access

Question 1

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 element must be unique within the XML document. Which of the following correctly describes the XML Schema document?

[XML Document]

100

250

AOption A

BOption B

COption C

DOption D

Answer : B

Question 2

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

AXQuery 1.0 defines a method to output data within RDB (relational database) tables in XML format

BXQuery 1.0 does not define a method for partially updating XML data

CSQL2003 (ISO/EC 9075) defines a method to output data within RDB (relational database) tables in XML format

DSQL2003 (ISO/EC 9075) does not define a method for partially updating XML data

Answer : A

Question 3

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) }

}

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>

DAn error occurs

Answer : D

Question 4

Assume the use of XML Data like [XML Data] referenced in a separate window. When a data element is present in XML Data, there are three possibilities for b element as shown in [XML Data b Element] (separate window). No other possibilities are available.

Consider inserting any XML data into an XMLDB using the methods shown in [Operation 1] or [Operation 2].

[Operation 2]

After validating against the following [DTD], insert XML data (having no validation errors) into the XMLDB (do not consider the existence of a document type declaration in the XML data).

When the b element value is "null", the value of the b element is null.

When the b element value is a character string other than "null", the b element value is 1 in [XML Data b Element].

When the b element is an empty element, the b element value is 2 in [XML Data b Element].

[DTD]

AUnder the method described in [Operation 1], the three possibilities may not be clearly identified in some circumstances

BUnder the method described in [Operation 2], the three possibilities may not be clearly identified in some circumstances

CThe methods in [Operation 1] and [Operation 2] can clearly identify the three possibilities

DThe methods in [Operation 1] and [Operation 2] cannot clearly identify the three possibilities

Answer : B

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 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.

A<result/>

B<result>
<record date='2007-05-15'>
<data condition='bad'>50</data>
<data condition='bad'>80</data>
<data condition='good'>250</data>
</record>
</result>

C<result>
<record date='2007-05-16'>
<data condition='bad'>60</data>
<data condition='good'>90</data>
<data condition='good'>150</data>
</record>
</result>

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>

Answer : D

Question 6

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.

ARevise the [XQuery] expression

BRevise the configuration of the relevant XML data index

CInvestigate the disk capacity size used by the XMLDB

DInvestigate the influence of any exclusive access controls performed by other processes when executing the [XQuery]

Answer : C

Question 7

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

A<result/>

B<result>
<record/>
<record/>
</result>

C<result>
<record>
<name/>
</record>
<record>
<name/>
</record>
</result>

D<result>
<record>
<name>John Smith</name>
</record>
<record>
<name>Harold Jones</name>
</record>
</result>

Answer : A

XML Master Professional Database Administrator I10-003 Exam Questions