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
a a a a a a a a a a a a a
more than: a
A) 1 terabyte of data.
a a a
B) 3 gigabytes of data.
a a a
C) at least 100 petabytes of data.
a a a a a
D) more than 7 billion exabytes of data.
a a a a a a a
Answer: D aa
LO: 1.1: Define key terms. Diff
aa a a a a
iculty: Easy Classification: Co
aa a aa
ncept
AACSB: Information Technology
aa a
2) Database management involves all of the following EXCEPT:
a a a a a a a
A) collecting data. a
B) organizing data. a
C) design web pages. a a
D) managing data a
. Answer: C
a aa
LO: 1.1: Define key terms. Diff
aa a a a a
iculty: Easy Classification: Co
aa a aa
ncept
AACSB: Information Technology
aa a
3) A database is an organized collection of
a a a a a a related data.
a
A) logically
B) physically
C) loosely
D) badly A a
nswer: A aa
LO: 1.1: Define key terms. Diff
aa a a a a
iculty: Easy Classification: Co
aa a aa
ncept
AACSB: Information Technology
aa a
4) Legacy systems often contain data of
a a a a a quality and are generally hosted on
a a a a a .
A) poor; personal computers
a a
B) excellent; mainframes a
C) poor; mainframes a
D) excellent; workgroup computers a a
aAnswer: C aa
1
Copyright © 2019 Pearson Education, Inc.
a a a a a
,LO: 3.1: Define key terms. Diff
aa a a a a
iculty: Moderate Classificatio
aa a
n: Concept
aa
AACSB: Information Technology
aa a
2
Copyright © 2019 Pearson Education, Inc.
a a a a a
,5) Program-data dependence is caused by: a a a a
A) file descriptions being stored in each database application.
a a a a a a a
B) data descriptions being stored on a server.
a a a a a a
C) data descriptions being written into programming code.
a a a a a a
D) data cohabiting with programs.
a a a
aAnswer: A aa
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
aa a a a a a a a a a aa
Moderate
Classification: Concept aa
AACSB: Information Technology aa a
6) Because applications are often developed independently in file processing systems:
a a a a a a a a a
A) the data is always non-redundant.
a a a a
B) unplanned duplicate data files are the rule rather than the exception.
a a a a a a a a a a
C) data can always be shared with others.
a a a a a a
D) there is a large volume of file I/O.
a a a a a a a a
Answer: B aa
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
aa a a a a a a a a a aa
Moderate
Classification: Concept aa
AACSB: Information Technology aa a
7) Relational databases establish the relationships between entities by means of common fields i
a a a a a a a a a a a a
ncluded in a file called a(n):
a a a a a
A) entity.
B) relationship.
C) relation.
D) association.
aAnswer: C aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Classificatio aa a
n: Concept
aa
AACSB: Information Technology aa a
8) A(n)
is often developed by identifying a form or report that a user needs on a regular basis.
a a a a a a a a a a a a a a a a
A) enterprise view a
B) reporting document a
C) user view a
D) user snapsho a
t Answer: C
a aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Classificatio aa a
n: Concept
aa
AACSB: Information Technology aa a
3
Copyright © 2019 Pearson Education, Inc. a a a a a
, 9) A graphical system used to capture the nature and relationships among data is called a(n):
a a a a a a a a a a a a a a
A) XML data model. a a
B) hypertext graphic. a
C) relational database. a
D) data model.
a
aAnswer: D aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Cla aa a
ssification: Concept aa
AACSB: Information Technology
aa a
10) Data that describe the properties of other data are:
a a a a a a a a
A) relationships.
B) logical.
C) physical.
D) metadata
. Answer: D
a aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Cla aa a
ssification: Concept aa
AACSB: Information Technology
aa a
11) Metatdata typically describes all of the following EXCEPT:
a a a a a a a
A) data definitions.
a
B) length.
C) allowable values. a
D) location on disk. a a
aAnswer: D aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Cla aa a
ssification: Concept aa
AACSB: Information Technology
aa a
4
Copyright © 2019 Pearson Education, Inc.
a a a a a
Chapter 1 The Database Environment and
Development Process
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
a a a a a a a a a a a a a
more than: a
A) 1 terabyte of data.
a a a
B) 3 gigabytes of data.
a a a
C) at least 100 petabytes of data.
a a a a a
D) more than 7 billion exabytes of data.
a a a a a a a
Answer: D aa
LO: 1.1: Define key terms. Diff
aa a a a a
iculty: Easy Classification: Co
aa a aa
ncept
AACSB: Information Technology
aa a
2) Database management involves all of the following EXCEPT:
a a a a a a a
A) collecting data. a
B) organizing data. a
C) design web pages. a a
D) managing data a
. Answer: C
a aa
LO: 1.1: Define key terms. Diff
aa a a a a
iculty: Easy Classification: Co
aa a aa
ncept
AACSB: Information Technology
aa a
3) A database is an organized collection of
a a a a a a related data.
a
A) logically
B) physically
C) loosely
D) badly A a
nswer: A aa
LO: 1.1: Define key terms. Diff
aa a a a a
iculty: Easy Classification: Co
aa a aa
ncept
AACSB: Information Technology
aa a
4) Legacy systems often contain data of
a a a a a quality and are generally hosted on
a a a a a .
A) poor; personal computers
a a
B) excellent; mainframes a
C) poor; mainframes a
D) excellent; workgroup computers a a
aAnswer: C aa
1
Copyright © 2019 Pearson Education, Inc.
a a a a a
,LO: 3.1: Define key terms. Diff
aa a a a a
iculty: Moderate Classificatio
aa a
n: Concept
aa
AACSB: Information Technology
aa a
2
Copyright © 2019 Pearson Education, Inc.
a a a a a
,5) Program-data dependence is caused by: a a a a
A) file descriptions being stored in each database application.
a a a a a a a
B) data descriptions being stored on a server.
a a a a a a
C) data descriptions being written into programming code.
a a a a a a
D) data cohabiting with programs.
a a a
aAnswer: A aa
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
aa a a a a a a a a a aa
Moderate
Classification: Concept aa
AACSB: Information Technology aa a
6) Because applications are often developed independently in file processing systems:
a a a a a a a a a
A) the data is always non-redundant.
a a a a
B) unplanned duplicate data files are the rule rather than the exception.
a a a a a a a a a a
C) data can always be shared with others.
a a a a a a
D) there is a large volume of file I/O.
a a a a a a a a
Answer: B aa
LO: 1.2: Name several limitations of conventional file processing systems. Difficulty:
aa a a a a a a a a a aa
Moderate
Classification: Concept aa
AACSB: Information Technology aa a
7) Relational databases establish the relationships between entities by means of common fields i
a a a a a a a a a a a a
ncluded in a file called a(n):
a a a a a
A) entity.
B) relationship.
C) relation.
D) association.
aAnswer: C aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Classificatio aa a
n: Concept
aa
AACSB: Information Technology aa a
8) A(n)
is often developed by identifying a form or report that a user needs on a regular basis.
a a a a a a a a a a a a a a a a
A) enterprise view a
B) reporting document a
C) user view a
D) user snapsho a
t Answer: C
a aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Classificatio aa a
n: Concept
aa
AACSB: Information Technology aa a
3
Copyright © 2019 Pearson Education, Inc. a a a a a
, 9) A graphical system used to capture the nature and relationships among data is called a(n):
a a a a a a a a a a a a a a
A) XML data model. a a
B) hypertext graphic. a
C) relational database. a
D) data model.
a
aAnswer: D aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Cla aa a
ssification: Concept aa
AACSB: Information Technology
aa a
10) Data that describe the properties of other data are:
a a a a a a a a
A) relationships.
B) logical.
C) physical.
D) metadata
. Answer: D
a aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Cla aa a
ssification: Concept aa
AACSB: Information Technology
aa a
11) Metatdata typically describes all of the following EXCEPT:
a a a a a a a
A) data definitions.
a
B) length.
C) allowable values. a
D) location on disk. a a
aAnswer: D aa
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file pr
aa a a a a a a a a a a a a a a
ocessing.
Difficulty: Moderate Cla aa a
ssification: Concept aa
AACSB: Information Technology
aa a
4
Copyright © 2019 Pearson Education, Inc.
a a a a a
