XML I10-003 - XML Master Professional Database Administrator Exam

Page:    1 / 8   
Total 39 questions

Four separate operating requirements and four individual storage management methods for XML document data are listed below.
Considering the general characteristics, which individual management method
([Management Methods]) combines most optimally with which requirement ([Operating
Requirements])?
[Operating Requirements]
1. Retrieve a portion of the XML document according to values in the XML document
2. Identify the XML document by unique values, and retrieve the entire XML document
3. Perform aggregation and statistical calculations of the values in the XML document
4. Continuously check the data types for the values in the XML document, and search through data using queries on the XML document
[Management Methods]
A) XML document file (text file) management via file system
B) Management via RDB (relational database), and program for storing data from an XML document into the RDB (assume the RDB does not maintain an XML document tree structure)
C) Management via XMLDB, using XML Schema definitions
D) Management via XMLDB, without using XML Schema definitions

  • A. A-4, B-2, C-1, D-3
  • B. A-1, B-2, C-4, D-3
  • C. A-2, B-1, C-4, D-3


Answer : A

Assume that a certain XMLDB requires disk capacity in excess of the size of an XML document when storing the XML document to accommodate XML node information and other information (such as management considerations, etc.)
The following describes the capacity needed:
When eliminating ignorable whitespace in the XML document 1.5 times the XML document file size
When not eliminating ignorable whitespace in the XML document 2.0 times the XML document file size
At the initial stage, the total size of the XML document files to be stored is 1GB.
At the operating stage, repeated additions and deletions of XML documents will result in a projected disk requirement of plus or minus 10% compared to the prior year.
Assume that the disk size configured at initial stage cannot be changed for two years.
The required disk capacity will be calculated according to these conditions; however, to provide a safety margin, the decision has been made to set aside the equivalent of twice the maximum required disk capacity as calculated above.
Select the value representing the required disk capacity when ignorable whitespace is not eliminated from the XML document.
Do not consider any facts or conditions other than those given above.

  • A. 3.3GB
  • B. 3.63GB
  • C. 4.4GB
  • D. 4.84GB


Answer : D

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]
<TestML>
<person> <name>John Smith</name>
<cellPhone>000-1111-2222</cellPhone>
</person>
</TestML>

  • 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>
  • D. This type of definition cannot be created using XML Schema


Answer : B

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> <recorddate="2007-05-16"> <data condition="bad">60</data> <data condition="good">90</data> <datacondition="good">150</data> </record> </result>
  • D. <result> <recorddate="2007-05-15"> <data condition="bad">50</data> <data condition="bad">80</data> <datacondition="good">250</data> </record> <recorddate="2007-05-16"> <data condition="bad">60</data> <data condition="good">90</data> <data condition="good"> 150</data> </record> </result>


Answer : D

Assume that you wish to create an XML Schema document against which [XML Document]
(referenced in a separate window) is valid.
Select which of the two answers below are correct as descriptions for (1) in the following
[XML Document]. Assume that the elements with namespace "um:xmlmaster division" or
"urrvxmtmaster:title' in [XML Document] have been property defined in separate XML
Schemas.

  • A. <xs:sequence> <xs:any namespace="##any" processContents="lax"/> <xs:element ref="tns:person"maxOccurs="unbounded"/> </xs:sequence>
  • B. <xs:sequence> <xs:any namespace="##other" minOccurs="0" maxOccurs="unbounded" processContents="lax"/> <xs:element ref="tns:person" maxOccurs="unbounded"/> </xs:sequence>
  • C. <xs:sequence> <xs:any namespace-'urn:xmlmaster: division urn:xmlmaster:title" processContents="lax"/> <xs:element ref="tns:person" maxOccurs="unbounded"/> </xs:sequence>
  • D. <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:any namespace="urrrxmlmaster:division um:xmlmaster:title" processContents="lax"/> <xs:element ref="tns:person"/> </xs:choice>


Answer : B,D

Page:    1 / 8   
Total 39 questions