Exam 11: Behind the Scenes: Databases and Information Systems

In a database, another term for a table is a(n) ________.

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

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

The data in a data warehouse is ________, meaning it does not all pertain to one period in time.

Most databases can import electronic data from other software applications.

________ databases are better than relational databases at handling unstructured data such as audio clips, video clips, and pictures.

A data dictionary is also referred to as a(n) ________.

________ is used to analyze large amounts of data and identify unseen patterns or trends.

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

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

When using Access, the text of the Declaration of Independence would be stored in a short text field.

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

Data that describes other data is called ________.

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

Which of the following is a likely primary key in a student information record?

A(n) ________ check determines whether a required field such as LastName was filled in.

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

A field ________ is a property that must be met before an entry can be accepted into the field.

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