test bank for modern database management 13th edition heikki topi jeffrey a hoffer ramesh venkataraman

TESTBANK B




MODERN DATABASE MANAGEMENT, 13TH EDITION
B B B B




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
B B B B B

,ModernBDatabaseBManagement,B13eB(Hoffer)
ChapterB1B B TheBDatabaseBEnvironmentBandBDevelopmentBProcess

1) AccordingBtoBaBMcKinseyBGlobalBInstituteBReport,BinB2010Balone,BglobalBenterprisesBstore
dBmoreBthan:
A) 1BterabyteBofBdata.
B) 3BgigabytesBofBdata.
C) atBleastB100BpetabytesBofBdata.
D) moreBthanB7BbillionBexabytesBofBdata.
BAnswer:B D

LO:B 1.1:BDefineBkeyBterms.BDi
fficulty:B EasyBClassification:B
Concept
AACSB:B InformationBTechnology

2) DatabaseBmanagementB involvesBallBofBtheBfollowingBEXCEPT:
A) collectingBdata.
B) organizingBdata.
C) designBwebBpages.
D) managingBdata.
BAnswer:B C

LO:B 1.1:BDefineBkeyBterms.BDi
fficulty:B EasyBClassification:B
Concept
AACSB:B InformationBTechnology

3) ABdatabaseBisBanBorganizedBcollectionBofB relatedBdata.
A) logically
B) physically
C) loosely
D) badlyBA
nswer:B A
LO:B 1.1:BDefineBkeyBterms.BDi
fficulty:B EasyBClassification:B
Concept
AACSB:B InformationBTechnology

4) LegacyBsystemsBoftenBcontainBdataBofB qualityBandBareBgenerallyBhostedBonB .
A) poor;BpersonalBcomputers
B) excellent;Bmainframes
C) poor;Bmainframes
D) excellent;BworkgroupBcomputers
BAnswer:B C

LO:B 3.1:BDefineBkeyBterms.BDi
fficulty:B ModerateBClassificat
ion:B Concept
AACSB:B InformationBTechnology
1
Copyright © 2019 Pearson Education, Inc.

,5) Program-dataBdependenceBisBcausedBby:
A) fileBdescriptionsBbeingBstoredBinBeachBdatabaseBapplication.
B) dataBdescriptionsBbeingBstoredBonBaBserver.
C) dataBdescriptionsBbeingBwrittenBintoBprogrammingBcode.
D) dataBcohabitingBwithBprograms.
BAnswer:B A

LO:B 1.2:BNameBseveralBlimitationsBofBconventionalBfileBprocessingBsystems.B
Difficulty:B Moderate
Classification:B Concept
AACSB:B InformationBTechnology

6) BecauseBapplicationsBareBoftenBdevelopedBindependentlyBinBfileBprocessingBsystems:
A) theBdataBisBalwaysBnon-redundant.
B) unplannedBduplicateBdataBfilesBareBtheBruleBratherBthanBtheBexception.
C) dataBcanBalwaysBbeBsharedBwithBothers.
D) thereBisBaBlargeBvolumeBofBfileBI/O
.BAnswer:B B
LO:B 1.2:BNameBseveralBlimitationsBofBconventionalBfileBprocessingBsystems.B
Difficulty:B Moderate
Classification:B Concept
AACSB:B InformationBTechnology

7) RelationalBdatabasesBestablishBtheBrelationshipsBbetweenBentitiesBbyBmeansBofBcommonBfield
sBincludedBinBaBfileBcalledBa(n):
A) entity.
B) relationship.
C) relation.
D) association.
BAnswer:B C

LO:B 1.3:BExplainBatBleastB10BadvantagesBofBtheBdatabaseBapproach,BcomparedBtoBtraditionalBfileBpr
ocessing.
Difficulty:B ModerateBClassifi
cation:B Concept
AACSB:B InformationBTechnology

8) A(n)B
isBoftenBdevelopedBbyBidentifyingBaBformBorBreportBthatBaBuserBneedsBonBaBregularBbasis.
A) enterpriseBview
B) reportingBdocument
C) userBview
D) userBsnapshot
BAnswer:B C

LO:B 1.3:BExplainBatBleastB10BadvantagesBofBtheBdatabaseBapproach,BcomparedBtoBtraditionalBfileBpr
ocessing.
Difficulty:B ModerateBClassifi
cation:B Concept
AACSB:B InformationBTechnology
2
Copyright © 2019 Pearson Education, Inc.

, 9) ABgraphicalBsystemBusedBtoBcaptureBtheBnatureBandBrelationshipsBamongBdataBisBcalledBa(n):
A) XMLBdataBmodel.
B) hypertextBgraphic.
C) relationalBdatabase.
D) dataBmodel.
BAnswer:B D

LO:B 1.3:BExplainBatBleastB10BadvantagesBofBtheBdatabaseBapproach,BcomparedBtoBtraditionalBfileBpr
ocessing.
Difficulty:B ModerateBClassifi
cation:B Concept
AACSB:B InformationBTechnology

10) DataBthatBdescribeBtheBpropertiesBofBotherBdataBare:
A) relationships.
B) logical.
C) physical.
D) metadata.
BAnswer:B D

LO:B 1.3:BExplainBatBleastB10BadvantagesBofBtheBdatabaseBapproach,BcomparedBtoBtraditionalBfileBpr
ocessing.
Difficulty:B ModerateBClassifi
cation:B Concept
AACSB:B InformationBTechnology

11) MetatdataBtypicallyBdescribesBallBofBtheBfollowingBEXCEPT:
A) dataBdefinitions.
B) length.
C) allowableBvalues.
D) locationBonBdisk.
Answer:B D
LO:B 1.3:BExplainBatBleastB10BadvantagesBofBtheBdatabaseBapproach,BcomparedBtoBtraditionalBfileBpr
ocessing.
Difficulty:B ModerateBClassifi
cation:B Concept
AACSB:B InformationBTechnology




3
Copyright © 2019 Pearson Education, Inc.