Exam 11: Behind the Scenes: Databases and Information Systems

A ________ displays a subset of data from a table (or tables) based on the specified criteria.

A ________ is a collection of related data that can be stored, sorted, organized, and queried.

Siri, the personal assistant application on Apple's iPhone is an example of a ________.

To temporarily display records from a single table that match certain criteria, you would use a(n) ________.

A database that allows data to be maintained in a single location provides data ________.

Normalization means that there are no data entry errors in a database.

When using SQL, a(n) ________ query is used to extract data from two or more tables.

________ data is information about how users of a company's website move through the web pages.

A(n) ________ tries to replicate the decision-making processes of human experts to solve specific problems.

Data staging consists of all of the following steps, EXCEPT ________.

In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.

Small slices of a data mart are called data warehouses.

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.

Data in a multidimensional database is organized in a ________ format.

________ is the branch of computer science that attempts to create computers that think like humans.

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.

A database schema defines the name, data type, and length of each field in the database.