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

TESTBANK k




MODERN DATABASE MANAGEMENT, 13TH EDITION
k k k k




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
k k k k k

,ModernkDatabasekManagement,k13ek(Hoffer)
Chapterk1k k ThekDatabasekEnvironmentkandkDevelopmentkProcess

1) AccordingktokakMcKinseykGlobalkInstitutekReport,kink2010kalone,kglobalkenterpriseskstoredk
morekthan:
A) 1kterabytekofkdata.
B) 3kgigabyteskofkdata.
C) atkleastk100kpetabyteskofkdata.
D) morekthank7kbillionkexabyteskofkdata.k
Answer:k D
LO:k 1.1:kDefinekkeykterms.kDif
ficulty:k EasykClassification:k C
oncept
AACSB:k InformationkTechnology

2) Databasekmanagementk involveskallkofkthekfollowingkEXCEPT:
A) collectingkdata.
B) organizingkdata.
C) designkwebkpages.
D) managingkdata.
kAnswer:k C

LO:k 1.1:kDefinekkeykterms.kDif
ficulty:k EasykClassification:k C
oncept
AACSB:k InformationkTechnology

3) Akdatabasekiskankorganizedkcollectionkofk relatedkdata.
A) logically
B) physically
C) loosely
D) badlykA
nswer:k A
LO:k 1.1:kDefinekkeykterms.kDif
ficulty:k EasykClassification:k C
oncept
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.kDif
ficulty:k ModeratekClassificati
on:k Concept
AACSB:k InformationkTechnology
1
Copyright © 2019 Pearson Education, Inc.

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

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

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

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:k ModeratekClassific
ation: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,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:k ModeratekClassific
ation:k Concept
AACSB:k InformationkTechnology
2
Copyright © 2019 Pearson Education, Inc.

, 9) Akgraphicalksystemkusedktokcapturektheknaturekandkrelationshipskamongkdatakiskcalledka(n):
A) XMLkdatakmodel.
B) hypertextkgraphic.
C) relationalkdatabase.
D) datakmodel.
kAnswer:k D

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:k ModeratekClassific
ation:k Concept
AACSB:k InformationkTechnology

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

LO:k 1.3:kExplainkatkleastk10kadvantageskofkthekdatabasekapproach,kcomparedktoktraditionalkfilekproc
essing.
Difficulty:k ModeratekClassific
ation:k Concept
AACSB:k InformationkTechnology

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




3
Copyright © 2019 Pearson Education, Inc.