TEST BANK
d
,ModerndDatabasedManagement,d13ed(Hoffer)
Chapterd1d ThedDatabasedEnvironmentdanddDevelopmentdProcess
1) AccordingdtodadMcKinseydGlobaldInstitutedReport,dind2010dalone,dglobaldenterprisesdstoredd
moredthan:
A) 1dterabytedofddata.
B) 3dgigabytesdofddata.
C) atdleastd100dpetabytesdofddata.
D) moredthand7dbilliondexabytesdofddata.d
Answer:dD
LO:d 1.1:dDefinedkeydterms.dDi
fficulty:dEasydClassification:d
Concept
AACSB:d InformationdTechnology
2) Databasedmanagementd involvesdalldofdthedfollowingdEXCEPT:
A) collectingddata.
B) organizingddata.
C) designdwebdpages.
D) managingddata.
Answer:dC
LO:d 1.1:dDefinedkeydterms.dDi
fficulty:dEasydClassification:d
Concept
AACSB:d InformationdTechnology
3) Addatabasedisdandorganizeddcollectiondof relatedddata.
A) logically
B) physically
C) loosely
D) badlydA
nswer:dA
LO:d 1.1:dDefinedkeydterms.dDi
fficulty:dEasydClassification:d
Concept
AACSB:d InformationdTechnology
4) Legacydsystemsdoftendcontainddatadof qualitydanddaredgenerallydhosteddon .
A) poor;dpersonaldcomputers
B) excellent;dmainframes
C) poor;dmainframes
D) excellent;dworkgroupdcomputers
dAnswer:dC
LO:d3.1:dDefinedkeydterms.
,5) Program-dataddependencedisdcauseddby:
A) fileddescriptionsdbeingdstoreddindeachddatabasedapplication.
B) dataddescriptionsdbeingdstoreddondadserver.
C) dataddescriptionsdbeingdwrittendintodprogrammingdcode.
D) datadcohabitingdwithdprograms.d
Answer:dA
LO:d 1.2:dNamedseveraldlimitationsdofdconventionaldfiledprocessingdsystems.d
Difficulty:dModerate
Classification:d Concept
AACSB:d InformationdTechnology
6) Becausedapplicationsdaredoftenddevelopeddindependentlydindfiledprocessingdsystems:
A) theddatadisdalwaysdnon-redundant.
B) unplanneddduplicateddatadfilesdaredthedruledratherdthandthedexception.
C) datadcandalwaysdbedshareddwithdothers.
D) theredisdadlargedvolumedofdfiledI/O.d
Answer:dB
LO:d 1.2:dNamedseveraldlimitationsdofdconventionaldfiledprocessingdsystems.d
Difficulty:dModerate
Classification:d Concept
AACSB:d InformationdTechnology
7) Relationalddatabasesdestablishdthedrelationshipsdbetweendentitiesdbydmeansdofdcommondfieldsdi
ncludeddindadfiledcalledda(n):
A) entity.
B) relationship.
C) relation.
D) association.
dAnswer:dC
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
8) A(n)
isdoftenddevelopeddbydidentifyingdadformdordreportdthatdaduserdneedsdondadregulardbasis.
A) enterprisedview
B) reportingddocument
C) userdview
D) userdsnapshot
dAnswer:dC
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
, 9) Adgraphicaldsystemduseddtodcapturedthednaturedanddrelationshipsdamongddatadisdcalledda(n):
A) XMLddatadmodel.
B) hypertextdgraphic.
C) relationalddatabase.
D) datadmodel.
Answer:dD
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
10) Datadthatddescribedthedpropertiesdofdotherddatadare:
A) relationships.
B) logical.
C) physical.
D) metadata.
dAnswer:dD
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
11) MetatdatadtypicallyddescribesdalldofdthedfollowingdEXCEPT:
A) dataddefinitions.
B) length.
C) allowabledvalues.
D) locationdonddisk.
Answer:d D
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
4
Copyrightd©d2019dPearsondEducation,dInc.
d
,ModerndDatabasedManagement,d13ed(Hoffer)
Chapterd1d ThedDatabasedEnvironmentdanddDevelopmentdProcess
1) AccordingdtodadMcKinseydGlobaldInstitutedReport,dind2010dalone,dglobaldenterprisesdstoredd
moredthan:
A) 1dterabytedofddata.
B) 3dgigabytesdofddata.
C) atdleastd100dpetabytesdofddata.
D) moredthand7dbilliondexabytesdofddata.d
Answer:dD
LO:d 1.1:dDefinedkeydterms.dDi
fficulty:dEasydClassification:d
Concept
AACSB:d InformationdTechnology
2) Databasedmanagementd involvesdalldofdthedfollowingdEXCEPT:
A) collectingddata.
B) organizingddata.
C) designdwebdpages.
D) managingddata.
Answer:dC
LO:d 1.1:dDefinedkeydterms.dDi
fficulty:dEasydClassification:d
Concept
AACSB:d InformationdTechnology
3) Addatabasedisdandorganizeddcollectiondof relatedddata.
A) logically
B) physically
C) loosely
D) badlydA
nswer:dA
LO:d 1.1:dDefinedkeydterms.dDi
fficulty:dEasydClassification:d
Concept
AACSB:d InformationdTechnology
4) Legacydsystemsdoftendcontainddatadof qualitydanddaredgenerallydhosteddon .
A) poor;dpersonaldcomputers
B) excellent;dmainframes
C) poor;dmainframes
D) excellent;dworkgroupdcomputers
dAnswer:dC
LO:d3.1:dDefinedkeydterms.
,5) Program-dataddependencedisdcauseddby:
A) fileddescriptionsdbeingdstoreddindeachddatabasedapplication.
B) dataddescriptionsdbeingdstoreddondadserver.
C) dataddescriptionsdbeingdwrittendintodprogrammingdcode.
D) datadcohabitingdwithdprograms.d
Answer:dA
LO:d 1.2:dNamedseveraldlimitationsdofdconventionaldfiledprocessingdsystems.d
Difficulty:dModerate
Classification:d Concept
AACSB:d InformationdTechnology
6) Becausedapplicationsdaredoftenddevelopeddindependentlydindfiledprocessingdsystems:
A) theddatadisdalwaysdnon-redundant.
B) unplanneddduplicateddatadfilesdaredthedruledratherdthandthedexception.
C) datadcandalwaysdbedshareddwithdothers.
D) theredisdadlargedvolumedofdfiledI/O.d
Answer:dB
LO:d 1.2:dNamedseveraldlimitationsdofdconventionaldfiledprocessingdsystems.d
Difficulty:dModerate
Classification:d Concept
AACSB:d InformationdTechnology
7) Relationalddatabasesdestablishdthedrelationshipsdbetweendentitiesdbydmeansdofdcommondfieldsdi
ncludeddindadfiledcalledda(n):
A) entity.
B) relationship.
C) relation.
D) association.
dAnswer:dC
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
8) A(n)
isdoftenddevelopeddbydidentifyingdadformdordreportdthatdaduserdneedsdondadregulardbasis.
A) enterprisedview
B) reportingddocument
C) userdview
D) userdsnapshot
dAnswer:dC
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
, 9) Adgraphicaldsystemduseddtodcapturedthednaturedanddrelationshipsdamongddatadisdcalledda(n):
A) XMLddatadmodel.
B) hypertextdgraphic.
C) relationalddatabase.
D) datadmodel.
Answer:dD
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
10) Datadthatddescribedthedpropertiesdofdotherddatadare:
A) relationships.
B) logical.
C) physical.
D) metadata.
dAnswer:dD
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
11) MetatdatadtypicallyddescribesdalldofdthedfollowingdEXCEPT:
A) dataddefinitions.
B) length.
C) allowabledvalues.
D) locationdonddisk.
Answer:d D
LO:d 1.3:dExplaindatdleastd10dadvantagesdofdtheddatabasedapproach,dcompareddtodtraditionaldfiledproc
essing.
Difficulty:dModeratedClassific
ation:dConcept
AACSB:d InformationdTechnology
4
Copyrightd©d2019dPearsondEducation,dInc.
