Deck 18: Business Intelligence Systems

Question 1

One of the four categories of NoSQL databases used in the text is the Graphical database.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

DTD stands for Document Type Declaration.

Question 6

The CAP theorem defines the three properties,one of which is partition tolerance.

Question 7

The key-value database uses columns.

Question 8

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

Question 9

One of the four categories of NoSQL databases used in the text is the Column Family database.

Question 10

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

Question 11

A document database may use either XML or JSON as the basis for storing data.

Question 12

JSON stands for Jason Script Object Notation.

Question 13

One of the four categories of NoSQL databases used in the text is the Word Processing database.

Question 14

One of the four categories of NoSQL databases used in the text is the Key-Value database.

Question 15

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

Question 16

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

Question 17

The CAP theorem defines the three properties,one of which is authorization.

Question 18

The CAP theorem defines the three properties,one of which is consistency.

Question 19

NoSQL really stands for "Not only SQL."

Question 20

XML stands for Extensible Markup Language.

Question 21

The CAP Theorem defines three properties of distributed database systems,which are:

A) consistency, always-on, properties.
B) competency, always-on, properties.
C) consistency, availability, partition tolerance.
D) competency, availability, partition tolerance.
E) consistency, availability, properties.

Question 22

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

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

Graph databases are composed of three elements,one of which is the node.

Question 25

Column family databases may use columns,super columns,column families and super column families.

Question 26

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

Question 27

Graph databases are composed of three elements,one of which is the edge.

Question 28

Graph databases are composed of three elements,one of which is the attribute.

Question 29

Column family databases that use column families and super column families contain keyspaces.

Question 30

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

Question 31

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

Question 32

An example of a key-value database is ________.

A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL

Question 33

XML documents and XML Schemas are created in different languages.

Question 34

XML Schemas consist of elements,attributes,and properties.

Question 35

An example of a document database is ________.

A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL

Question 36

DBMSs associated with the NoSQL movement use ________ databases.

A) Key-Value
B) Document
C) Column Family
D) Graph
E) All of the above

Question 37

A complex element must have more than one simple element.

Question 38

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

Question 39

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

Question 40

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

Question 41

An example of a graph database is ________.

A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL

Question 42

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 43

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 44

XML Schema is used to define ________.

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

Question 45

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 46

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

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

Question 47

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 48

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 49

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 50

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 51

XML documents can be ________ against their XML Schema.

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

Question 52

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 53

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 54

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 55

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 56

XML Schemas consist of ________.

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

Question 57

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 58

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 59

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 60

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 61

What does NoSQL stand for,and what does it mean?

Question 62

What is an XML DTD?

Question 63

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

Question 64

Specify the four categories of NoSQL databases used in the text,and give an example of each.

Question 65

The four categories of NoSQL databases used in the text are the ________ database,the ________ database,the ________ database,and the ________ database.

Question 66

Graph databases are composed of ________.

Question 67

What are the elements of a graph database?

Question 68

The CAP theorem defines the three properties of ________,________,and ________.

Question 69

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

Question 70

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

Question 71

In database/ XML applications,it is a recommended practice that ________ carry data,and that ________ carry metadata.

Question 72

What is an XML Schema?

Question 73

XML Schemas consist of ________.

Question 74

Graph databases are composed of ________.

A) Nodes
B) Properties
C) Edges
D) A and C
E) A, B and C

Question 75

What is XML,and why is it significantly better than HTML?

Question 76

NoSQL really stands for ________.

Question 77

What is the CAP theorem,and what does it show?