Exam 10: Databases

In a relational database, relationships are specified by joining common data stored in records from different tables.

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.

Rather than deleting old data, it can be moved to a data __________.

An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

Access to databases is usually open to anyone within an organization or business.

Relational databases store unstructured data.​

In the context of database security, intermediary servers allow users to directly access the database.

From a technical perspective, a data __________ specifies the way data is represented on physical storage media and in RAM.

_________-density data refers to large volumes of very detailed data in which many of the details are not important.​

Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.​

Most spreadsheet software also includes basic data management features.

Modern database tools support ________________, which entails separating data from the programs that manipulate data.

A database table's physical sort order is the order in which records are arranged on storage devices.

SQL is banned from the NoSQL technology collection.​

A _____________ is a specification that the database designer sets up to filter data entered into a particular field.

The simplest structure for storing data in a(n) _________ database is the key-value data model.​

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.