MODERN DATABASE MANAGEMENT 12TH EDITION BY HOFFER - TEST BANK

,Modern Database Management, 11e (Hoffer et al.)
Chapter 1 The Database Environment and Development Process

1) One application of data warehouses is:
A) shipping of information.
B) order processing.
C) decision support.
D) file updating.
Answer: C
Diff: 3 Page Ref: 4
Topic: Introduction
AACSB: Use of Information Technology

2) Older systems that often contain data of poor quality are called ________ systems.
A) controlled
B) legacy
C) database
D) mainframe
Answer: B
Diff: 3 Page Ref: 4
Topic: Introduction
AACSB: Use of Information Technology
Subtopic: Conversion Costs

3) A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly
Answer: A
Diff: 1 Page Ref: 5
Topic: Basic Concepts and Definitions
AACSB: Use of Information Technology

4) Which of the following types of data can be stored in a database?
A) Voice
B) Letters
C) Numbers
D) All of the above
Answer: D
Diff: 1 Page Ref: 5
Topic: Basic Concepts and Definitions
AACSB: Analytic Skills, Use of Information Technology
Subtopic: Data




1
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall

,5) Data processed in a way that increases a user's knowledge is:
A) text.
B) graphics
C) information.
D) hyperlink.
Answer: C
Diff: 1 Page Ref: 6
Topic: Basic Concepts and Definitions
AACSB: Use of Information Technology
Subtopic: Data Versus Information

6) Data that describe the properties of other data are:
A) relationships.
B) logical.
C) physical.
D) none of the above.
Answer: D
Diff: 2 Page Ref: 7
Topic: Basic Concepts and Definitions
AACSB: Use of Information Technology
Subtopic: Metadata

7) All of the following are properties of metadata EXCEPT:
A) data definitions.
B) processing logic.
C) rules or constraints.
D) data structures.
Answer: B
Diff: 2 Page Ref: 7
Topic: Basic Concepts and Definitions
AACSB: Analytic Skills, Use of Information Technology
Subtopic: Metadata

8) One disadvantage of file processing systems is:
A) reduced data duplication.
B) program-data independence.
C) limited data sharing.
D) enforcement of integrity constraints.
Answer: C
Diff: 2 Page Ref: 9
Topic: Traditional File Processing Systems
AACSB: Use of Information Technology
Subtopic: Disadvantages of File Processing Systems




2
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall

, 9) Program-data dependence is caused by:
A) file descriptors being stored in each application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.
Answer: A
Diff: 2 Page Ref: 9
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:
A) the data is always non-redundant.
B) unplanned duplicate data files are the rule rather than the exception.
C) data can always be shared with others.
D) there is a large volume of file I/O.
Answer: B
Diff: 2 Page Ref: 9
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.
A) 40 percent
B) 25 percent
C) 60 percent
D) 80 percent
Answer: D
Diff: 1 Page Ref: 9
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):
A) logical data model.
B) hypertext graphic.
C) ERD.
D) data model.
Answer: D
Diff: 1 Page Ref: 10
Topic: The Database Approach
AACSB: Use of Information Technology
Subtopic: Data Models




3
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall