TEST BANK
x
,Modern xDatabase xManagement, x13e x(Hoffer)
Chapter x1 x The xDatabase xEnvironment xand xDevelopment xProcess
1) According xto xa xMcKinsey xGlobal xInstitute xReport, xin x2010 xalone, xglobal
xenterprises xstored xmore xthan:
A) 1 xterabyte xof xdata.
B) 3 xgigabytes xof xdata.
C) at xleast x100 xpetabytes xof xdata.
D) more xthan x7 xbillion xexabytes xof
xdata. xAnswer: xD
LO: x 1.1: xDefine xkey
xterms. xDifficulty: xEasy
xClassification: x Concept
AACSB: x Information xTechnology
2) Database xmanagement x involves xall xof xthe xfollowing xEXCEPT:
A) collecting xdata.
B) organizing xdata.
C) design xweb xpages.
D) managing
xdata.
Answer: xC
LO: x 1.1: xDefine xkey
xterms. xDifficulty: xEasy
xClassification: x Concept
AACSB: x Information xTechnology
3) A xdatabase xis xan xorganized xcollection xof related xdata.
A) logically
B) physically
C) loosely
D) badly
xAnswer:
xA
LO: x 1.1: xDefine xkey
xterms. xDifficulty: xEasy
xClassification: x Concept
AACSB: x Information xTechnology
4) Legacy xsystems xoften xcontain xdata xof quality xand xare xgenerally xhosted xon .
A) poor; xpersonal xcomputers
B) excellent; xmainframes
C) poor; xmainframes
D) excellent; xworkgroup
xcomputers xAnswer: xC
LO: x3.1: xDefine xkey xterms.
,5) Program-data xdependence xis xcaused xby:
A) file xdescriptions xbeing xstored xin xeach xdatabase xapplication.
B) data xdescriptions xbeing xstored xon xa xserver.
C) data xdescriptions xbeing xwritten xinto xprogramming xcode.
D) data xcohabiting xwith
xprograms. xAnswer: xA
LO: x 1.2: xName xseveral xlimitations xof xconventional xfile xprocessing
xsystems. xDifficulty: xModerate
Classification: x Concept
AACSB: x Information xTechnology
6) Because xapplications xare xoften xdeveloped xindependently xin xfile xprocessing xsystems:
A) the xdata xis xalways xnon-redundant.
B) unplanned xduplicate xdata xfiles xare xthe xrule xrather xthan xthe xexception.
C) data xcan xalways xbe xshared xwith xothers.
D) there xis xa xlarge xvolume xof xfile
xI/O. xAnswer: xB
LO: x 1.2: xName xseveral xlimitations xof xconventional xfile xprocessing
xsystems. xDifficulty: xModerate
Classification: x Concept
AACSB: x Information xTechnology
7) Relational xdatabases xestablish xthe xrelationships xbetween xentities xby xmeans xof
xcommon xfields xincluded xin xa xfile xcalled xa(n):
A) entity.
B) relationship.
C) relation.
D) associatio
n. xAnswer:
xC
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
8) A(n) is xoften xdeveloped xby xidentifying xa xform xor xreport xthat xa xuser
xneeds xon xa xregular xbasis.
A) enterprise xview
B) reporting xdocument
C) user xview
D) user
xsnapshot
xAnswer: xC
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
, 9) A xgraphical xsystem xused xto xcapture xthe xnature xand xrelationships xamong xdata xis
xcalled xa(n):
A) XML xdata xmodel.
B) hypertext xgraphic.
C) relational xdatabase.
D) data
xmodel.
Answer: xD
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
10) Data xthat xdescribe xthe xproperties xof xother xdata xare:
A) relationships.
B) logical.
C) physical.
D) metadat
a. xAnswer:
xD
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
11) Metatdata xtypically xdescribes xall xof xthe xfollowing xEXCEPT:
A) data xdefinitions.
B) length.
C) allowable xvalues.
D) location xon
xdisk.
Answer: x D
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
4
Copyright x© x2019 xPearson xEducation,
xInc.
x
,Modern xDatabase xManagement, x13e x(Hoffer)
Chapter x1 x The xDatabase xEnvironment xand xDevelopment xProcess
1) According xto xa xMcKinsey xGlobal xInstitute xReport, xin x2010 xalone, xglobal
xenterprises xstored xmore xthan:
A) 1 xterabyte xof xdata.
B) 3 xgigabytes xof xdata.
C) at xleast x100 xpetabytes xof xdata.
D) more xthan x7 xbillion xexabytes xof
xdata. xAnswer: xD
LO: x 1.1: xDefine xkey
xterms. xDifficulty: xEasy
xClassification: x Concept
AACSB: x Information xTechnology
2) Database xmanagement x involves xall xof xthe xfollowing xEXCEPT:
A) collecting xdata.
B) organizing xdata.
C) design xweb xpages.
D) managing
xdata.
Answer: xC
LO: x 1.1: xDefine xkey
xterms. xDifficulty: xEasy
xClassification: x Concept
AACSB: x Information xTechnology
3) A xdatabase xis xan xorganized xcollection xof related xdata.
A) logically
B) physically
C) loosely
D) badly
xAnswer:
xA
LO: x 1.1: xDefine xkey
xterms. xDifficulty: xEasy
xClassification: x Concept
AACSB: x Information xTechnology
4) Legacy xsystems xoften xcontain xdata xof quality xand xare xgenerally xhosted xon .
A) poor; xpersonal xcomputers
B) excellent; xmainframes
C) poor; xmainframes
D) excellent; xworkgroup
xcomputers xAnswer: xC
LO: x3.1: xDefine xkey xterms.
,5) Program-data xdependence xis xcaused xby:
A) file xdescriptions xbeing xstored xin xeach xdatabase xapplication.
B) data xdescriptions xbeing xstored xon xa xserver.
C) data xdescriptions xbeing xwritten xinto xprogramming xcode.
D) data xcohabiting xwith
xprograms. xAnswer: xA
LO: x 1.2: xName xseveral xlimitations xof xconventional xfile xprocessing
xsystems. xDifficulty: xModerate
Classification: x Concept
AACSB: x Information xTechnology
6) Because xapplications xare xoften xdeveloped xindependently xin xfile xprocessing xsystems:
A) the xdata xis xalways xnon-redundant.
B) unplanned xduplicate xdata xfiles xare xthe xrule xrather xthan xthe xexception.
C) data xcan xalways xbe xshared xwith xothers.
D) there xis xa xlarge xvolume xof xfile
xI/O. xAnswer: xB
LO: x 1.2: xName xseveral xlimitations xof xconventional xfile xprocessing
xsystems. xDifficulty: xModerate
Classification: x Concept
AACSB: x Information xTechnology
7) Relational xdatabases xestablish xthe xrelationships xbetween xentities xby xmeans xof
xcommon xfields xincluded xin xa xfile xcalled xa(n):
A) entity.
B) relationship.
C) relation.
D) associatio
n. xAnswer:
xC
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
8) A(n) is xoften xdeveloped xby xidentifying xa xform xor xreport xthat xa xuser
xneeds xon xa xregular xbasis.
A) enterprise xview
B) reporting xdocument
C) user xview
D) user
xsnapshot
xAnswer: xC
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
, 9) A xgraphical xsystem xused xto xcapture xthe xnature xand xrelationships xamong xdata xis
xcalled xa(n):
A) XML xdata xmodel.
B) hypertext xgraphic.
C) relational xdatabase.
D) data
xmodel.
Answer: xD
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
10) Data xthat xdescribe xthe xproperties xof xother xdata xare:
A) relationships.
B) logical.
C) physical.
D) metadat
a. xAnswer:
xD
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
11) Metatdata xtypically xdescribes xall xof xthe xfollowing xEXCEPT:
A) data xdefinitions.
B) length.
C) allowable xvalues.
D) location xon
xdisk.
Answer: x D
LO: x 1.3: xExplain xat xleast x10 xadvantages xof xthe xdatabase xapproach, xcompared xto
xtraditional xfile xprocessing.
Difficulty: xModerate
xClassification: x Concept
AACSB: x Information xTechnology
4
Copyright x© x2019 xPearson xEducation,
xInc.
