Deck 14: Database Processing With XML

Question 1

XML provides a standardized,non-customizable way to describe the content of a document.

Answer 1

False

Question 2

When XSLT actions are indicated in a loop,the loop ends with .

Answer 2

True

Question 3

XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

Answer 3

True

Question 4

XSLT is a declarative transformation language.

Question 5

HTML is an application of a document markup language called Standard Generalized Markup Language (SGML).

Question 6

XSLT processors are context oriented;that is,each statement is evaluated within the context of the match that has already been made.

Question 7

Possible uses of XML go far beyond using it to display Web pages.

Question 8

DTD stands for Document Type Declaration.

Question 9

In the 1990s the database community and the document processing community created a standard called Expandable Markup Language (XML).

Question 10

XSLT is a non-declarative transformation language.

Question 11

Unlike SQL views,XML views are not limited to one multivalued path.

Question 12

XML documents that conform to their DTD are said to be type-valid XML documents.

Question 13

An XSLT stylesheet is used by XSLT to indicate how to transform the elements of an XML document into another format.

Question 14

Database processing and document processing are unrelated to one another.

Question 15

SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.

Question 16

An XSLT command embedded in the structure of an XSLT stylesheet is of the form {loop,action}.

Question 17

All type-valid XML documents are required to have a DTD.

Question 18

XML designers created a system that allows document structure,data content,and materialization to be mixed.

Question 19

XML documents that do not conform to their DTD are said to be non-type-valid XML documents.

Question 20

XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

Question 21

In XML Schema,the default cardinality of elements is 0.1.

Question 22

XML documents and XML Schemas are created in different languages.

Question 23

For database/XML applications,a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.

Question 24

In XML Schema,the default minimum cardinality can be overridden using the minOccurs attributes.

Question 25

XML documents that conform to an XML Schema are validated against that schema.

Question 26

Oracle requires the use of Java for generating XML documents from database data.

Question 27

SQL Server has facilities for generating XML documents from database data.

Question 28

XML Schemas consist of elements,attributes,and properties.

Question 29

An XML Schema where all the elements occur at the same level is called a structured schema.

Question 30

An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.

Question 31

Setting the minimum cardinality to 0 is similar to using a NULL constraint in SQL.

Question 32

MySQL Server does not have facilities for generating XML documents from database data.

Question 33

After an XSLT processor transforms an XML document into an HTML document,the HTML document is materialized using a browser.

Question 34

The SQL Server statement SELECT...FOR XML is used to place column data as elements in an XML document.

Question 35

To eliminate definition duplication,XML Schema elements can be declared globally.

Question 36

The first statement of an XML document indicates the schema that will be used to validate the document.

Question 37

Most of todays Web browsers still lack a built-in XSLT processor.

Question 38

In XML Schema,there are two types of elements,simple and composite.

Question 39

Elements of complexType must have more than one simple element.

Question 40

XML Schema is a synonym for Document Type Declaration (DTD).

Question 41

XML stands for ________.

A)Experimental Markup Language
B)Extendable Markup Language
C)Extensible Markup Language
D)Active X-control Markup Language
E)Active X-control Management Language

Question 42

XML industries standards have been published for the Accounting industry.

Question 43

Which of the following is true about XML?

A)It is a subset of SGML.
B)Additional standards and capabilities have been added to XML processing.
C)It is a hybrid of document processing and database processing.
D)A and B
E)A,B and C

Question 44

XML industries standards have not been published for the Real Estate industry.

Question 45

Most of NoSQL nonrelational database methodologies are known as structured storage.

Question 46

The SQL Server statement SELECT...FOR XML EXPLICIT is used to control placement of column data as either elements or attributes in an XML document.

Question 47

Xquery is a standard for expressing generalized queries on XML documents.

Question 48

SOAP has become ________.

A)just a name,not an acronym
B)a standard protocol for sending any type of message
C)an old technology replaced by XML
D)A and B
E)A,B and C

Question 49

Facebook uses the Apache Software Foundation's Cassandra NoSQL database.

Question 50

The SAX and DOM XML standards both support methods of parsing XML documents.

Question 51

XML processing provides a standardized facility to describe,validate,and materialize any database view.

Question 52

Few industries have shown an interest in developing XML industry standards.

Question 53

The SQL Server statement SELECT...FOR XML can only be used with a single table.

Question 54

HTML is an application of ________.

A)SGML
B)XML
C)SOAP
D)XSLT
E)ADO.NET

Question 55

XML Namespaces are used to define domains,support domains and disambiguate terms.

Question 56

MySQL,while still retaining the underlying relational database structure,is allowing application developers to by-pass SQL by using the MySQL memcached API.

Question 57

The movement to use different database methods than the relational model and/or SQL is called the NoSQL movement.

Question 58

The standard for addressing elements within documents,such as is called XPath.

Question 59

SOAP originally stood for ________.

A)Simple Operational Application Protocol
B)Standard Operational Application Protocol
C)Simple Object Application Protocol
D)Simple Object Access Protocol
E)Standard Object Access Protocol

Question 60

The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

Question 61

In database/ XML applications,it is a recommended practice that ________.

A)elements carry data,and attributes carry metadata
B)elements carry metadata,and attributes carry data
C)elements and attributes carry data,and the XML Schema carry metadata
D)elements and attributes carry metadata,and the XML Schema carry data
E)either A or B

Question 62

XML documents can be ________ against their XML Schema.

A)measured
B)grown
C)validated
D)browsed
E)All of the above.

Question 63

The first section of an XML document might be a ________.

A)Document Definition Section (DDS)
B)Document Type Declaration (DTD)
C)Data Type (DTYPE)
D)Document Type (DOCTYPE)
E)Type Declaration (TYPEDECL)

Question 64

The default cardinality for elements in an XML Schema is ________.

A)0.1
B)1.1
C)1.N
D)N.1
E)M.N

Question 65

XML documents that are not-type-valid can still be ________.

A)DTD-valid
B)XML-valid
C)DTD-compliant
D)XML-compliant
E)proper XML documents

Question 66

Which of the following is a type of element in an XML Schema?

A)simple
B)composite
C)compound
D)complex
E)A and D

Question 67

Which of the following is not true about document type declarations for XML documents?

A)They are not required.
B)They are required for type-valid documents.
C)They cannot be contained inside the XML document.
D)Storing the DTD externally allows many documents to be validated against the same DTD.
E)The DTD can be extended by the developer with any elements he or she wants to include.

Question 68

The document type declaration for an XML document begins with the keyword ________.

A)XML
B)DTD
C)TYPE
D)DOCTYPE
E)TYPEDECL

Question 69

Which of the following is true about XML?

A)It allows the confounding of document structure,content,and format.
B)It is non-standardized to allow for extension by developers.
C)The structure of documents is formally defined.
D)XML tags,like some HTML tags,are vague and arbitrary.
E)None of the above.

Question 70

Which of the following is true about XSLT?

A)It can be used to materialize XML documents into HTML.
B)XSLT processors are context oriented.
C)It is a non-declarative transformation language.
D)A and B
E)A,B and C

Question 71

XML Schemas consist of ________.

A)elements
B)attributes
C)properties
D)A and B
E)A,B and C

Question 72

The XML Schema statement xmlns:xsd indicates that ________.

A)this XML Schema uses a labeled namespace called xsd
B)this XML Schema is validated at www.xsd.com
C)this XML Schema is validated at www.xmlns.com using the xsd XML Schema located there
D)this XML Schema is using a non-standard looping procedure,where xsd is the variable name of the loop increment
E)the value of the variable xmnls is being set equal to the value of the variable xsd

Question 73

XML Schema is used to define ________.

A)document content and structure
B)XQL queries
C)DOM-compliant parsers
D)DTDs
E)XPath searches

Question 74

XML documents that conform to their DTD are said to be ________.

A)DTD-valid
B)XML-valid
C)DTD-compliant
D)not-type-valid
E)type-valid

Question 75

XML Schema elements of the complexType may contain ________.

A)one simple element
B)one complexType element
C)more than one simple element
D)more than one complexType element
E)Any of the above.

Question 76

The XML Schema "mother of all schemas" is located at ________.

A)a user defined web server for each organization
B)www.w3.org
C)www.google.com
D)www.microsoft.com
E)www.xmlschema.net

Question 77

An important improvement of XML Schema over DTDs is that ________.

A)XML Schema can be stored external to the document
B)XML Schema support XQL queries
C)XML Schema are XML documents
D)XML Schema are not required
E)XML Schema can validate XML documents

Question 78

Which of the following is not true about XSLT?

A)It is a declarative language.
B)It is a transformation language.
C)It can materialize XML documents into HTML.
D)It can transform an XML document into another XML document with a different structure.
E)It requires the use of CSS.

Question 79

The use of the XML Schema expression minOccurs="0" ________.

A)is an XML Schema default
B)is required as there are no defaults in an XML Schema
C)is similar to the SQL schema NULL constraint
D)A and C
E)B and C

Question 80

In an XML Schema,the tags ...<\xsd:ComplexType> indicate that:

A)a sequence of numbers is listed between the tags.
B)a sequence of letters or words is listed between the tags.
C)a set of elements will occur in a multi-layered format between the tags.
D)A or B
E)A,B or C