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 71

Matching

Review LaterAdd Note

Review Later

Match each of the following terms to its definition:

Premises

Responses

batch processing

defines the name, data type, and length of each field in a database

data warehouse

organizes data into various tables based on logical groupings

real-time processing

when a database is queried and updated as a transaction is taking place

data dictionary (schema)

transaction data that are processed all at once

relational database

large-scale collection of data

Premises

batch processing

data warehouse

real-time processing

data dictionary (schema)

relational database

Responses

defines the name, data type, and length of each field in a database

organizes data into various tables based on logical groupings

when a database is queried and updated as a transaction is taking place

transaction data that are processed all at once

large-scale collection of data

Show Answer

Correct Answer

Premises

Responses

batch processing

data warehouse

real-time processing

data dictionary (schema)

relational database

Premises

batch processing

data warehouse

real-time processing

data dictionary (schema)

relational database

Responses

Question 72

True/False

Review LaterAdd Note

Review Later

A table in Microsoft Word or a spreadsheet in Microsoft Excel, can be used as a flat database.

A) True
B) False

Correct Answer

verified

Show Answer

Question 73

Short Answer

Review LaterAdd Note

A(n) ________ is software that is used to gather and analyze data.

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

To temporarily display records in an Access database from a single table that match certain criteria, you would use a(n) ________.

A small subset of data from a data warehouse is known as a(n) ________.

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

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

Match each of the following terms to its definition:

A(n) ________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

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

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

In a Access database, field size, caption, and Required and examples of a field's ________.

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