database quiz 13

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

World History Chapter 16 Section 2

View Set

Congenital Deformities of the Foot & Ankle

View Set

Environmental Laws and Regulations

View Set

IT Security Audits Ch. 1-4 Questions

View Set

Figure 7-17: The Vertebral Column

View Set