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

TESTBANK h




MODERN DATABASE MANAGEMENT, 13TH EDITION
h h h h




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
h h h h h

,ModernhDatabasehManagement,h13eh(Hoffer)
Chapterh1h h ThehDatabasehEnvironmenthandhDevelopmenthProcess

1) AccordinghtohahMcKinseyhGlobalhInstitutehReport,hinh2010halone,hglobalhenterpriseshstoredh
morehthan:
A) 1hterabytehofhdata.
B) 3hgigabyteshofhdata.
C) athleasth100hpetabyteshofhdata.
D) morehthanh7hbillionhexabyteshofhdata.h
Answer:h D
LO:h 1.1:hDefinehkeyhterms.hDif
ficulty:h EasyhClassification:h C
oncept
AACSB:h InformationhTechnology

2) Databasehmanagementh involveshallhofhthehfollowinghEXCEPT:
A) collectinghdata.
B) organizinghdata.
C) designhwebhpages.
D) managinghdata.
hAnswer:h C

LO:h 1.1:hDefinehkeyhterms.hDif
ficulty:h EasyhClassification:h C
oncept
AACSB:h InformationhTechnology

3) Ahdatabasehishanhorganizedhcollectionhofh relatedhdata.
A) logically
B) physically
C) loosely
D) badlyhA
nswer:h A
LO:h 1.1:hDefinehkeyhterms.hDif
ficulty:h EasyhClassification:h C
oncept
AACSB:h InformationhTechnology

4) Legacyhsystemshoftenhcontainhdatahofh qualityhandharehgenerallyhhostedhonh .
A) poor;hpersonalhcomputers
B) excellent;hmainframes
C) poor;hmainframes
D) excellent;hworkgrouphcomputers
hAnswer:h C

LO:h 3.1:hDefinehkeyhterms.hDif
ficulty:h ModeratehClassificati
on:h Concept
AACSB:h InformationhTechnology
1
Copyrighth©h2019hPearsonhEducation,hInc.

,5) Program-datahdependencehishcausedhby:
A) filehdescriptionshbeinghstoredhinheachhdatabasehapplication.
B) datahdescriptionshbeinghstoredhonhahserver.
C) datahdescriptionshbeinghwrittenhintohprogramminghcode.
D) datahcohabitinghwithhprograms.h
Answer:h A
LO:h 1.2:hNamehseveralhlimitationshofhconventionalhfilehprocessinghsystems.hD
ifficulty:h Moderate
Classification:h Concept
AACSB:h InformationhTechnology

6) Becausehapplicationsharehoftenhdevelopedhindependentlyhinhfilehprocessinghsystems:
A) thehdatahishalwayshnon-redundant.
B) unplannedhduplicatehdatahfilesharehthehrulehratherhthanhthehexception.
C) datahcanhalwayshbehsharedhwithhothers.
D) therehishahlargehvolumehofhfilehI/O.h
Answer:h B
LO:h 1.2:hNamehseveralhlimitationshofhconventionalhfilehprocessinghsystems.hD
ifficulty:h Moderate
Classification:h Concept
AACSB:h InformationhTechnology

7) Relationalhdatabaseshestablishhthehrelationshipshbetweenhentitieshbyhmeanshofhcommonhfieldshi
ncludedhinhahfilehcalledha(n):
A) entity.
B) relationship.
C) relation.
D) association.
hAnswer:h C

LO:h 1.3:hExplainhathleasth10hadvantageshofhthehdatabasehapproach,hcomparedhtohtraditionalhfilehproce
ssing.
Difficulty:h ModeratehClassific
ation:h Concept
AACSB:h InformationhTechnology

8) A(n)h
ishoftenhdevelopedhbyhidentifyinghahformhorhreporththathahuserhneedshonhahregularhbasis.
A) enterprisehview
B) reportinghdocument
C) userhview
D) userhsnapshot
hAnswer:h C

LO:h 1.3:hExplainhathleasth10hadvantageshofhthehdatabasehapproach,hcomparedhtohtraditionalhfilehproce
ssing.
Difficulty:h ModeratehClassific
ation:h Concept
AACSB:h InformationhTechnology
2
Copyrighth©h2019hPearsonhEducation,hInc.

, 9) Ahgraphicalhsystemhusedhtohcapturehthehnaturehandhrelationshipshamonghdatahishcalledha(n):
A) XMLhdatahmodel.
B) hypertexthgraphic.
C) relationalhdatabase.
D) datahmodel.
hAnswer:h D

LO:h 1.3:hExplainhathleasth10hadvantageshofhthehdatabasehapproach,hcomparedhtohtraditionalhfilehproce
ssing.
Difficulty:h ModeratehClassific
ation:h Concept
AACSB:h InformationhTechnology

10) Datahthathdescribehthehpropertieshofhotherhdatahare:
A) relationships.
B) logical.
C) physical.
D) metadata.
hAnswer:h D

LO:h 1.3:hExplainhathleasth10hadvantageshofhthehdatabasehapproach,hcomparedhtohtraditionalhfilehproce
ssing.
Difficulty:h ModeratehClassific
ation:h Concept
AACSB:h InformationhTechnology

11) MetatdatahtypicallyhdescribeshallhofhthehfollowinghEXCEPT:
A) datahdefinitions.
B) length.
C) allowablehvalues.
D) locationhonhdisk.
Answer:h D
LO:h 1.3:hExplainhathleasth10hadvantageshofhthehdatabasehapproach,hcomparedhtohtraditionalhfilehproce
ssing.
Difficulty:h ModeratehClassific
ation:h Concept
AACSB:h InformationhTechnology




3
Copyrighth©h2019hPearsonhEducation,hInc.