FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Behind the Scenes: Databases and Information Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

False

Question 3

Short Answer

Review LaterAdd Note

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

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

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.

Match each of the following terms to its definition:

________ databases are the most frequently used electronic databases.

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

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

Match each of the following terms to its definition:

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

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

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

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

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

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

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

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