Exam 10: Databases

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

The process of dividing a database into distributed subsets is called ________.​

A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules.​

_________ refers to the number of associations that can exist between two record types.​

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

Four DBMS vendors are the first stop for professional developers: IBM, _________, SAS, and SAP.​

The underlying structure of a database is referred to as a database _________.​

SQL is banned from the NoSQL technology collection.​

Computer programming languages designed for databases are called _________ languages because one of their main capabilities is to request data from a database​

Spreadsheet software offers database capabilities for establishing relationships between different record types.​

The term database ___________ refers to the arrangement of fields, tables, and relationships in a database.​

SQL statements contain command words but do not contain data.​

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key​

A hierarchical database allows one-to-many relationships but not one-to-one relationships.​

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

An example of _________ data is the 1 million transactions generated by Walmart sales registers every hour.​

One of the most common database operations is to query for a particular record or group of records by using the ________ command.​

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

The SQL command word _________ removes a record from a table.​

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.​