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 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

An employee's ID number, name, company position, address, city, state, and Zip Code make up a record.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

A summary report provides a list of the transactions that occurred during a specified time period.

You can set a ________, which is automatically displayed in a field unless the user enters something different.

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.

Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system.

The Siri personal assistant application on Apple's iPhone 5s is an example of a ________.

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

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

A database that allows data to be maintained in a single location provides data ________.

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

A database schema defines the name, data type, and length of each field in the database.

When using Access, the text of the Gettysburg Address would be stored in a short text field.

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

Match each of the following terms to its definition:

A ________ check would be used to restrict the fines for speeding violations from $50 to $250.

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