Exam 11: Behind the Scenes: Databases and Information Systems

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

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

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

________ is the process of ensuring that the data entered into a field meets specified guidelines.

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

When working with a relational database, each record must have a(n)________ key field, which has a value unique to that record.

A(n)________ is created from a large data business warehouse to analyze a single component of the business.

A(n)________ is designed to improve communications and help employees complete their routine tasks.

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

________ databases are the most frequently used electronic databases.

Employees' last names would usually make an appropriate primary-key field.

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

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.

A(n)________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

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

Data redundancy ensures that the data contained in the database is accurate and reliable.

In a database, a group of related records is referred to as a(n)________.

A last name field is an example of a field that should have a default value.