Modern Database Management 13th Edition Hoffer, Topi, Venkataraman – Chapter 1-7 Questions & Answers

TESTBANK y




MODERN DATABASE MANAGEMENT, 13TH EDITION
y y y y




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
y y y y y

,ModernyDatabaseyManagement,y13ey(Hoffer)
Chaptery1y y TheyDatabaseyEnvironmentyandyDevelopmentyProcess

1) AccordingytoyayMcKinseyyGlobalyInstituteyReport,yiny2010yalone,yglobalyenterprisesystoredy
moreythan:
A) 1yterabyteyofydata.
B) 3ygigabytesyofydata.
C) atyleasty100ypetabytesyofydata.
D) moreythany7ybillionyexabytesyofydata.y
Answer:y D
LO:y 1.1:yDefineykeyyterms.yDif
ficulty:y EasyyClassification:y C
oncept
AACSB:y InformationyTechnology

2) DatabaseymanagementyinvolvesyallyofytheyfollowingyEXCEPT:
A) collectingydata.
B) organizingydata.
C) designywebypages.
D) managingydata.
yAnswer:y C

LO:y 1.1:yDefineykeyyterms.yDif
ficulty:y EasyyClassification:y C
oncept
AACSB:y InformationyTechnology

3) Aydatabaseyisyanyorganizedycollectionyofy relatedydata.
A) logically
B) physically
C) loosely
D) badlyyA
nswer:y A
LO:y 1.1:yDefineykeyyterms.yDif
ficulty:y EasyyClassification:y C
oncept
AACSB:y InformationyTechnology

4) Legacyysystemsyoftenycontainydatayofy qualityyandyareygenerallyyhostedyony .
A) poor;ypersonalycomputers
B) excellent;ymainframes
C) poor;ymainframes
D) excellent;yworkgroupycomputers
yAnswer:y C

LO:y 3.1:yDefineykeyyterms.yDif
ficulty:y ModerateyClassificati
on:y Concept
AACSB:y InformationyTechnology
1
Copyrighty©y2019yPearsonyEducation,yInc.

,5) Program-dataydependenceyisycausedyby:
A) fileydescriptionsybeingystoredyinyeachydatabaseyapplication.
B) dataydescriptionsybeingystoredyonyayserver.
C) dataydescriptionsybeingywrittenyintoyprogrammingycode.
D) dataycohabitingywithyprograms.y
Answer:y A
LO:y 1.2:yNameyseveralylimitationsyofyconventionalyfileyprocessingysystems.yD
ifficulty:y Moderate
Classification:y Concept
AACSB:y InformationyTechnology

6) Becauseyapplicationsyareyoftenydevelopedyindependentlyyinyfileyprocessingysystems:
A) theydatayisyalwaysynon-redundant.
B) unplannedyduplicateydatayfilesyareytheyruleyratherythanytheyexception.
C) dataycanyalwaysybeysharedywithyothers.
D) thereyisyaylargeyvolumeyofyfileyI/O.y
Answer:y B
LO:y 1.2:yNameyseveralylimitationsyofyconventionalyfileyprocessingysystems.yD
ifficulty:y Moderate
Classification:y Concept
AACSB:y InformationyTechnology

7) Relationalydatabasesyestablishytheyrelationshipsybetweenyentitiesybyymeansyofycommonyfieldsyi
ncludedyinyayfileycalledya(n):
A) entity.
B) relationship.
C) relation.
D) association.
yAnswer:y C

LO:y 1.3:yExplainyatyleasty10yadvantagesyofytheydatabaseyapproach,ycomparedytoytraditionalyfileyproce
ssing.
Difficulty:y ModerateyClassific
ation:y Concept
AACSB:y InformationyTechnology

8) A(n)y
isyoftenydevelopedybyyidentifyingyayformyoryreportythatyayuseryneedsyonyayregularybasis.
A) enterpriseyview
B) reportingydocument
C) useryview
D) userysnapshot
yAnswer:y C

LO:y 1.3:yExplainyatyleasty10yadvantagesyofytheydatabaseyapproach,ycomparedytoytraditionalyfileyproce
ssing.
Difficulty:y ModerateyClassific
ation:y Concept
AACSB:y InformationyTechnology
2
Copyrighty©y2019yPearsonyEducation,yInc.

, 9) Aygraphicalysystemyusedytoycaptureytheynatureyandyrelationshipsyamongydatayisycalledya(n):
A) XMLydataymodel.
B) hypertextygraphic.
C) relationalydatabase.
D) dataymodel.
yAnswer:y D

LO:y 1.3:yExplainyatyleasty10yadvantagesyofytheydatabaseyapproach,ycomparedytoytraditionalyfileyproce
ssing.
Difficulty:y ModerateyClassific
ation:y Concept
AACSB:y InformationyTechnology

10) Dataythatydescribeytheypropertiesyofyotherydatayare:
A) relationships.
B) logical.
C) physical.
D) metadata.
yAnswer:y D

LO:y 1.3:yExplainyatyleasty10yadvantagesyofytheydatabaseyapproach,ycomparedytoytraditionalyfileyproce
ssing.
Difficulty:y ModerateyClassific
ation:y Concept
AACSB:y InformationyTechnology

11) MetatdataytypicallyydescribesyallyofytheyfollowingyEXCEPT:
A) dataydefinitions.
B) length.
C) allowableyvalues.
D) locationyonydisk.
Answer:y D
LO:y 1.3:yExplainyatyleasty10yadvantagesyofytheydatabaseyapproach,ycomparedytoytraditionalyfileyproce
ssing.
Difficulty:y ModerateyClassific
ation:y Concept
AACSB:y InformationyTechnology




3
Copyrighty©y2019yPearsonyEducation,yInc.