Modern Database Management Test Bank | 2025 SQL, NoSQL & Big Data Exam Prep

TESTBANK
l

,ModernlDatabaselManagement,l13el(Hoffer)
Chapterl1l ThelDatabaselEnvironmentlandlDevelopmentlProcess

1) AccordingltolalMcKinseylGloballInstitutelReport,linl2010lalone,lgloballenterpriseslstoredlm
orelthan:
A) 1lterabytelofldata.
B) 3lgigabyteslofldata.
C) atlleastl100lpetabyteslofldata.
D) morelthanl7lbillionlexabyteslofldata.l
Answer:lD
LO:l 1.1:lDefinelkeylterms.lDif
ficulty:lEasylClassification:l C
oncept
AACSB:l InformationlTechnology

2) DatabaselmanagementlinvolveslallloflthelfollowinglEXCEPT:
A) collectingldata.
B) organizingldata.
C) designlweblpages.
D) managingldata.
Answer:lC
LO:l 1.1:lDefinelkeylterms.lDif
ficulty:lEasylClassification:l C
oncept
AACSB:l InformationlTechnology

3) Aldatabaselislanlorganizedlcollectionlof relatedldata.
A) logically
B) physically
C) loosely
D) badlylA
nswer:lA
LO:l 1.1:lDefinelkeylterms.lDif
ficulty:lEasylClassification:l C
oncept
AACSB:l InformationlTechnology

4) Legacylsystemsloftenlcontainldatalof qualitylandlarelgenerallylhostedlon .
A) poor;lpersonallcomputers
B) excellent;lmainframes
C) poor;lmainframes
D) excellent;lworkgrouplcomputersl
Answer:lC
LO:l3.1:lDefinelkeylterms.

,5) Program-dataldependencelislcausedlby:
A) fileldescriptionslbeinglstoredlinleachldatabaselapplication.
B) dataldescriptionslbeinglstoredlonlalserver.
C) dataldescriptionslbeinglwrittenlintolprogramminglcode.
D) datalcohabitinglwithlprograms.l
Answer:lA
LO:l 1.2:lNamelseveralllimitationsloflconventionallfilelprocessinglsystems.lDi
fficulty:lModerate
Classification:l Concept
AACSB:l InformationlTechnology

6) Becauselapplicationslareloftenldevelopedlindependentlylinlfilelprocessinglsystems:
A) theldatalislalwayslnon-redundant.
B) unplannedlduplicateldatalfileslarelthelrulelratherlthanlthelexception.
C) datalcanlalwayslbelsharedlwithlothers.
D) therelislallargelvolumeloflfilelI/O.l
Answer:lB
LO:l 1.2:lNamelseveralllimitationsloflconventionallfilelprocessinglsystems.lDi
fficulty:lModerate
Classification:l Concept
AACSB:l InformationlTechnology

7) Relationalldatabaseslestablishlthelrelationshipslbetweenlentitieslbylmeansloflcommonlfieldslin
cludedlinlalfilelcalledla(n):
A) entity.
B) relationship.
C) relation.
D) association.
lAnswer:lC

LO:l 1.3:lExplainlatlleastl10ladvantageslofltheldatabaselapproach,lcomparedltoltraditionallfilelproces
sing.
Difficulty:lModeratelClassific
ation:lConcept
AACSB:l InformationlTechnology

8) A(n)
isloftenldevelopedlbylidentifyinglalformlorlreportlthatlaluserlneedslonlalregularlbasis.
A) enterpriselview
B) reportingldocument
C) userlview
D) userlsnapshot
lAnswer:lC

LO:l 1.3:lExplainlatlleastl10ladvantageslofltheldatabaselapproach,lcomparedltoltraditionallfilelproces
sing.

, 9) Algraphicallsystemlusedltolcapturelthelnaturelandlrelationshipslamongldatalislcalledla(n):
A) XMLldatalmodel.
B) hypertextlgraphic.
C) relationalldatabase.
D) datalmodel.
Answer:lD
LO:l 1.3:lExplainlatlleastl10ladvantageslofltheldatabaselapproach,lcomparedltoltraditionallfilelproces
sing.
Difficulty:lModeratelClassific
ation:lConcept
AACSB:l InformationlTechnology

10) Datalthatldescribelthelpropertiesloflotherldatalare:
A) relationships.
B) logical.
C) physical.
D) metadata.
lAnswer:lD
LO:l 1.3:lExplainlatlleastl10ladvantageslofltheldatabaselapproach,lcomparedltoltraditionallfilelproces
sing.
Difficulty:lModeratelClassific
ation:lConcept
AACSB:l InformationlTechnology

11) MetatdataltypicallyldescribeslallloflthelfollowinglEXCEPT:
A) dataldefinitions.
B) length.
C) allowablelvalues.
D) locationlonldisk.
Answer:l D
LO:l 1.3:lExplainlatlleastl10ladvantageslofltheldatabaselapproach,lcomparedltoltraditionallfilelproces
sing.
Difficulty:lModeratelClassific
ation:lConcept
AACSB:l InformationlTechnology




4
Copyrightl©l2019lPearsonlEducation,lInc.