Chapters6And7

Which of the following is not one of the main problems with a traditional file environment?

• data inconsistency

• program-data independence

• lack of flexibility in creating ad-hoc reports

• poor security

A field identified in a table as holding the unique identifier of the table's records is called the

• primary key

• foreign key

• tuple

• attribute

The specialized language programmers use to add and change data in the database is called

• a data access language.

• a data manipulation language.

• structured query language.

• a data definition language.

In data mining, which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?

• Associations

• Sequences

• Classifications

• Clustering

• Forecasting

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

• data auditing.

• defragmentation.

• data scrubbing.

• data optimization.

A ________________________ is a database that stores current and historical data of potential interest to decision makers throughout the company.

• data warehouse

• in-memory computing

• analytic platforms

• Data mining

Each characteristic or quality describing a particular entity is called an attribute.

• True

• False

Multiple data marts are combined and streamlined to create a data warehouse.

• True

• False

A way of facilitating big data analysis is to use _______________________, which relies primarily on a computer’s main memory (RAM) for data storage.

• data warehouse

• in-memory computing

• analytic platforms

• data mining

Wikis allow visitors to change or add to the original posted material.

• True

• False