Chapter 1

Question 1

Data and information are essentially the same thing.

Answer 1

False

Question 2

Data processing can be as simple as organizing data to reveal patterns.

Answer 2

True

Question 3

Data constitute the building blocks of information.

Answer 3

True

Question 4

Metadata present a more complete picture of the data in the database than the data itself.

Answer 4

True

Question 5

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

Answer 5

False

Question 6

One disadvantage of the DBMS is that it increases the risk of data security breaches.

Answer 6

False

Question 7

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

Answer 7

True

Question 8

Corporations use only structured data.

Answer 8

False

Question 9

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.

Answer 9

False

Question 10

A query language is a procedural language.

Answer 10

False

Question 11

____ is used to reveal the meaning of data.

Answer 11

Information

Question 12

Accurate, relevant, and timely information is the key to ____.

Answer 12

Good decision making

Question 13

____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.

Answer 13

Metadata

Question 14

The ____ serve(s) as the intermediary between the user and the database.

Answer 14

DBMS

Question 15

____ exists when different versions of the same data appear in different places.

Answer 15

Data inconsistency

Question 16

The response of the DBMS to a query is the ____.

Answer 16

Query result set

Question 17

A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.

Answer 17

Workgroup

Question 18

A ____ database supports data distributed across several different sites.

Answer 18

Distributed

Question 19

Most decision-support data are based on historical data obtained from ____.

Answer 19

Operational databases

Question 20

____ is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.

Answer 20

Online analytical processing

Question 21

____ data are the result of formatting to facilitate storage, use and generation of information.

Answer 21

Structured

Question 22

Most data you encounter is best classified as ____.

Answer 22

Semi-structured

Question 23

The organization of the data within the folders in a manual file system was determined by ____.

Answer 23

Expected use

Question 24

A ____ is a logically connected set of one or more fields that describes a person, place, or thing.

Answer 24

Record

Question 25

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

Answer 25

Database system

Question 26

____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.

Answer 26

Performance tuning

Question 27

We are now said to be entering the “knowledge age.”

Answer 27

True

Question 28

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

Answer 28

True

Question 29

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

Answer 29

False

Question 30

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

Answer 30

True

Question 31

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

Answer 31

True

Question 32

____ is the body of information and facts about a specific subject.

Answer 32

Knowledge

Question 33

The database structure in a DBMS is stored as a ____.

Answer 33

Collection of files

Question 34

A(n) ____ database is designed to support a company’s day-to-day operations.

Answer 34

Transactional

Question 35

A workgroup database is a(n)____ database.

Answer 35

Multiuser

Question 36

____ data exist in the format in which they were collected.

Answer 36

Unstructured

Question 37

Which of the following is an example of structured data?

Answer 37

Email, web page, memo, or *spreadsheet?

Question 38

A ____ is a collection of related records.

Answer 38

File