j
,ModernjDatabasejManagement,j13ej(Hoffer)
Chapterj1j ThejDatabasejEnvironmentjandjDevelopmentjProcess
1) AccordingjtojajMcKinseyjGlobaljInstitutejReport,jinj2010jalone,jglobaljenterprisesjstoredjmor
ejthan:
A) 1jterabytejofjdata.
B) 3jgigabytesjofjdata.
C) atjleastj100jpetabytesjofjdata.
D) morejthanj7jbillionjexabytesjofjdata.jA
nswer:jD
LO:j 1.1:jDefinejkeyjterms.jDiff
iculty:jEasyjClassification:j Co
ncept
AACSB:j InformationjTechnology
2) DatabasejmanagementjinvolvesjalljofjthejfollowingjEXCEPT:
A) collectingjdata.
B) organizingjdata.
C) designjwebjpages.
D) managingjdata.
Answer:jC
LO:j 1.1:jDefinejkeyjterms.jDiff
iculty:jEasyjClassification:j Co
ncept
AACSB:j InformationjTechnology
3) Ajdatabasejisjanjorganizedjcollectionjof relatedjdata.
A) logically
B) physically
C) loosely
D) badlyjA
nswer:jA
LO:j 1.1:jDefinejkeyjterms.jDiff
iculty:jEasyjClassification:j Co
ncept
AACSB:j InformationjTechnology
4) Legacyjsystemsjoftenjcontainjdatajof qualityjandjarejgenerallyjhostedjon .
A) poor;jpersonaljcomputers
B) excellent;jmainframes
C) poor;jmainframes
D) excellent;jworkgroupjcomputersj
Answer:jC
LO:j3.1:jDefinejkeyjterms.
,5) Program-datajdependencejisjcausedjby:
A) filejdescriptionsjbeingjstoredjinjeachjdatabasejapplication.
B) datajdescriptionsjbeingjstoredjonjajserver.
C) datajdescriptionsjbeingjwrittenjintojprogrammingjcode.
D) datajcohabitingjwithjprograms.j
Answer:jA
LO:j 1.2:jNamejseveraljlimitationsjofjconventionaljfilejprocessingjsystems.jDif
ficulty:jModerate
Classification:j Concept
AACSB:j InformationjTechnology
6) Becausejapplicationsjarejoftenjdevelopedjindependentlyjinjfilejprocessingjsystems:
A) thejdatajisjalwaysjnon-redundant.
B) unplannedjduplicatejdatajfilesjarejthejrulejratherjthanjthejexception.
C) datajcanjalwaysjbejsharedjwithjothers.
D) therejisjajlargejvolumejofjfilejI/O.jA
nswer:jB
LO:j 1.2:jNamejseveraljlimitationsjofjconventionaljfilejprocessingjsystems.jDif
ficulty:jModerate
Classification:j Concept
AACSB:j InformationjTechnology
7) Relationaljdatabasesjestablishjthejrelationshipsjbetweenjentitiesjbyjmeansjofjcommonjfieldsjincl
udedjinjajfilejcalledja(n):
A) entity.
B) relationship.
C) relation.
D) association.j
Answer:jC
LO:j 1.3:jExplainjatjleastj10jadvantagesjofjthejdatabasejapproach,jcomparedjtojtraditionaljfilejprocessi
ng.
Difficulty:jModeratejClassific
ation:jConcept
AACSB:j InformationjTechnology
8) A(n)
isjoftenjdevelopedjbyjidentifyingjajformjorjreportjthatjajuserjneedsjonjajregularjbasis.
A) enterprisejview
B) reportingjdocument
C) userjview
D) userjsnapshotj
Answer:jC
LO:j 1.3:jExplainjatjleastj10jadvantagesjofjthejdatabasejapproach,jcomparedjtojtraditionaljfilejprocessi
ng.
, 9) Ajgraphicaljsystemjusedjtojcapturejthejnaturejandjrelationshipsjamongjdatajisjcalledja(n):
A) XMLjdatajmodel.
B) hypertextjgraphic.
C) relationaljdatabase.
D) datajmodel.
Answer:jD
LO:j 1.3:jExplainjatjleastj10jadvantagesjofjthejdatabasejapproach,jcomparedjtojtraditionaljfilejprocessi
ng.
Difficulty:jModeratejClassific
ation:jConcept
AACSB:j InformationjTechnology
10) Datajthatjdescribejthejpropertiesjofjotherjdatajare:
A) relationships.
B) logical.
C) physical.
D) metadata.
jAnswer:jD
LO:j 1.3:jExplainjatjleastj10jadvantagesjofjthejdatabasejapproach,jcomparedjtojtraditionaljfilejprocessi
ng.
Difficulty:jModeratejClassific
ation:jConcept
AACSB:j InformationjTechnology
11) MetatdatajtypicallyjdescribesjalljofjthejfollowingjEXCEPT:
A) datajdefinitions.
B) length.
C) allowablejvalues.
D) locationjonjdisk.
Answer:j D
LO:j 1.3:jExplainjatjleastj10jadvantagesjofjthejdatabasejapproach,jcomparedjtojtraditionaljfilejprocessi
ng.
Difficulty:jModeratejClassific
ation:jConcept
AACSB:j InformationjTechnology
4
Copyrightj©j2019jPearsonjEducation,jInc.