Copyright © 2019 Pearson Education, Inc.
Database Processing, 15e (Kroenke)
Appendix I: XML
1) XML is an acronym for Extended Markup Language
Answer: FALSE
2) The most popular way to materialize XML documents is to use Extensible Style Language:
Transformations.
Answer: TRUE
3) A stylesheet is used by XSLT to indicate how to transform the elements of the XML
document into another format such as HTML.
Answer: TRUE
4) XML Schema is the preferred method for defining SQL structures.
Answer: FALSE
5) Documents that conform to their schema are called schema-validate.
Answer: TRUE
6) Simple elements can have attributes.
Answer: TRUE
Copyright © 2019 Pearson Education, Inc.
7) Simple elements have a single data item, whereas complex elements contain other elements
that can be either simple or complex.
Answer: TRUE
8) In a Flat versus Structured Schema, a Flat Schema contains all of the row elements at the same
level.
Answer: FALSE
9) Schemas are sometimes called structured schemas because they add structure to table
columns.
Answer: TRUE
10) Using the SQL declaration FOR XML EXPLICIT, you can cause SQL Server to place some
columns into elements and other rows into attributes.
Answer: FALSE
11) SQL Server uses the order of the tables in the FROM clause to determine the hierarchical
placement of the attributes in the generated XML document.
Answer: FALSE
12) An XML document may have as many multivalued paths as an application requires.
Answer: TRUE
Copyright © 2019 Pearson Education, Inc.
13) Materialization of a document is expressed in an XML document, whereas content is
expressed in an XSL document.
Answer: FALSE
14) XML will continue to be an important data interchange format for rational databases but not
non-relational ones.
Answer: FALSE
15) XML is short for ________.
A) Extended Markup Language
B) Extreme Markup Language
C) Extensible Markup Language
D) External Markup Language
Answer: C
16) XML is a subset of _______.
A) SGML
B) SXML
C) XSLT
D) HTML
Answer: A
Copyright © 2019 Pearson Education, Inc.
17) In regard to XML, which of the following statements is NOT true.
A) Database processing and document processing need each other.
B) Database processing needs document processing for transmitting database views.
C) Document processing needs database processing for storing and manipulating data.
D) Database processing needs XML to process data in a database.
Answer: D
18) As a markup language, XML is significantly better that HTML in all the following ways
except ________.
A) XML provides a clean separation between document structure, content, and materialization.
B) XML has facilities for dealing with document structure, content, and materialization even
though they are confounded.
C) XML is standardized allowing for extension by developers.
D) XML eliminates the inconsistent tag used that is possible with HTML.
Answer: B
19) A stylesheet is used ______.
A) by XSLT to indicate how to transform the elements of the XML document into another
format.
B) by XSLT to indicate how to transform one document into another document.
C) by XSLT to find a command element to tag
D) by XSLT to transform an HTML document into an XML document.
Answer: A
20) Select the correct statement below.
A) XML Schema is the preferred method for defining database structure.
B) XML Schema is the preferred method for defining document structure.
C) XML Schema is a narrow and simple topic for defining document structure.
D) XML Schema is a broad-based method not used to define the document structure.
Answer: B
Copyright © 2019 Pearson Education, Inc.
21) XML nameplates are used to _________.
A) combine different attributes into the same XML schema
B) combine different stylesheets into the same XML schema
C) combine different elements into the same XML schema
D) combine different vocabularies into the same XML schema
Answer: D
22) By default, the cardinality of both simple and complex elements is ______.
A) 1:1
B) 1:N
C) N:1
D) N:M
Answer: A
23) XML makes a clear separation between all of the following except _______.
A) structure
B) content
C) vocalization
D) materialization
Answer: C
24) Suppose we construct an XML document that has all of the View Ridge Gallery customer
data including purchase data and artist interests. To obtain this data VRG constructs a view that
includes _______.
A) one single path
B) two single paths
C) two multivalued paths
D) three multivalued paths
Answer: C
Copyright © 2019 Pearson Education, Inc.
25) The statement SQL Server 2017 uses to work with XML is ______.
A) SELECT….TO XML
B) SELECT….FROM XML
C) SELECT….OF XML
D) SELECT….FOR XML
Answer: D
26) It is possible to cause SQL Server to place the values of the columns into __________ rather
than attributes.
A) structures
B) elements
C) schemas
D) namespaces
Answer: B
27) Explain what XML provides.
Answer: XML provides a standardized yet customizable way to describe the content of
28) Explain the difference between Document Type Declarations (DTDs) and XML Schema.
Answer: Document Type Declarations were the first attempt at developing a document structure
Copyright © 2019 Pearson Education, Inc.
29) What is included in a schema.
Answer: A schema consist of elements and attributes which both carry data. Single elements
30) Why is XML important?
Answer: You know that XML makes a clear separation between structure, content, and