Copyright 2014 Pearson Education, Inc.

1 Copyright © 2014 Pearson Education, Inc.

Chapter 1 The Database Environment and Development Process

1) One application of data warehouses is:

• shipping of information.
• order processing.
• decision support.
• file updating.

Answer: C

Diff: 3 Page Ref: 4

Topic: Distributed DBMS

AACSB: Use of Information Technology

2) Older systems that often contain data of poor quality are called ________ systems.

• controlled
• legacy
• database
• mainframe

Answer: B

Diff: 3 Page Ref: 3

Topic: Basic Concepts and Definitions

AACSB: Use of Information Technology

Subtopic: Conversion Costs

3) A database is an organized collection of ________ related data.

• logically
• physically
• loosely
• badly

Answer: A

Diff: 1 Page Ref: 4

Topic: Basic Concepts and Definitions

AACSB: Use of Information Technology

4) Which of the following types of data can be stored in a database?

• Voice
• Letters
• Numbers
• All of the above

Answer: D

Diff: 1 Page Ref: 4

Topic: Basic Concepts and Definitions

AACSB: Analytic Skills, Use of Information Technology

Subtopic: Data

(Essentials of Database Management 1e Jeffrey Hoffer, Heikki Topi, Ramesh Venkataraman) (Test Bank all Chapters) 1 / 4

2 Copyright © 2014 Pearson Education, Inc.

5) Data processed in a way that increases a user's knowledge is:

• text.
• graphics
• information.
• hyperlink.

Answer: C

Diff: 1 Page Ref: 5

Topic: Basic Concepts and Definitions

AACSB: Use of Information Technology

Subtopic: Data Versus Information

6) Data that describe the properties of other data are:

• relationships.
• logical.
• physical.
• none of the above.

Answer: D

Diff: 2 Page Ref: 6

Topic: Basic Concepts and Definitions

AACSB: Use of Information Technology

Subtopic: Metadata

7) All of the following are properties of metadata EXCEPT:

• data definitions.
• processing logic.
• rules or constraints.
• data structures.

Answer: B

Diff: 2 Page Ref: 6

Topic: Basic Concepts and Definitions

AACSB: Analytic Skills, Use of Information Technology

Subtopic: Metadata

8) One disadvantage of file processing systems is:

• reduced data duplication.
• program-data independence.
• limited data sharing.
• enforcement of integrity constraints.

Answer: C

Diff: 2 Page Ref: 7-8

Topic: Traditional File Processing Systems

AACSB: Use of Information Technology

Subtopic: Disadvantages of File Processing Systems 2 / 4

3 Copyright © 2014 Pearson Education, Inc.

9) Program-data dependence is caused by:

• file descriptors being stored in each application.
• data descriptions being stored on a server.
• data descriptions being written into programming code.
• data cohabiting with programs.

Answer: A

Diff: 2 Page Ref: 7

Topic: Disadvantages of File Processing Systems

AACSB: Use of Information Technology

Subtopic: Program-Data Dependence

10) Because applications are often developed independently in file processing systems:

• the data is always nonredundant.
• unplanned duplicate data files are the rule rather than the exception.
• data can always be shared with others.
• there is a large volume of file I/O.

Answer: B

Diff: 2 Page Ref: 8

Topic: Disadvantages of File Processing Systems

AACSB: Analytic Skills, Use of Information Technology

Subtopic: Duplication of Data

11) Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

• 40 percent
• 25 percent
• 60 percent
• 80 percent

Answer: D

Diff: 1 Page Ref: 8

Topic: Disadvantages of File Processing Systems

AACSB: Use of Information Technology

Subtopic: Excessive Program Maintenance

12) A graphical system used to capture the nature and relationships among data is called a(n):

• logical data model.
• hypertext graphic.

C) ERD.

• data model.

Answer: D

Diff: 1 Page Ref: 8

Topic: The Database Approach

AACSB: Use of Information Technology

Subtopic: Data Models 3 / 4

4 Copyright © 2014 Pearson Education, Inc.13) A person, place, object, event or concept about which the organization wishes to maintain

data is called a(n):

• relationship.
• object.
• attribute.
• entity.

Answer: D

Diff: 2 Page Ref: 8

Topic: The Database Approach

AACSB: Analytic Skills, Use of Information Technology

Subtopic: Data Models

14) ________ are established between entities in a well-structured database so that the desired information can be retrieved.

• Entities
• Relationships
• Lines
• Ties

Answer: B

Diff: 2 Page Ref: 9

Topic: The Database Approach

AACSB: Analytic Skills, Use of Information Technology

Subtopic: Data Models

15) Relational databases establish the relationships between entities by means of common fields

included in a file called a(n):

• entity.
• relationship.
• relation.
• association.

Answer: C

Diff: 3 Page Ref: 10

Topic: The Database Approach

AACSB: Reflective Thinking

Subtopic: Relational Databases

16) All of the following are primary purposes of a database management system (DBMS)

EXCEPT:

• creating data.
• updating data.
• storing data.
• providing an integrated development environment.

Answer: D

Diff: 3 Page Ref: 10

Topic: The Database Approach

AACSB: Analytic Skills, Reflective Thinking

Subtopic: Database Management Systems

• / 4