XML Master Professional Database Administrator Practice Tests and PDFs

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

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

/wp-content/uploads/quiz-images/i10-003_Q5.png

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.