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 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) transforming the data
B) mining the data
C) storing the data in a warehouse
D) extracting the data

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

database s...

View Answer

Show Answer

Question 43

Short Answer

Review LaterAdd Note

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

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

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

Match each of the following terms to its definition:

A(n) ________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

A group of related records is called a table.

Match each of the following terms to its definition:

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

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

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

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

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

A filter is limited to extracting data from a single table.