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

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




1
CopyrightL©L2019LPearsonLEducation,LInc
.

,TABLE OF CONTENT
L L




I.LTHELCONTEXTLOFLDATABASELMANAGEMENT

1.LTheLDatabaseLEnvironmentLandLDevelopmentLProcess

II.LDATABASELANALYSISLANDLLOGICALLDESIGN

2.LModelingLDataLinLtheLOrganization

3.LTheLEnhancedLE-RLModel

4.LLogicalLDatabaseLDesignLandLtheLRelationalLModel

III.LDATABASELIMPLEMENTATIONLANDLUSE

5.LIntroductionLtoLSQL

6.LAdvancedLSQL

7.LDatabasesLinLApplications

8.LPhysicalLDatabaseLDesignLandLDatabaseLInfrastructure

IV.LADVANCEDLDATABASELTOPICS

9.LDataLWarehousingLandLDataLIntegration

10.LBigLDataLTechnologies

11.LAnalyticsLandLItsLImplications

12.LDataLandLDatabaseLAdministrationLwithLFocusLonLDataLQuality

ONLINELCHAPTERS

13.LDistributedLDatabases

14.LObject-OrientedLDataLModeling

2
CopyrightL©L2019LPearsonLEducation,LInc
.

,ModernLDatabaseLManagement,L13eL(Hoffer)

ChapterL1LLLTheLDatabaseLEnvironmentLandLDevelopmentLProcess

1) AccordingLtoLaLMcKinseyLGlobalLInstituteLReport,LinL2010Lalone,LglobalLenterprisesLstoredL moreLtha
n:
A) 1LterabyteLofLdata.
B) 3LgigabytesLofLdata.
C) atLleastL100LpetabytesLofLdata.
D) moreLthanL7LbillionLexabytesLofLdata.L An
swer:LLD
LO:LL1.1:LDefineLkeyLterms.L Diffic
ulty:LLEasyL Classification:LLConce
pt
AACSB:LLInformationLTechnology

2) DatabaseLmanagementL involvesLallLofLtheLfollowingLEXCEPT:
A) collectingLdata.
B) organizingLdata.
C) designLwebLpages.
D) managingLdata.L
Answer:LLC
LO:LL1.1:LDefineLkeyLterms.L Diffic
ulty:LLEasyL Classification:LLConce
pt
AACSB:LLInformationLTechnology

3) ALdatabaseLisLanLorganizedLcollectionLof relatedLdata.
A) logically
B) physically
C) loosely
D) badlyL An
swer:LLA
LO:LL1.1:LDefineLkeyLterms.L Diffic
ulty:LLEasyL Classification:LLConce
pt
AACSB:LLInformationLTechnology

4) LegacyLsystemsLoftenLcontainLdataLof qualityLandLareLgenerallyLhostedLon .
A) poor;LpersonalLcomputers
B) excellent;Lmainframes
C) poor;Lmainframes
D) excellent;LworkgroupLcomputersL An
swer:LLC
LO:LL3.1:LDefineLkeyLterms.L Diffic
ulty:LLModerateL Classification:LLC
oncept
3
CopyrightL©L2019LPearsonLEducation,LInc
.

, AACSB:LLInformationLTechnology




4
CopyrightL©L2019LPearsonLEducation,LInc
.