TEST BANK
,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 of data.
B) 3 gigabytes of data.
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of data.
Answer: D
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
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.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
D) badly
Answer: A
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
4) Legacy systems 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
LO: 3.1: Define key terms.
,5) 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 iof iconventional ifile iprocessing isystems.
iDifficulty: iModerate
Classification: i Concept
AACSB: i Information iTechnology
6) Because iapplications iare ioften ideveloped iindependently iin ifile iprocessing isystems:
A) the idata iis ialways inon-redundant.
B) unplanned iduplicate idata ifiles iare ithe irule irather ithan ithe iexception.
C) data ican ialways ibe ishared iwith iothers.
D) there iis ia ilarge ivolume iof ifile
iI/O. iAnswer: iB
LO: i 1.2: iName iseveral ilimitations iof iconventional ifile iprocessing
isystems. iDifficulty: iModerate
Classification: i Concept
AACSB: i Information iTechnology
7) Relational idatabases iestablish ithe irelationships ibetween ientities iby imeans iof icommon
ifields iincluded iin ia ifile icalled ia(n):
A) entity.
B) relationship.
C) relation.
D) association.
iAnswer: iC
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
8) A(n) is ioften ideveloped iby iidentifying ia iform ior ireport ithat ia iuser ineeds
ion ia iregular ibasis.
A) enterprise iview
B) reporting idocument
C) user iview
D) user isnapshot
iAnswer: iC
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
, 9) A igraphical isystem iused ito icapture ithe inature iand irelationships iamong idata iis icalled ia(n):
A) XML idata imodel.
B) hypertext igraphic.
C) relational idatabase.
D) data
imodel.
Answer: iD
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
10) Data ithat idescribe ithe iproperties iof iother idata iare:
A) relationships.
B) logical.
C) physical.
D) metadata.
iAnswer: iD
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
11) Metatdata itypically idescribes iall iof ithe ifollowing iEXCEPT:
A) data idefinitions.
B) length.
C) allowable ivalues.
D) location ion
idisk.
Answer: i D
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
4
Copyright © 2019 Pearson Education, Inc.
,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 of data.
B) 3 gigabytes of data.
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of data.
Answer: D
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
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.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
D) badly
Answer: A
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
4) Legacy systems 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
LO: 3.1: Define key terms.
,5) 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 iof iconventional ifile iprocessing isystems.
iDifficulty: iModerate
Classification: i Concept
AACSB: i Information iTechnology
6) Because iapplications iare ioften ideveloped iindependently iin ifile iprocessing isystems:
A) the idata iis ialways inon-redundant.
B) unplanned iduplicate idata ifiles iare ithe irule irather ithan ithe iexception.
C) data ican ialways ibe ishared iwith iothers.
D) there iis ia ilarge ivolume iof ifile
iI/O. iAnswer: iB
LO: i 1.2: iName iseveral ilimitations iof iconventional ifile iprocessing
isystems. iDifficulty: iModerate
Classification: i Concept
AACSB: i Information iTechnology
7) Relational idatabases iestablish ithe irelationships ibetween ientities iby imeans iof icommon
ifields iincluded iin ia ifile icalled ia(n):
A) entity.
B) relationship.
C) relation.
D) association.
iAnswer: iC
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
8) A(n) is ioften ideveloped iby iidentifying ia iform ior ireport ithat ia iuser ineeds
ion ia iregular ibasis.
A) enterprise iview
B) reporting idocument
C) user iview
D) user isnapshot
iAnswer: iC
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
, 9) A igraphical isystem iused ito icapture ithe inature iand irelationships iamong idata iis icalled ia(n):
A) XML idata imodel.
B) hypertext igraphic.
C) relational idatabase.
D) data
imodel.
Answer: iD
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
10) Data ithat idescribe ithe iproperties iof iother idata iare:
A) relationships.
B) logical.
C) physical.
D) metadata.
iAnswer: iD
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
11) Metatdata itypically idescribes iall iof ithe ifollowing iEXCEPT:
A) data idefinitions.
B) length.
C) allowable ivalues.
D) location ion
idisk.
Answer: i D
LO: i 1.3: iExplain iat ileast i10 iadvantages iof ithe idatabase iapproach, icompared ito itraditional ifile
iprocessing.
Difficulty: iModerate
iClassification: i Concept
AACSB: i Information iTechnology
4
Copyright © 2019 Pearson Education, Inc.
