Exam 11: Behind the Scenes: Databases and Information Systems

In an Access database, a filter is limited to extracting data from a single table.

As a business grows, it needs to ________.

A(n) ________ system provides intelligence that supplements the user's own intellect.

Real-time processing means that transactions are updated when they occur.

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

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

A business intelligence system is form of business information system that is used primarily at the consumer level.

Business ________ is the ability to improve business decision making with databases and other fact-based support systems.

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.

NoSQL databases are good for unstructured data.

In terms of databases, a table is also referred to as a(n) ________.

A group of related records is called a(n) ________.

Data that describes other data is known as ________.

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.

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

In a table, if you need to store the extended price (number of units sold times the price per unit) of an order, you would store the data in a ________ field.

A(n) ________ is a type of information system that tracks transactions.

In a database, the term ________ is synonymous with a category of data.

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.