XML I10-003 Exam Questions Instant Access

Question 1

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 2

Select which of the following is not a correct description regarding static context defined by XQuery I 0.

AStatic context is information that is available during static analysis of the query expression

BThe default initial values of static context components are all set to certain values in XQuery 1.0

CThe set value of XPath 1.0 Compatibility Mode (one of the static context components) must always be 'false'

DThe default element/type namespace component is included in static context

Answer : B

Question 3

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 4

A certain store engages in Internet commerce, managing customer information via XMLDB. Customers register as a user through a webpage, and are allowed to view their own information so they can edit their information themselves through a webpage interface. The store's Web application saves the customer information in an XMLDB, and retrieves data from the XMLDB as necessary. The XML data including customer information is as shown in [CUSTOMER.xml] referenced in a separate window.

The XMLDB account when the Web application connects to the XMLDB is WEBAPP.

A person at the store is in charge of processing payments (access to all registered customer information), and this person's XMLDB account is COUNTER.

A person at the store is in charge of product shipments (access to all registered customer information except for payment information ("payment element")), and this person's XMLDB account is SHIPPER.

Do not consider XMLDB accounts other than those noted above.

Each account authorization in the XMLDB is presently configured as follows: The WEBAPP account has permission to update and view [CUSTOMER xml]

Other accounts have permission to view [CUSTOMER.xml]

Which is the most appropriate method in this situation regarding XMLDB account authorizations'?

Assume that this XMLDB has a view creation function (function to show only certain XML data in response to a certain query)

AWhen saving data into the XMLDB, all user element content should be encrypted, and all XMLDB accounts should be given permission for decryption

BWhen saving data into the XMLDB, all payment element content should be encrypted, and only the COUNTER account should be given permission for decryption

CYou should create a view (PAYMENT_VIEW) to show only payment element information, providing the COUNTER account with permission to view PAYMENT_VIEW

DYou should create a view (SHIP_V1EW) to show information other than payment element information, providing the SHIPPER account with permission to view SHIP_V1EW, and prohibiting the SHIPPER account from viewing [CUSTOMER.xml]

Answer : D

Question 5

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 6

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