XML I10-003 Exam Practice Test Instant Access

Question 1

See separate window.

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

AOption A

BOption B

COption C

DOption D

Answer : B

Question 2

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 3

Assume that a certain XMLDB can store an XML document as a model based on DOM Level2, and can retrieve the stored XML data via XQuery. Also assume that you wish to store the following [XML Document] in the XMLDB, and treat the script element content as a CDATA section when retrieving the XML data from the XMLDB. Select the most appropriate description regarding the following [Procedure].

Assume that the XMLDB follows the DOM Level2 specification, as well as specifications related to XQuery.

[Procedure]

(1) Store [XML Document] in XMLDB

(2) Retrieve the stored XML data via XQuery (at this stage the XML data has not been serialized as a character string)

(3) Serialize the XML data as a character string

AUnder Procedure (1), the script element content will no longer be a CDATA section; accordingly, the script element content must be designated as a CDATA section under Procedure (2)

BUnder Procedure (1), the script element content will no longer be a CDATA section; accordingly, the script element content must be designated as a CDATA section under Procedure (3)

CUnder Procedure (1), the script element content is a CDATA section; however, under Procedure (2), the script element content will no longer be a CDATA section. Accordingly, the script element content must be designated as a CDATA section under Procedure (3)

DThe script element content is a CDATA section through Procedure (1), (2) and (3)

Answer : C

Question 4

Assume that perfect fidelity of a complete XML document is required in a certain XML document. Select the most suitable method for providing perfect XML document fidelity when storing an XML document using the following methods. Here "perfect XML document fidelity" means that an XML document retrieved from the XMLDB is exactly the same as the original XML document prior to XMLDB insertion, completely identical when compared using binary, including empty element notations, whitespace locations, etc.

AStore the XML document as a model based on XPath 1.0

BStore the XML document as a model based on XML Information Set (Infoset)

CStore the XML document as a BLOB (Binary Large Object) type with no character encoding method defined

DStore the XML document as an NCLOB (National Character Large Object) type for which UTF-8 has been defined as the character encoding method

Answer : C

Question 5

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.

AWhitespaces of both (1) and (2) are removed

BWhitespace of (1) is removed; whitespace of (2) is not removed

CWhitespace of (2) is removed; whitespace of (1) is not removed

DWhitespace of neither (1) nor (2) is removed

Answer : D

Please Wait...

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

Question 1

Question 2

Question 3

Question 4

Question 5

Please Wait...

Popular Vendors

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

Question 1

Question 2

Question 3

Question 4

Question 5