Database Concepts, 8e (Kroenke)
Appendix K Big Data
1) ________ is a set of approaches for taking portions of a database and moving them to a
different server in a cluster.
2) NoSQL really stands for “Not only SQL.”
3) One of the four categories of NoSQL databases used in the text is the Column Family
database.
4) XML provides a standardized, non-customizable way to describe the content of a document.
5) XML documents and XML Schemas are created in different languages.
6) Column family databases may use columns, super columns, column families and super
column families.
7) DBMSs associated with the NoSQL movement use all of the following databases except
________.
A) Key-Value
B) Relational
C) Column Family
D) Graph
E) Document
8) What is the largest unit of memory, out of the five given choices?
A) Petabyte
B) Terabyte
C) Gigabyte
D) Zettabyte
E) Exabyte
9) The document type declaration for an XML document begins with the keyword ________.
A) XML
B) DTD
C) TYPE
D) DOCTYPE
E) TYPEDECL
10) NoSQL really stands for ________.
11) The four categories of NoSQL databases used in the text are the ________ database, the
________ database, the ________ database, and the ________ database.
12) What does NoSQL stand for, and what does it mean?
13) Specify the four categories of NoSQL databases used in the text, and give an example of
each.
14) JSON stands for Jason Script Object Notation.
15) Column family databases that use column families and super column families contain
keyspaces.
16) A popular document-oriented format for use in document databases is JSON.
17) An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
18) Graph databases are composed of three elements, one of which is the node.
19) Graph databases are composed of three elements, one of which is the attribute.
20) Graph databases are composed of three elements, one of which is the edge.
21) An example of a graph database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
22) Graph databases are composed of ________.
A) Nodes
B) Properties
C) Edges
D) both A and C
E) A, B and C
23) Graph databases are composed of ________.
24) What are the elements of a graph database?
25) One of the four categories of NoSQL databases used in the text is the Key-Value database.
26) The key-value database uses columns.
27) An example of a key-value database is ________.
A) DynamoDB
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
28) One of the four categories of NoSQL databases used in the text is the Word Processing
database.
29) One of the four categories of NoSQL databases used in the text is the Graphical database.
30) XML designers created a system that allows document structure, data content, and
materialization to be mixed.
31) DTD stands for Document Type Declaration.
32) XML Schemas consist of elements, attributes, and properties.
33) In XML Schema, there are two types of elements, simple and complex.
34) A complex element must have more than one simple element.
35) For database/XML applications, a good rule to follow is that elements are used to carry data
and attributes are used to carry metadata.
36) In XML Schema, the default cardinality of elements is 0.1.
37) In XML Schema, the default minimum cardinality can be overridden using the minOccurs
attributes.
38) 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)
39) 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.
40) 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
41) What is an XML DTD?
42) There are no install prerequisites for following the appendix’s procedure to create an account
on Microsoft Azure.
43) Microsoft’s Azure DocumentDB is an example of which type of database?
A) Key-value
B) Relational
C) Column family
D) Document
E) Graph
44) Which command is selected in order to arrive at the Deploy Database Introduction screen on
Microsoft Azure?
A) Tasks | Deploy Database to Microsoft Azure SQL Database
B) Tasks | Upload Database to Microsoft Azure SQL Database
C) Tasks | Migrate Database to Microsoft Azure SQL Database
D) Tasks | Install Database to Microsoft Azure SQL Database
E) Tasks | Initialize Database to Microsoft Azure SQL Database
45) XML Schema is a synonym for Document Type Declaration (DTD).
46) XML documents that conform to an XML Schema are validated against that schema.
47) An important improvement of XML Schema over DTDs is that XML Schemas are
themselves XML documents.
48) XML Schema is used to define ________.
A) document content and structure
B) XQL queries
C) DOM-compliant parsers
D) DTDs
E) XPath searches
49) XML documents can be ________ against their XML Schema.
A) measured
B) grown
C) validated
D) browsed
E) All of the above
50) 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
51) XML Schemas consist of ________.
A) elements
B) attributes
C) properties
D) both A and B
E) A, B, and C
52) Which of the following is a type of element in an XML Schema?
A) Simple
B) Composite
C) Compound
D) Complex
E) Both A and D
53) In database/ XML applications, it is a recommended practice that ________.
A) elements represent data, and attributes represent 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
54) 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
55) 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) both A and C
E) both B and C
56) An important improvement of XML Schema over DTDs is that XML Schema are ________.
57) XML Schemas consist of ________.
58) In database/XML applications, it is a recommended practice that ________ represent data,
and that ________ represent metadata.
59) The default cardinality for elements in an XML Schema is ________.
60) What is an XML Schema?
61) A document database may use either XML or JSON as the basis for storing data.
62) XML stands for Extensible Markup Language.
63) SOAP was originally an XML-based standard for providing remote procedure calls over the
Internet.
64) 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
65) 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
66) 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) both A and B
E) A, B, and C
67) 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
68) What is XML, and why is it significantly better than HTML?
69) The CAP theorem defines the three properties, one of which is consistency.
70) The CAP theorem defines the three properties, one of which is authorization.
71) The CAP theorem defines the three properties, one of which is partition tolerance.
72) 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
73) The CAP theorem defines the three properties of ________, ________, and ________.
74) What is the CAP theorem, and what does it show?
75) XSLT is a robust and powerful transformation language that can be used to materialize XML
documents into HTML.