database quiz 13
The FILTER operation in AQL come after ________ and precedes ________.
FOR, RETURN
ArangoDB provides a facility called ________, an enhanced version of ________ that allows direct access to ArangoDB.
Foxx, JavaScript
Secondary indexes in ArangoDB come in four varieties which are ________.
Geo, Persistent, Fulltext, and TTL
Document databases store data according to a document-oriented format which includes ________.
JSON and XML
The access levels available for a collection are ________.
Read/Write, Read Only, and No Access
Document databases have yet to achieve a well-developed theory and practice of database design for the following two reasons.
They are a much newer technology and the complexity and flexibility allowed in the data make them more difficult to model.
AQL is a ________ language.
declarative
When uploading an Excel spreadsheet into ArangoDB, we are following a procedure known as ________.
extract, transform, analyze
A document consists of a set of column/pairs.
false
A multivalued attribute cannot be used in a document database.
false
A typical command available in a document database is add.
false
A typical command available in a document database is retrieve.
false
ArangoDB provides a facility called Eagle, an enhanced version of JavaScript.
false
ArangoDB requires user authentication for all database actions by default and cannot be turned off.
false
Data can be created in the ArangoDB by using the Upload button.
false
In a document database every record must have the exact same columns.
false
JSON stands for Jason Script Object Notation.
false
The ArangoDB Enterprise Edition provides all the basic functionality of ArangoDB and is a free version.
false
The FILTER operation is equivalent of SQL's IF clause.
false
The real power of JSON lies in the definition of "structure".
false
The version for use in the cloud is the ArangoDB Cloud
false
To import an Excel file into ArangoDB it must be in an Excel worksheet document.
false
With concurrency control, multiple transactions can be written to the same collection at the same time, but locking will not prevent them from writing the same document at the same time.
false
A document database is designed to provide ________.
fast processing of queries over a multiple large collection of similar documents
A document (object in JSON terminology) consists of a set of ________ pairs.
field, value
An entry point in an ArangoDB is ________.
how it serves as a way for a collection to be displayed
Typical commands in a document database include ________.
insert, update, delete, find
ArangoDB is a ________ NoSQL DBMS.
multi-model
The real power of JSON lies in the definition of ________.
order
A ________ index is a general-purpose index.
persistent
The three types of backups in ArangoDB are ________.
physical, logical, and hot
Typical commands available in a document database include all the following except ________.
reference
Document databases typically base their data structuring features on ________.
relations
JSON data files do not have to conform to any ________.
schema
The data model used in a document database is often referred to as ________ data.
semi-structured
The main mechanism for data distribution in ArangoDB is called ________.
sharding
________ is the main mechanism for data distribution in ArangoDB.
sharding
A document database consists of a set of collections.
true
A document database is designed to provide fast processing of queries over multiple collections of different documents.
true
A document database is mainly intended for processing multiple, large collections of documents.
true
A document database may use either XML or JSON as the basis for storing data.
true
A persistent index is a general-purpose index.
true
A typical command available in a document database is delete.
true
A typical command available in a document database is insert.
true
AQL is a declarative query language.
true
Administrative tasks done by a DBA using a command-line tool is arangosh.
true
All data in an ArangoDB goes into collections.
true
An access level describes the privileges a user has on an ArangoDB object.
true
CRUD is the reference for the four basic document database commands.
true
Document databases do not have a well-developed theory and practice of database design.
true
Fast searches for documents in ArangoDB is done through primary indexes.
true
In JSON, there are two data structuring concepts: the object and the array.
true
JSON data files do not have to conform to any schema.
true
The ArangoDB Community Edition provides all the basic functionality of ArangoDB and is a free version.
true
The executeTransaction function is used to execute a transaction in ArangoDB.
true
The movement that uses different database methods than the relational model and/or SQL is called the NoSQL movement.
true
The query language provided by ArangoDB is called ArangoDB Query Language.
true
The two most popular document-oriented formats for storing data are XML and JSON.
true
To create and use a new database and user we will use the Arango Management Interface.
true
To download and install ArangoDB you would use the following steps:
true
We can accept a little redundancy in return for scalability in a document database.
true
XML stands for Extensible Markup Language.
true
The Web-based GUI that allows for all tasks available in arangosh is called ________.
Arango Management Interface
________ is the cloud-based version of ArangoDB.
ArangoDB Web
The AQL equivalent of GROUP BY is called ________.
COLLECT
The AQL FILTER operation allows the standard comparison of values as well as standard Boolean logic of ________.
OR, AND, and NOT
CRUD stands for ________.
create, read, update, delete
An array is indicated by ________ brackets.
[ ]
In return for performance and scalability a document database can ________.
accept a certain amount of redundancy
An ________ level describes the privileges a user has on an ArangoDB object.
access
At the server level in ArangoDB the possible access levers are ________ and ________.
administrate, no access
A document database consists of a set of ________.
collections
All data, in a document database, goes in ________.
collections
The ArangoDB ________ Edition provides all the basic functionality of ArangoDB.
community