Modern Database Management 14th Edition Test Bank – Hoffer, Ramesh & Topi 2025

TEST BANK k




MODERNkDATABASEkMANAGEMENT,k13THkEDITION
JeffkHoffer,kRameshkVenkataraman,kHeikkikTopi

,ModernkDatabasekManagement,k13ek(Hoffer)
Chapterk1k k ThekDatabasekEnvironmentkandkDevelopmentkProcess

1) AccordingktokakMcKinseykGlobalkInstitutekReport,kink2010kalone,kglobalkenterpriseskstore
dkmorekthan:
A) 1kterabytekofkdata.
B) 3kgigabyteskofkdata.
C) atkleastk100kpetabyteskofkdata.
D) morekthank7kbillionkexabyteskofkdata
.kAnswer:k D
LO:k 1.1:kDefinekkeykterms.kD
ifficulty:k EasykClassification:
k Concept
AACSB:k InformationkTechnology

2) Databasekmanagementk involveskallkofkthekfollowingkEXCEPT:
A) collectingkdata.
B) organizingkdata.
C) designkwebkpages.
D) managingkdata.
kAnswer:k C
LO:k 1.1:kDefinekkeykterms.kD
ifficulty:k EasykClassification:
k Concept
AACSB:k InformationkTechnology

3) Akdatabasekiskankorganizedkcollectionkofk relatedkdata.
A) logically
B) physically
C) loosely
D) badlykA
nswer:k A
LO:k 1.1:kDefinekkeykterms.kD
ifficulty:k EasykClassification:
k Concept
AACSB:k InformationkTechnology

4) Legacyksystemskoftenkcontainkdatakofk qualitykandkarekgenerallykhostedkonk .
A) poor;kpersonalkcomputers
B) excellent;kmainframes
C) poor;kmainframes
D) excellent;kworkgroupkcomputers
kAnswer:k C
LO:k 3.1:kDefinekkeykterms.kD
ifficulty:k ModeratekClassifica
tion:k Concept
AACSB:k InformationkTechnology
1
Copyrightk©k2019kPearsonkEducation,kInc
.

,5) Program-datakdependencekiskcausedkby:
A) filekdescriptionskbeingkstoredkinkeachkdatabasekapplication.
B) datakdescriptionskbeingkstoredkonkakserver.
C) datakdescriptionskbeingkwrittenkintokprogrammingkcode.
D) datakcohabitingkwithkprograms.
kAnswer:k A
LO:k 1.2:kNamekseveralklimitationskofkconventionalkfilekprocessingksystems.
kDifficulty:k Moderate
Classification:k Concept
AACSB:k InformationkTechnology

6) Becausekapplicationskarekoftenkdevelopedkindependentlykinkfilekprocessingksystems:
A) thekdatakiskalwaysknon-redundant.
B) unplannedkduplicatekdatakfileskarekthekrulekratherkthankthekexception.
C) datakcankalwayskbeksharedkwithkothers.
D) therekiskaklargekvolumekofkfilekI/O
.kAnswer:k B
LO:k 1.2:kNamekseveralklimitationskofkconventionalkfilekprocessingksystems.
kDifficulty:k Moderate
Classification:k Concept
AACSB:k InformationkTechnology

7) Relationalkdatabaseskestablishkthekrelationshipskbetweenkentitieskbykmeanskofkcommonkfield
skincludedkinkakfilekcalledka(n):
A) entity.
B) relationship.
C) relation.
D) association.
kAnswer:k C

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekpr
ocessing.
Difficulty:k ModeratekClassifi
cation:k Concept
AACSB:k InformationkTechnology

8) A(n)k
iskoftenkdevelopedkbykidentifyingkakformkorkreportkthatkakuserkneedskonkakregularkbasis.
A) enterprisekview
B) reportingkdocument
C) userkview
D) userksnapshot
kAnswer:k C
LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekpr
ocessing.
Difficulty:k ModeratekClassifi
cation:k Concept
AACSB:k InformationkTechnology
2
Copyrightk©k2019kPearsonkEducation,kInc
.

, 9) Akgraphicalksystemkusedktokcapturektheknaturekandkrelationshipskamongkdatakiskcalledka(n):
A) XMLkdatakmodel.
B) hypertextkgraphic.
C) relationalkdatabase.
D) datakmodel.
kAnswer:k D
LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekpr
ocessing.
Difficulty:k ModeratekClassifi
cation:k Concept
AACSB:k InformationkTechnology

10) Datakthatkdescribekthekpropertieskofkotherkdatakare:
A) relationships.
B) logical.
C) physical.
D) metadata.
kAnswer:k D
LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekpr
ocessing.
Difficulty:k ModeratekClassifi
cation:k Concept
AACSB:k InformationkTechnology

11) MetatdataktypicallykdescribeskallkofkthekfollowingkEXCEPT:
A) datakdefinitions.
B) length.
C) allowablekvalues.
D) locationkonkdisk
.
Answer:k D
LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekpr
ocessing.
Difficulty:k ModeratekClassifi
cation:k Concept
AACSB:k InformationkTechnology




3
Copyrightk©k2019kPearsonkEducation,kInc
.