Modern Database Management, 13e (Hoffer)
Chapter 1 The Database Environment and
Development Process
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
more than:
A) 1 terabyte ofdata.
B) 3 gigabytes ofdata.
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of data.
a
Answer: D
LO: 1.1: Define key terms. Diff
iculty: Easy Classification: Co
ncept
AACSB: Information Technology
2) Database management involves all of the following EXCEPT:
A) collecting data.
B) organizing data.
C) design web pages.
D) managing data
. Answer: C
LO: 1.1: Define key terms. Diff
iculty: Easy Classification: Co
ncept
AACSB: Information Technology
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
D) badly A
nswer: A
LO: 1.1: Define key terms. Diff
iculty: Easy Classification: Co
ncept
AACSB: Information Technology
4) Legacysystems often contain data of quality and are generally hosted on .
A) poor; personal computers
B) excellent; mainframes
C) poor; mainframes
D) excellent; workgroup computers
Answer: C
1
Copyright © 2019 Pearson Education, Inc.
a
,LO: 3.1: Define key terms. Diff
iculty: Moderate Classificatio
n: Concept
AACSB: Information Technology
5) Program-data dependence is caused by:
A) file descriptions being stored in each database application.
a a
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
a
D) data cohabiting withprograms.
Answer: A
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
Moderate
Classification: Concept
AACSB: Information Technology
6) 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.
a a
C) data canalways be shared withothers.
D) there is a large volume of file I/O.
a
Answer: B
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
Moderate
Classification: Concept
AACSB: Information Technology
7) Relational databases establish the relationships between entities by means of common fields i
ncluded 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 pr
ocessing.
Difficulty: Moderate Classificatio
n: Concept
AACSB: Information Technology
8) A(n)
is often developed by identifying a formor report that a user needs on a regular basis.
A) enterprise view
B) reporting document
C) user view
D) user snapsho
t Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
2
Copyright © 2019 Pearson Education, Inc.
a
,Difficulty: Moderate Classificatio
a
n: Concept
AACSB: Information Technology
9) Agraphical system used to capturethe 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 pr
ocessing.
Difficulty: Moderate Cla
a
ssification: Concept
AACSB: Information Technology
10) Datathat describe the properties ofother dataare:
A) relationships.
B) logical.
C) physical.
D) metadata
. Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Moderate Cla
ssification: Concept
AACSB: Information Technology
11) Metatdatatypically describes all of the following EXCEPT:
A) data definitions.
B) length.
C) allowable values.
D) locationon disk.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Moderate Cla
ssification: Concept
AACSB: Information Technology
12) A person, place, object, event, or concept aboutwhichthe organization wishes to maintain d
ata is called a(n):
A) relationship.
B) object.
C) attribute.
D) entity.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pro
cessing.
Difficulty: Moderate Classific
3
Copyright © 2019 Pearson Education, Inc.
a
, ation: Concept
AACSB: Information Technology
13) are established between entities in a well-
structured database so that the desired information can be retrieved.
A) Entities
B) Relationships
C) Lines
D) Ties An
swer: B
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Moderate Classific
ation: Concept
AACSB: Information Technology
14) Allof the following are primarypurposes ofa database management system (DBMS) E
a
XCEPT:
A) creating data.
B) updating data.
C) storing data.
D) providing an integrated development environment.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
a
ocessing.
Difficulty: Difficult Classificat
ion: Concept
AACSB: Information Technology
15) Withthe database approach, data descriptions are stored in a central location known as a:
a
A) server.
B) mainframe.
C) PC.
D) repository
. Answer: D
LO: 1.6: List and briefly describe nine components ofa typical database environment. Difficulty:
Moderate
Classification: Concept
AACSB: Information Technology
16) Auser view is:
A) what a usersees when he or she looksoutthe window.
a
B) a table or setoftables.
C) a logical description ofsome portion of the database.
D) a procedure stored onthe server.
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Easy Classificati
4
Copyright © 2019 Pearson Education, Inc.
a
Chapter 1 The Database Environment and
Development Process
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
more than:
A) 1 terabyte ofdata.
B) 3 gigabytes ofdata.
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of data.
a
Answer: D
LO: 1.1: Define key terms. Diff
iculty: Easy Classification: Co
ncept
AACSB: Information Technology
2) Database management involves all of the following EXCEPT:
A) collecting data.
B) organizing data.
C) design web pages.
D) managing data
. Answer: C
LO: 1.1: Define key terms. Diff
iculty: Easy Classification: Co
ncept
AACSB: Information Technology
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
D) badly A
nswer: A
LO: 1.1: Define key terms. Diff
iculty: Easy Classification: Co
ncept
AACSB: Information Technology
4) Legacysystems often contain data of quality and are generally hosted on .
A) poor; personal computers
B) excellent; mainframes
C) poor; mainframes
D) excellent; workgroup computers
Answer: C
1
Copyright © 2019 Pearson Education, Inc.
a
,LO: 3.1: Define key terms. Diff
iculty: Moderate Classificatio
n: Concept
AACSB: Information Technology
5) Program-data dependence is caused by:
A) file descriptions being stored in each database application.
a a
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
a
D) data cohabiting withprograms.
Answer: A
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
Moderate
Classification: Concept
AACSB: Information Technology
6) 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.
a a
C) data canalways be shared withothers.
D) there is a large volume of file I/O.
a
Answer: B
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
Moderate
Classification: Concept
AACSB: Information Technology
7) Relational databases establish the relationships between entities by means of common fields i
ncluded 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 pr
ocessing.
Difficulty: Moderate Classificatio
n: Concept
AACSB: Information Technology
8) A(n)
is often developed by identifying a formor report that a user needs on a regular basis.
A) enterprise view
B) reporting document
C) user view
D) user snapsho
t Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
2
Copyright © 2019 Pearson Education, Inc.
a
,Difficulty: Moderate Classificatio
a
n: Concept
AACSB: Information Technology
9) Agraphical system used to capturethe 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 pr
ocessing.
Difficulty: Moderate Cla
a
ssification: Concept
AACSB: Information Technology
10) Datathat describe the properties ofother dataare:
A) relationships.
B) logical.
C) physical.
D) metadata
. Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Moderate Cla
ssification: Concept
AACSB: Information Technology
11) Metatdatatypically describes all of the following EXCEPT:
A) data definitions.
B) length.
C) allowable values.
D) locationon disk.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Moderate Cla
ssification: Concept
AACSB: Information Technology
12) A person, place, object, event, or concept aboutwhichthe organization wishes to maintain d
ata is called a(n):
A) relationship.
B) object.
C) attribute.
D) entity.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pro
cessing.
Difficulty: Moderate Classific
3
Copyright © 2019 Pearson Education, Inc.
a
, ation: Concept
AACSB: Information Technology
13) are established between entities in a well-
structured database so that the desired information can be retrieved.
A) Entities
B) Relationships
C) Lines
D) Ties An
swer: B
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Moderate Classific
ation: Concept
AACSB: Information Technology
14) Allof the following are primarypurposes ofa database management system (DBMS) E
a
XCEPT:
A) creating data.
B) updating data.
C) storing data.
D) providing an integrated development environment.
Answer: D
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
a
ocessing.
Difficulty: Difficult Classificat
ion: Concept
AACSB: Information Technology
15) Withthe database approach, data descriptions are stored in a central location known as a:
a
A) server.
B) mainframe.
C) PC.
D) repository
. Answer: D
LO: 1.6: List and briefly describe nine components ofa typical database environment. Difficulty:
Moderate
Classification: Concept
AACSB: Information Technology
16) Auser view is:
A) what a usersees when he or she looksoutthe window.
a
B) a table or setoftables.
C) a logical description ofsome portion of the database.
D) a procedure stored onthe server.
Answer: C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
ocessing.
Difficulty: Easy Classificati
4
Copyright © 2019 Pearson Education, Inc.
a
