Modern Database Management, 13e (Hoffer)
nn nn nn nn
Chapter 1 The Database Environment and
nn nn nn nn nn nn
Development Process
nn nn
1) According nnto nna nnMcKinseynnGlobalnnInstitutennReport, nninnn2010 nnalone, nnglobalnnenterprises
nnstored nnmorennthan:
A) 1 nnterabyte nnofdata.
B) 3 nngigabytes nnofdata.
C) atnnleast nn100nnpetabytesnnofnndata.
D) more thannn7nnbillionnnexabytesnnof
a
nndata. nnAnswer: nnD
LO: nn1.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnEasy
nnClassification: nnCo nnncept
AACSB: nnInformationnnTechnology
2) Database nnmanagement nninvolvesnnallnnofnnthe nnfollowing nnEXCEPT:
A) collecting nndata.
B) organizing nndata.
C) designnnwebnnpages.
D) managing nndata
. nnAnswer: nnC
LO: nn1.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnEasy
nnClassification: nnCo nnncept
AACSB: nnInformationnnTechnology
3) Anndatabase nnisnnannnorganized nncollectionnnof related nndata.
A) logically
B) physically
C) loosely
D) badly
nnA nnnswer:
nnA
LO: nn1.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnEasy
nnClassification: nnCo nnncept
AACSB: nnInformationnnTechnology
4) Legacysystems nnoften nncontain nndata nnof qualitynnand nnare nngenerallynnhostednnon .
A) poor;nnpersonalnncomputers
B) excellent;nnmainframes
C) poor;nnmainframes
D) excellent;nnworkgroup
nncomputers nnAnswer: nnC
1
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
,LO: nn3.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnModerate
nnClassificatio nnn: nnConcept
AACSB: nnInformationnnTechnology
2
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
,5) Program-datanndependence nnisnncausednnby:
A) file descriptions nnbeing nnstored nninnneach nndatabase application.
a a
B) datanndescriptions nnbeing nnstorednnon nna nnserver.
C) data nndescriptions nnbeing nnwritten nninto programming nncode.
a
D) data nncohabiting
nnwithprograms. nnAnswer: nnA
LO: n n 1.2:nnNamennseveralnnlimitationsnnofnnconventionalnnfilennprocessingnnsystems. nn Difficulty:
nnModerate
Classification: n n Concept
AACSB: nnInformationnnTechnology
6) Becausennapplicationsnnarennoftennndeveloped nnindependentlynninnnfilennprocessingnnsystems:
A) the nndatannisnnalways nnnon-redundant.
B) unplanned nnduplicate data nnfilesnnare nnthe nnrulennrather nnthannnthe exception.
a a
C) datanncanalways nnbe nnshared nnwithothers.
D) there nnis a nnlargennvolumennofnnfile
a
nnI/O. nnAnswer: nnB
LO: n n 1.2:nnNamennseveralnnlimitationsnnofnnconventionalnnfilennprocessingnnsystems. n n Difficulty:
nnModerate
Classification: n n Concept
AACSB: nnInformationnnTechnology
7) Relationalnndatabasesnnestablishnnthennrelationshipsnnbetweennnentitiesnnbynnmeansnnofnncommonnnfields
n n i nnncluded nnin nna nnfile nncalled nna(n):
A) entity.
B) relationship.
C) relation.
D) association.
nnAnswer: nnC
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate
nnClassificatio nnn: nnConcept
AACSB: nnInformationnnTechnology
8) A(n)
isnnoftennndeveloped nnby nnidentifying nnannformor nnreport nnthat nnannuser nnneedsnnon nna n n regular nnbasis.
A) enterprise nnview
B) reportingnndocument
C) user nnview
D) usernnsnapsho
nnt nnAnswer: nnC
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate a
nnClassificatio nnn: nnConcept
AACSB: nnInformationnnTechnology
3
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
, 9) Agraphical nnsystemnnused nnto nncapturethe nnnature nnand nnrelationships nnamong nndata nnisnncalled nna(n):
A) XML nndata nnmodel.
B) hypertext nngraphic.
C) relationalnndatabase.
D) datannmodel.
nnAnswer: nnD
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile n n pr
nnocessing.
Difficulty: nnModerate a
nnCla nnssification:
nnConcept
AACSB: nnInformationnnTechnology
10) Datathat nndescribe nnthe nnproperties nnofother nn dataare:
A) relationships.
B) logical.
C) physical.
D) metadata
. nnAnswer: nnD
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate nnCla
nnssification: nnConcept
AACSB: nnInformationnnTechnology
11) MetatdatatypicallynndescribesnnallnnofnnthennfollowingnnEXCEPT:
A) data nndefinitions.
B) length.
C) allowable nnvalues.
D) locationonnndisk.
nnAnswer: nnD
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate nnCla
nnssification: nnConcept
AACSB: nnInformationnnTechnology
4
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
nn nn nn nn
Chapter 1 The Database Environment and
nn nn nn nn nn nn
Development Process
nn nn
1) According nnto nna nnMcKinseynnGlobalnnInstitutennReport, nninnn2010 nnalone, nnglobalnnenterprises
nnstored nnmorennthan:
A) 1 nnterabyte nnofdata.
B) 3 nngigabytes nnofdata.
C) atnnleast nn100nnpetabytesnnofnndata.
D) more thannn7nnbillionnnexabytesnnof
a
nndata. nnAnswer: nnD
LO: nn1.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnEasy
nnClassification: nnCo nnncept
AACSB: nnInformationnnTechnology
2) Database nnmanagement nninvolvesnnallnnofnnthe nnfollowing nnEXCEPT:
A) collecting nndata.
B) organizing nndata.
C) designnnwebnnpages.
D) managing nndata
. nnAnswer: nnC
LO: nn1.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnEasy
nnClassification: nnCo nnncept
AACSB: nnInformationnnTechnology
3) Anndatabase nnisnnannnorganized nncollectionnnof related nndata.
A) logically
B) physically
C) loosely
D) badly
nnA nnnswer:
nnA
LO: nn1.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnEasy
nnClassification: nnCo nnncept
AACSB: nnInformationnnTechnology
4) Legacysystems nnoften nncontain nndata nnof qualitynnand nnare nngenerallynnhostednnon .
A) poor;nnpersonalnncomputers
B) excellent;nnmainframes
C) poor;nnmainframes
D) excellent;nnworkgroup
nncomputers nnAnswer: nnC
1
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
,LO: nn3.1: nnDefine nnkey nnterms.
nnDiff nniculty: nnModerate
nnClassificatio nnn: nnConcept
AACSB: nnInformationnnTechnology
2
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
,5) Program-datanndependence nnisnncausednnby:
A) file descriptions nnbeing nnstored nninnneach nndatabase application.
a a
B) datanndescriptions nnbeing nnstorednnon nna nnserver.
C) data nndescriptions nnbeing nnwritten nninto programming nncode.
a
D) data nncohabiting
nnwithprograms. nnAnswer: nnA
LO: n n 1.2:nnNamennseveralnnlimitationsnnofnnconventionalnnfilennprocessingnnsystems. nn Difficulty:
nnModerate
Classification: n n Concept
AACSB: nnInformationnnTechnology
6) Becausennapplicationsnnarennoftennndeveloped nnindependentlynninnnfilennprocessingnnsystems:
A) the nndatannisnnalways nnnon-redundant.
B) unplanned nnduplicate data nnfilesnnare nnthe nnrulennrather nnthannnthe exception.
a a
C) datanncanalways nnbe nnshared nnwithothers.
D) there nnis a nnlargennvolumennofnnfile
a
nnI/O. nnAnswer: nnB
LO: n n 1.2:nnNamennseveralnnlimitationsnnofnnconventionalnnfilennprocessingnnsystems. n n Difficulty:
nnModerate
Classification: n n Concept
AACSB: nnInformationnnTechnology
7) Relationalnndatabasesnnestablishnnthennrelationshipsnnbetweennnentitiesnnbynnmeansnnofnncommonnnfields
n n i nnncluded nnin nna nnfile nncalled nna(n):
A) entity.
B) relationship.
C) relation.
D) association.
nnAnswer: nnC
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate
nnClassificatio nnn: nnConcept
AACSB: nnInformationnnTechnology
8) A(n)
isnnoftennndeveloped nnby nnidentifying nnannformor nnreport nnthat nnannuser nnneedsnnon nna n n regular nnbasis.
A) enterprise nnview
B) reportingnndocument
C) user nnview
D) usernnsnapsho
nnt nnAnswer: nnC
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate a
nnClassificatio nnn: nnConcept
AACSB: nnInformationnnTechnology
3
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
, 9) Agraphical nnsystemnnused nnto nncapturethe nnnature nnand nnrelationships nnamong nndata nnisnncalled nna(n):
A) XML nndata nnmodel.
B) hypertext nngraphic.
C) relationalnndatabase.
D) datannmodel.
nnAnswer: nnD
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile n n pr
nnocessing.
Difficulty: nnModerate a
nnCla nnssification:
nnConcept
AACSB: nnInformationnnTechnology
10) Datathat nndescribe nnthe nnproperties nnofother nn dataare:
A) relationships.
B) logical.
C) physical.
D) metadata
. nnAnswer: nnD
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate nnCla
nnssification: nnConcept
AACSB: nnInformationnnTechnology
11) MetatdatatypicallynndescribesnnallnnofnnthennfollowingnnEXCEPT:
A) data nndefinitions.
B) length.
C) allowable nnvalues.
D) locationonnndisk.
nnAnswer: nnD
LO: n n 1.3:nnExplainnnat nnleastnn10nnadvantagesnnofnnthenndatabasennapproach,nncomparednntonntraditionalnnfile nn pr
nnocessing.
Difficulty: nnModerate nnCla
nnssification: nnConcept
AACSB: nnInformationnnTechnology
4
Copyright nn© nn2019 nnPearsonaEducation,
nnInc.
