Database Processing, 15e (Kroenke)
Appendix K: Big Data
1) NoSQL also stands for “Not only SQL.”
2) One of the four categories of NoSQL databases used in the text is the Key-Value database.
3) One of the four categories of NoSQL databases used in the text is the Word Processing
database.
4) One of the four categories of NoSQL databases used in the text is the Column Family
database.
5) One of the four categories of NoSQL databases used in the text is the Graphical database.
6) The CAP theorem defines the three properties, one of which is consistency.
7) The CAP theorem defines the three properties, one of which is authorization.
8) The CAP theorem defines the three properties, one of which is partition tolerance.
9) The key-value database uses columns.
10) A document database may use either XML or JSON as the basis for storing data.
11) XML stands for Extensible Markup Language.
12) JSON stands for Jason Script Object Notation.
13) The 3V framework for discussing Big Data consists of Volume, Velocity, and Variety.
14) The 3V framework for discussing Big Data consists of Volume, Velocity, and Vicious.
15) The CAP theorem states that all three properties (consistency, availability, and partition
tolerance) can be guaranteed at the same time when properly created.
16) Column family databases may use columns, super columns, column families, and super
column families.
17) Column family databases that use column families and super column families contain
keyspaces.
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) DBMSs associated with the NoSQL movement use all of the following kinds of database
management systems except ________.
A) Key-Value
B) Document
C) Relational
D) Graph
22) 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
23) The four categories of NoSQL databases studied in this appendix are ____________.
A) Key-Value, Document, XML, and Graph
B) Key-Value, XML, Column Family, and Graph
C) XML, Document, Column Family, and Graph
D) Key-Value, Document, Column Family, and Graph
24) Microsoft Azure is a __________platform.
A) local server based
B) cloud-based
C) local computer based
D) local network based
25) An example of a key-value database is ________.
A) DynamoDB
B) Couchbase Server
C) Bigtable
D) Neo4j
26) An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
27) An example of a graph database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
28) XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
29) Graph databases are composed of ________.
A) Nodes, Properties, and Edges
B) Properties, Columns, and Super Columns
C) Edges, Nodes, and Tables
D) Nodes, Columns, and Properties
30) The “value” in a key value database can be ________.
A) any string value only
B) any numeric value only
C) any value of any size or type
D) any list of values only
31) In a key value database, the basic “get” operation ________.
A) retrieves all values in the database
B) retrieves all keys with a specified value
C) retrieves all values associated with a key
D) retrieves the value associated with a key
32) Document databases typically base their data structuring features on ________.
A) JSON
B) XML
C) relations
D) Both A and B are correct
33) In the following sample document data (presented in MongoDB syntax), how many
documents are there?
{
_id: “Advisor1”,
name: “Shire, Robert”,
dept: “History”,
yearHired: 1975
}
{
_id: 555667777,
name: “Tierney, Doris”,
majors: [“Music”, “Spanish”],
addresses: [
{
street: “14510 NE 4th Street”,
city: “Bellevue”,
state: “WA”,
zip: “98005”
},
{
street: “335 Aloha Street”,
city: “Seattle”,
state: “WA”,
zip: “98109”
}
],
advisorID: “Advisor1”
}
A) 2
B) 4
C) 6
D) 8
34) In a column family database, the unit of data that most closely corresponds to a relation is the
________.
A) column
B) timestamp
C) column family
D) keyspace
35) One important difference between a relation and a column family is that ________.
A) the rows in a column family can have different numbers of columns
B) the columns in a column family are unnamed
C) all values in a column family must have the same timestamp
D) values in a column family must be strings
36) What does NoSQL stand for, and what does it mean?
37) Specify the four categories of NoSQL databases used in the text and give an example of
each.
38) What is the CAP theorem, and what does it show?
39) What are the elements of a graph database?