Test bank f0r modern database management 13th edition by Hoffer and Ramesh all chapters 1-14 covered

Test Bank Modern Database Mana
f f f ff




gement 13th Edition Hoffer- latest-
f f f f




2023

ModernfDatabasefManagement,f13ef(Hoffer)
Chapterf1f ThefDatabasefEnvironmentfandfDevelopmentfProcess

1) AccordingftofafMcKinseyfGlobalfInstitutefReport,finf2010falone,fglobalfenterprisesfstoredfmo
refthan:
A) 1fterabytefoffdata.
B) 3fgigabytesfoffdata.
C) atfleastf100fpetabytesfoffdata.
D) morefthanf7fbillionfexabytesfoffdata.f
Answer:fD
LO:f 1.1:fDefinefkeyfterms.fDif
ficulty:fEasyfClassification:f C
oncept
AACSB:f InformationfTechnology

2) DatabasefmanagementfinvolvesfallfofftheffollowingfEXCEPT:
A) collectingfdata.
B) organizingfdata.
C) designfwebfpages.
D) managingfdata.f
Answer:fC
LO:f 1.1:fDefinefkeyfterms.fDif
ficulty:fEasyfClassification:f C
oncept
AACSB:f InformationfTechnology

3) Afdatabasefisfanforganizedfcollectionfof relatedfdata.
A) logically
B) physically
C) loosely
Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology
1

,D) badlyfA
nswer:f A
LO:f 1.1:fDefinefkeyfterms.fDif
ficulty:fEasyfClassification:f C
oncept
AACSB:f InformationfTechnology

4) Legacyfsystemsfoftenfcontainfdatafof qualityfandfarefgenerallyfhostedfon .
A) poor;fpersonalfcomputers
B) excellent;fmainframes
C) poor;fmainframes
D) excellent;fworkgroupfcomputersf
Answer:fC
LO:f3.1:fDefinefkeyfterms.




Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology
2

,5) Program-datafdependencefisfcausedfby:
A) filefdescriptionsfbeingfstoredfinfeachfdatabasefapplication.
B) datafdescriptionsfbeingfstoredfonfafserver.
C) datafdescriptionsfbeingfwrittenfintofprogrammingfcode.
D) datafcohabitingfwithfprograms.f
Answer:fA
LO:f 1.2:fNamefseveralflimitationsfoffconventionalffilefprocessingfsystems.fDi
fficulty:fModerate
Classification:f Concept
AACSB:f InformationfTechnology

6) Becausefapplicationsfarefoftenfdevelopedfindependentlyfinffilefprocessingfsystems:
A) thefdatafisfalwaysfnon-redundant.
B) unplannedfduplicatefdataffilesfarefthefrulefratherfthanfthefexception.
C) datafcanfalwaysfbefsharedfwithfothers.
D) therefisfaflargefvolumefofffilefI/O.fA
nswer:fB
LO:f 1.2:fNamefseveralflimitationsfoffconventionalffilefprocessingfsystems.fDi
fficulty:fModerate
Classification:f Concept
AACSB:f InformationfTechnology

7) Relationalfdatabasesfestablishfthefrelationshipsfbetweenfentitiesfbyfmeansfoffcommonffieldsfinc
ludedfinfaffilefcalledfa(n):
A) entity.
B) relationship.
C) relation.
D) association.
fAnswer:fC

LO:f 1.3:fExplainfatfleastf10fadvantagesfoffthefdatabasefapproach,fcomparedftoftraditionalffilefprocessi
ng.
Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology

8) A(n)
isfoftenfdevelopedfbyfidentifyingfafformforfreportfthatfafuserfneedsfonfafregularfbasis.
A) enterprisefview
B) reportingfdocument
C) userfview
D) userfsnapshotf
Answer:fC
LO:f 1.3:fExplainfatfleastf10fadvantagesfoffthefdatabasefapproach,fcomparedftoftraditionalffilefprocessi
ng.
Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology
3

, 9) Afgraphicalfsystemfusedftofcapturefthefnaturefandfrelationshipsfamongfdatafisfcalledfa(n):
A) XMLfdatafmodel.
B) hypertextfgraphic.
C) relationalfdatabase.
D) datafmodel.
Answer:fD
LO:f 1.3:fExplainfatfleastf10fadvantagesfoffthefdatabasefapproach,fcomparedftoftraditionalffilefprocessi
ng.
Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology

10) Datafthatfdescribefthefpropertiesfoffotherfdatafare:
A) relationships.
B) logical.
C) physical.
D) metadata.
fAnswer:fD

LO:f 1.3:fExplainfatfleastf10fadvantagesfoffthefdatabasefapproach,fcomparedftoftraditionalffilefprocessi
ng.
Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology

11) MetatdataftypicallyfdescribesfallfofftheffollowingfEXCEPT:
A) datafdefinitions.
B) length.
C) allowablefvalues.
D) locationfonfdisk.
Answer:f D
LO:f 1.3:fExplainfatfleastf10fadvantagesfoffthefdatabasefapproach,fcomparedftoftraditionalffilefprocessi
ng.
Difficulty:fModeratefClassific
ation:fConcept
AACSB:f InformationfTechnology




4
Copyrightf©f2019fPearsonfEducation,fInc.