Test Bank for Modern Database Management 13th Edition – Hoffer, Venkataraman, Topi – PDF Download

TESTBANK u




MODERN DATABASE MANAGEMENT, 13TH EDITION
u u u u




Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
u u u u u

,ModernuDatabaseuManagement,u13eu(Hoffer)
Chapteru1u u TheuDatabaseuEnvironmentuanduDevelopmentuProcess

1) AccordingutouauMcKinseyuGlobaluInstituteuReport,uinu2010ualone,uglobaluenterprisesustoredu
moreuthan:
A) 1uterabyteuofudata.
B) 3ugigabytesuofudata.
C) atuleastu100upetabytesuofudata.
D) moreuthanu7ubillionuexabytesuofudata.u
Answer:u D
LO:u 1.1:uDefineukeyuterms.uDif
ficulty:u EasyuClassification:u C
oncept
AACSB:u InformationuTechnology

2) Databaseumanagementu involvesualluofutheufollowinguEXCEPT:
A) collectingudata.
B) organizingudata.
C) designuwebupages.
D) managingudata.
uAnswer:u C

LO:u 1.1:uDefineukeyuterms.uDif
ficulty:u EasyuClassification:u C
oncept
AACSB:u InformationuTechnology

3) Audatabaseuisuanuorganizeducollectionuofu relatedudata.
A) logically
B) physically
C) loosely
D) badlyuA
nswer:u A
LO:u 1.1:uDefineukeyuterms.uDif
ficulty:u EasyuClassification:u C
oncept
AACSB:u InformationuTechnology

4) Legacyusystemsuoftenucontainudatauofu qualityuanduareugenerallyuhosteduonu .
A) poor;upersonalucomputers
B) excellent;umainframes
C) poor;umainframes
D) excellent;uworkgroupucomputers
uAnswer:u C

LO:u 3.1:uDefineukeyuterms.uDif
ficulty:u ModerateuClassificati
on:u Concept
AACSB:u InformationuTechnology
1
Copyrightu©u2019uPearsonuEducation,uInc.

,5) Program-dataudependenceuisucauseduby:
A) fileudescriptionsubeingustoreduinueachudatabaseuapplication.
B) dataudescriptionsubeingustoreduonuauserver.
C) dataudescriptionsubeinguwrittenuintouprogrammingucode.
D) dataucohabitinguwithuprograms.u
Answer:u A
LO:u 1.2:uNameuseveralulimitationsuofuconventionalufileuprocessingusystems.uD
ifficulty:u Moderate
Classification:u Concept
AACSB:u InformationuTechnology

6) Becauseuapplicationsuareuoftenudevelopeduindependentlyuinufileuprocessingusystems:
A) theudatauisualwaysunon-redundant.
B) unplanneduduplicateudataufilesuareutheuruleuratheruthanutheuexception.
C) dataucanualwaysubeushareduwithuothers.
D) thereuisuaulargeuvolumeuofufileuI/O.u
Answer:u B
LO:u 1.2:uNameuseveralulimitationsuofuconventionalufileuprocessingusystems.uD
ifficulty:u Moderate
Classification:u Concept
AACSB:u InformationuTechnology

7) Relationaludatabasesuestablishutheurelationshipsubetweenuentitiesubyumeansuofucommonufieldsui
ncludeduinuaufileucalledua(n):
A) entity.
B) relationship.
C) relation.
D) association.
uAnswer:u C

LO:u 1.3:uExplainuatuleastu10uadvantagesuofutheudatabaseuapproach,ucomparedutoutraditionalufileuproce
ssing.
Difficulty:u ModerateuClassific
ation:u Concept
AACSB:u InformationuTechnology

8) A(n)u
isuoftenudevelopedubyuidentifyinguauformuorureportuthatuauuseruneedsuonuauregularubasis.
A) enterpriseuview
B) reportingudocument
C) useruview
D) userusnapshot
uAnswer:u C

LO:u 1.3:uExplainuatuleastu10uadvantagesuofutheudatabaseuapproach,ucomparedutoutraditionalufileuproce
ssing.
Difficulty:u ModerateuClassific
ation:u Concept
AACSB:u InformationuTechnology
2
Copyrightu©u2019uPearsonuEducation,uInc.

, 9) Augraphicalusystemuusedutoucaptureutheunatureuandurelationshipsuamongudatauisucalledua(n):
A) XMLudataumodel.
B) hypertextugraphic.
C) relationaludatabase.
D) dataumodel.
uAnswer:u D

LO:u 1.3:uExplainuatuleastu10uadvantagesuofutheudatabaseuapproach,ucomparedutoutraditionalufileuproce
ssing.
Difficulty:u ModerateuClassific
ation:u Concept
AACSB:u InformationuTechnology

10) Datauthatudescribeutheupropertiesuofuotherudatauare:
A) relationships.
B) logical.
C) physical.
D) metadata.
uAnswer:u D

LO:u 1.3:uExplainuatuleastu10uadvantagesuofutheudatabaseuapproach,ucomparedutoutraditionalufileuproce
ssing.
Difficulty:u ModerateuClassific
ation:u Concept
AACSB:u InformationuTechnology

11) MetatdatautypicallyudescribesualluofutheufollowinguEXCEPT:
A) dataudefinitions.
B) length.
C) allowableuvalues.
D) locationuonudisk.
Answer:u D
LO:u 1.3:uExplainuatuleastu10uadvantagesuofutheudatabaseuapproach,ucomparedutoutraditionalufileuproce
ssing.
Difficulty:u ModerateuClassific
ation:u Concept
AACSB:u InformationuTechnology




3
Copyrightu©u2019uPearsonuEducation,uInc.