test bank for modern database management 13th edition heikki topi jeffrey a hoffer ramesh venkataraman

TEST BANK
k

,ModernkDatabasekManagement,k13ek(Hoffer)
Chapterk1k ThekDatabasekEnvironmentkandkDevelopmentkProcess

1) AccordingktokakMcKinseykGlobalkInstitutekReport,kink2010kalone,kglobalkenterpriseskstoredk
morekthan:
A) 1kterabytekofkdata.
B) 3kgigabyteskofkdata.
C) atkleastk100kpetabyteskofkdata.
D) morekthank7kbillionkexabyteskofkdata.k
Answer:kD
LO:k 1.1:kDefinekkeykterms.kDi
fficulty:kEasykClassification:k
Concept
AACSB:k InformationkTechnology

2) Databasekmanagementk involveskallkofkthekfollowingkEXCEPT:
A) collectingkdata.
B) organizingkdata.
C) designkwebkpages.
D) managingkdata.
Answer:kC
LO:k 1.1:kDefinekkeykterms.kDi
fficulty:kEasykClassification:k
Concept
AACSB:k InformationkTechnology

3) Akdatabasekiskankorganizedkcollectionkof relatedkdata.
A) logically
B) physically
C) loosely
D) badlykA
nswer:kA
LO:k 1.1:kDefinekkeykterms.kDi
fficulty:kEasykClassification:k
Concept
AACSB:k InformationkTechnology

4) Legacyksystemskoftenkcontainkdatakof qualitykandkarekgenerallykhostedkon .
A) poor;kpersonalkcomputers
B) excellent;kmainframes
C) poor;kmainframes
D) excellent;kworkgroupkcomputers
kAnswer:kC

LO:k3.1:kDefinekkeykterms.

,5) Program-datakdependencekiskcausedkby:
A) filekdescriptionskbeingkstoredkinkeachkdatabasekapplication.
B) datakdescriptionskbeingkstoredkonkakserver.
C) datakdescriptionskbeingkwrittenkintokprogrammingkcode.
D) datakcohabitingkwithkprograms.k
Answer:kA
LO:k 1.2:kNamekseveralklimitationskofkconventionalkfilekprocessingksystems.k
Difficulty:kModerate
Classification:k Concept
AACSB:k InformationkTechnology

6) Becausekapplicationskarekoftenkdevelopedkindependentlykinkfilekprocessingksystems:
A) thekdatakiskalwaysknon-redundant.
B) unplannedkduplicatekdatakfileskarekthekrulekratherkthankthekexception.
C) datakcankalwayskbeksharedkwithkothers.
D) therekiskaklargekvolumekofkfilekI/O.k
Answer:kB
LO:k 1.2:kNamekseveralklimitationskofkconventionalkfilekprocessingksystems.k
Difficulty:kModerate
Classification:k Concept
AACSB:k InformationkTechnology

7) Relationalkdatabaseskestablishkthekrelationshipskbetweenkentitieskbykmeanskofkcommonkfieldski
ncludedkinkakfilekcalledka(n):
A) entity.
B) relationship.
C) relation.
D) association.
kAnswer:kC

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:kModeratekClassific
ation:kConcept
AACSB:k InformationkTechnology

8) A(n)
iskoftenkdevelopedkbykidentifyingkakformkorkreportkthatkakuserkneedskonkakregularkbasis.
A) enterprisekview
B) reportingkdocument
C) userkview
D) userksnapshot
kAnswer:kC

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.

, 9) Akgraphicalksystemkusedktokcapturektheknaturekandkrelationshipskamongkdatakiskcalledka(n):
A) XMLkdatakmodel.
B) hypertextkgraphic.
C) relationalkdatabase.
D) datakmodel.
Answer:kD
LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:kModeratekClassific
ation:kConcept
AACSB:k InformationkTechnology

10) Datakthatkdescribekthekpropertieskofkotherkdatakare:
A) relationships.
B) logical.
C) physical.
D) metadata.
kAnswer:kD

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:kModeratekClassific
ation:kConcept
AACSB:k InformationkTechnology

11) MetatdataktypicallykdescribeskallkofkthekfollowingkEXCEPT:
A) datakdefinitions.
B) length.
C) allowablekvalues.
D) locationkonkdisk.
Answer:k D
LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:kModeratekClassific
ation:kConcept
AACSB:k InformationkTechnology




4
Copyrightk©k2019kPearsonkEducation,kInc.