Exam 11: Behind the Scenes: Databases and Information Systems

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 ________.

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

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

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

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