Modern Database Management, 12e (Hoffer)
Chapter 1 The Database Environment and Development Process
1) A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly
Answer: A
LO: 3.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: 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
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
,3) Program-data dependence is caused by:
A) file descriptions being stored in each database application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.
Answer: A
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
4) 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
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
5) Relational databases establish the relationships between entities by means of common
fields included in a file called a(n):
A) entity.
B) relationship.
,C) relation.
D) association.
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
file processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
6) A(n) ________ is often developed by identifying a form or report that a user needs on
a regular basis.
A) enterprise view
B) reporting document
C) user view
D) user snapshot
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
file processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
7) A graphical system used to capture the nature and relationships among data is called
a(n):
A) XML data model.
B) hypertext graphic.
C) relational database
, D) data model.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
file processing.
Difficulty: Moderate
Classification: Concept
Chapter 1 The Database Environment and Development Process
1) A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly
Answer: A
LO: 3.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: 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
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
,3) Program-data dependence is caused by:
A) file descriptions being stored in each database application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.
Answer: A
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
4) 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
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
5) Relational databases establish the relationships between entities by means of common
fields included in a file called a(n):
A) entity.
B) relationship.
,C) relation.
D) association.
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
file processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
6) A(n) ________ is often developed by identifying a form or report that a user needs on
a regular basis.
A) enterprise view
B) reporting document
C) user view
D) user snapshot
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
file processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
7) A graphical system used to capture the nature and relationships among data is called
a(n):
A) XML data model.
B) hypertext graphic.
C) relational database
, D) data model.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional
file processing.
Difficulty: Moderate
Classification: Concept
