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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) database
B) document
C) memo
D) macro

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

In an Access database, changing the ________ enables you to display the field name in a more meaningful or readable manner.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

A group of related records is called a table.

________ Query Language is similar in many respects to Structured Query Language.

Which of the following is NOT a database component?

To combine data from more than one table, you need to create a(n) ________ between the tables.

In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.

A(n) ________ report provides a list of the transactions that occurred during a certain time period.

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

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

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

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

Data ________ means that the data contained in a database is accurate and reliable.

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

What is the Access object that organizes data into fields and records?

Most small businesses use ________ databases as they are reliable and less costly.

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

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

Match each of the following terms to its definition:

The results of multiplying the Hours field times the Rate field would be stored in a(n) ________ field.