Test Bank for Modern Database Management 13th Edition, Hoffer Topi Venkataraman all chapters 1-14 complete

TESTBANK n




MODERN DATABASE MANAGEMENT, 13TH EDITION
n n n n




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
n n n n n

,ModernnDatabasenManagement,n13en(Hoffer)
Chaptern1n n ThenDatabasenEnvironmentnandnDevelopmentnProcess

1) nAccordingntonanMcKinseynGlobalnInstitutenReport,ninn2010nalone,nglobalnenterprisesnstoredn
morenthan:
A) 1nterabytenofndata.
B) 3ngigabytesnofndata.
C) atnleastn100npetabytesnofndata.
D) morenthann7nbillionnexabytesnofndata.n
Answer:n D
LO:n 1.1:nDefinenkeynterms.nDif
ficulty:n EasynClassification:n C
oncept
AACSB:n InformationnTechnology

2) Databasenmanagementn involvesnallnofnthenfollowingnEXCEPT:
A) collectingndata.
B) organizingndata.
C) designnwebnpages.
D) managingndata.
nAnswer:n C

LO:n 1.1:nDefinenkeynterms.nDif
ficulty:n EasynClassification:n C
oncept
AACSB:n InformationnTechnology

3) Andatabasenisnannorganizedncollectionnofn relatedndata.
A) logically
B) physically
C) loosely
D) badlynA
nswer:n A
LO:n 1.1:nDefinenkeynterms.nDif
ficulty:n EasynClassification:n C
oncept
AACSB:n InformationnTechnology

4) Legacynsystemsnoftenncontainndatanofn qualitynandnarengenerallynhostednonn .
A) poor;npersonalncomputers
B) excellent;nmainframes
C) poor;nmainframes
D) excellent;nworkgroupncomputers
nAnswer:n C

LO:n 3.1:nDefinenkeynterms.nDif
ficulty:n ModeratenClassificati
on:n Concept
AACSB:n InformationnTechnology
1
Copyrightn©n2019nPearsonnEducation,nInc.

,5) Program-datandependencenisncausednby:
A) filendescriptionsnbeingnstoredninneachndatabasenapplication.
B) datandescriptionsnbeingnstorednonnanserver.
C) datandescriptionsnbeingnwrittennintonprogrammingncode.
D) datancohabitingnwithnprograms.n
Answer:n A
LO:n 1.2:nNamenseveralnlimitationsnofnconventionalnfilenprocessingnsystems.nD
ifficulty:n Moderate
Classification:n Concept
AACSB:n InformationnTechnology

6) Becausenapplicationsnarenoftenndevelopednindependentlyninnfilenprocessingnsystems:
A) thendatanisnalwaysnnon-redundant.
B) unplannednduplicatendatanfilesnarenthenrulenrathernthannthenexception.
C) datancannalwaysnbensharednwithnothers.
D) therenisnanlargenvolumenofnfilenI/O.n
Answer:n B
LO:n 1.2:nNamenseveralnlimitationsnofnconventionalnfilenprocessingnsystems.nD
ifficulty:n Moderate
Classification:n Concept
AACSB:n InformationnTechnology

7) Relationalndatabasesnestablishnthenrelationshipsnbetweennentitiesnbynmeansnofncommonnfieldsni
ncludedninnanfilencalledna(n):
A) entity.
B) relationship.
C) relation.
D) association.
nAnswer:n C

LO:n 1.3:nExplainnatnleastn10nadvantagesnofnthendatabasenapproach,ncomparedntontraditionalnfilenproce
ssing.
Difficulty:n ModeratenClassific
ation:n Concept
AACSB:n InformationnTechnology

8) A(n)n
isnoftenndevelopednbynidentifyingnanformnornreportnthatnanusernneedsnonnanregularnbasis.
A) enterprisenview
B) reportingndocument
C) usernview
D) usernsnapshot
nAnswer:n C

LO:n 1.3:nExplainnatnleastn10nadvantagesnofnthendatabasenapproach,ncomparedntontraditionalnfilenproce
ssing.
Difficulty:n ModeratenClassific
ation:n Concept
AACSB:n InformationnTechnology
2
Copyrightn©n2019nPearsonnEducation,nInc.

, 9) Angraphicalnsystemnusedntoncapturenthennaturenandnrelationshipsnamongndatanisncalledna(n):
A) XMLndatanmodel.
B) hypertextngraphic.
C) relationalndatabase.
D) datanmodel.
nAnswer:n D

LO:n 1.3:nExplainnatnleastn10nadvantagesnofnthendatabasenapproach,ncomparedntontraditionalnfilenproce
ssing.
Difficulty:n ModeratenClassific
ation:n Concept
AACSB:n InformationnTechnology

10) Datanthatndescribenthenpropertiesnofnotherndatanare:
A) relationships.
B) logical.
C) physical.
D) metadata.
nAnswer:n D

LO:n 1.3:nExplainnatnleastn10nadvantagesnofnthendatabasenapproach,ncomparedntontraditionalnfilenproce
ssing.
Difficulty:n ModeratenClassific
ation:n Concept
AACSB:n InformationnTechnology

11) MetatdatantypicallyndescribesnallnofnthenfollowingnEXCEPT:
A) datandefinitions.
B) length.
C) allowablenvalues.
D) locationnonndisk.
Answer:n D
LO:n 1.3:nExplainnatnleastn10nadvantagesnofnthendatabasenapproach,ncomparedntontraditionalnfilenproce
ssing.
Difficulty:n ModeratenClassific
ation:n Concept
AACSB:n InformationnTechnology




3
Copyrightn©n2019nPearsonnEducation,nInc.