Copyright © 2019 Pearson Education, Inc.
Database Processing, 15e (Kroenke)
Appendix L: JSON and Document Databases
1) The two most popular document-oriented formats for storing data are XML and JSON.
Answer: TRUE
2) The four basic document database commands are often referred to as the CRUD (Create,
Refer, Update, Delete) commands.
Answer: FALSE
3) A document database may use either XML or JSON as the basis for storing data.
Answer: TRUE
4) JSON stands for Jason Script Object Notation.
Answer: FALSE
5) In JSON, there are two data structuring concepts: the object and the array.
Answer: TRUE
6) The real power of JSON lies in the definition of “structure”.
Answer: FALSE
Copyright © 2019 Pearson Education, Inc.
7) Data can be created in the ArangoDB by using the Upload button.
Answer: TRUE
8) JSON data files do not have to conform to any schema.
Answer: TRUE
9) A document database is mainly intended for processing multiple, large collections of
documents.
Answer: FALSE
10) In a document database every record must have the exact same columns.
Answer: FALSE
11) Document databases have a well-developed theory and practice of database design.
Answer: TRUE
12) In a document database one is willing to accept a certain amount of redundancy in return for
some flexibility, performance, and scalability.
Answer: TRUE
Copyright © 2019 Pearson Education, Inc.
13) The query language provided by ArangoDB is called ArangoDB Query Language.
Answer: TRUE
14) The Application Programming Interface (API) connects to ArangoDB using the common
HTML protocol used by web browsers and other software.
Answer: FALSE
15) An ArangoDB array, unlike arrays in programming languages, does not allow accessing
individual elements of an array by number, using the array’s index.
Answer: FALSE
16) The AQL equivalent of GROUP BY is called COLLECT.
Answer: TRUE
17) In regard to joins, ArangoDB makes it easier than most NoSQL databases by providing the
option to use nested loops.
Answer: TRUE
18) Hash indexes provide performance enhancements for range searches.
Answer: FALSE
Copyright © 2019 Pearson Education, Inc.
19) The main mechanism for data distribution in ArangoDB is called shading.
Answer: FALSE
20) An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
Answer: B
21) Document databases typically base their data structuring features on ________.
A) JSON
B) XML
C) relations
D) Both A and B are correct
Answer: D
22) A document database is designed to provide ___________.
A) fast processing of queries over a single large collection of similar documents
B) fast processing of queries over a multiple large collection of similar documents
C) normal processing of queries over a single large collection of similar documents
D) normal processing of queries over a multiple large collection of different documents
Answer: A
Copyright © 2019 Pearson Education, Inc.
23) Typical commands available in a document database include all the following except
_______.
A) insert
B) update
C) reference
D) delete
Answer: C
24) The data model used in a document database is often referred to as _________ data.
A) structured
B) full-structured
C) relational
D) semi-structured
Answer: D
25) A document (object in JSON terminology) consists of a set of _____________ pairs.
A) column, value
B) field, value
C) record, field
D) column, field
Answer: B
26) The real power of JSON lies in the definition of “value”, which can be ______.
A) multiple data points
B) a simple, single data point
C) an array of values
D) both B & C
Answer: D
Copyright © 2019 Pearson Education, Inc.
27) 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
Answer: B
Copyright © 2019 Pearson Education, Inc.
28) ArangoDB is a ___________ database management system.
A) multi-model NoSQL
B) single-model NoSQL
C) multi-model relational
D) single-model relational
Answer: A
29) Data can be entered into an ArangoDB collection of documents by all of the following ways
except _________.
A) use the ArangoDB arangoimp command to import data from a JSON file
B) use the ArangoDB Web Interface
C) use the ArangoDB Collections tab
D) importing a JSON file using the ArangoDB Web Interface
Answer: C
30) ArangoDB Query Language (AQL) is a ___________.
A) relative query language
B) simple query language
C) declarative query language
D) structured query language
Answer: C
31) Every AQL query result is a list of __________.
A) values in a sequence
B) values in a record
C) values in a column
D) values in an array
Answer: D
Copyright © 2019 Pearson Education, Inc.
32) Arrays allow for an ordering of ___________.
A) columns
B) elements
C) rows
D) both A and B
Answer: B
33) Which of the following is an incorrect statement.
A) ArangoDB does not allow the user to create additional secondary indexes on any field.
B) In ArangoDB, every collection has a _key field, which is the primary key.
C) Hash indexes do not provide any performance enhancements.
D) A skiplist index is designed to perform similarly to a B-tree.
Answer: A
34) The main mechanism for data distribution in ArangoDB is called ______.
A) shading
B) shifting
C) sharding
D) sharing
Answer: C
35) Explain what a document database is designed to provide.
Answer: A document database is designed to provide fast processing of queries over a single
Copyright © 2019 Pearson Education, Inc.
36) Explain what a document is in a document database.
Answer: A document (object in JSON terminology) consists of a set of (field, value) pairs.
37) Explain how you would download and install ArangoDB.
38) Explain the two main ways to submit queries to ArangoDB.
Answer: The two ways to submit queries to ArangoDB are: 1) Using HTTP: ArangoDB provides
Copyright © 2019 Pearson Education, Inc.
39) Indexing is intended to provide fast access to specific data while minimizing the amount of
data searched. What are the options for indexing in ArangoDB?
Answer: In ArangoDB, every data collection has a _key field (primary key) that is automatically