Ch. 1 Database Systems

____ exists when different versions of the same data appear in different places. A. Data inconsistency B. Data consistency C. Better data integration D. Improved decision making

A. Data inconsistency

____ data are the result of formatting to facilitate storage, use and generation of information. A. Structured B. Semistructured C. Unstructured D. Historical

A. Structured

Most decision-support data are based on historical data obtained from ____. A. operational databases B. data warehouses C. enterprise databases D. workgroup databases

A. operational databases

The database structure in a DBMS is stored as a ____. A. file B. collection of files C. set of key/value pairs D. collection of queries

B. collection of files

The organization of the data within the folders in a manual file system was determined by ____. A. the date of creation B. its expected use C. the title of the documents in the folder D. the data processing specialist

B. its expected use

A workgroup database is a(n)____ database. A. single-user B. multiuser C. enterprise D. distributed

B. multiuser

(T/F) Data and information are essentially the same thing

False

An operational database is sometimes referred to as an enterprise database.

False

Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data

False

The DBMS reveals much of the database's internal complexity to the application programs and users.

False

Data constitute the building blocks of information.

True

Historically, a manual file system was composed of a system of file folders and filing cabinets.

True

One disadvantage of a database system over previous data management approaches is increased costs.

True

We are now said to be entering the "knowledge age."

True

A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization. A. desktop B. workgroup C. enterprise D. transactional

B. workgroup

____ is the body of information and facts about a specific subject. A. Data B. Information C. Knowledge D. A database

C. Knowledge

____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database. A. Queries B. End-user data C. Metadata D. Information

C. Metadata

____ data exist in the format in which they were collected. A. Structured B. Semistructured C. Unstructured D. Historical

C. Unstructured

Which of the following is an example of structured data? Question options: A. A Web page B. An e-mail C. A memo D. A spreadsheet

D. A spreadsheet

____ is used to reveal the meaning of data. A. Raw facts B. Knowledge C. Formatting D. Information

D. Information

The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment. A. database management system B. database management C. management system D. database system

D. database system

A ____ is a collection of related records. A. database B. field C. column D. file

D. file

A(n) ____ database is designed to support a company's day-to-day operations. A. desktop B. workgroup C. enterprise D. transactional

D. transactional

The only way to access the data in a database is through the DBMS.

True

The same data might be simultaneously structured and unstructured depending on the intended processing.

True