TESTBANK
,Modern DatabaseManagement, 13e(Hoffer)
tj tj tj tj
Chapter1 TheDatabaseEnvironment andDevelopment Process jt jt tj jt tj
1) According toaMcKinseyGlobalInstituteReport, in2010alone,globalenterprisesstored mo r
ht ht ht ht ht tj tj
e than:
tj
A) 1 terabyteofdata.
tj tj
B) 3gigabytes ofdata.
tj tj
C) atleast 100petabytesofdata.
tj tj tj tj
D) morethan7billionexabytes ofdata. ht tj ht ht ht tj
Answer: D tj
LO: 1.1:Definekeyterms.Di f fi
t j tj tj tj
culty: Easy Classification:
tj tj
Concept
AACSB: InformationTechnology
2) Databasemanagement involvesallofthefollowing EXCEPT: t j tj ht
A) collecting data. ht
B) organizingdata. tj
C) design webpages. tj tj
D) managingdata.
Answer: C
tj tj
LO: 1.1:Definekeyterms.Di f fi
t j tj tj tj
culty: Easy Classification:
tj tj
Concept
AACSB: InformationTechnology
3) Adatabase is anorganized collection of tj ht tj ht tj related data.
ht
A) logically
B) physically
C) loosely
D) badlyA
nswer: A
tj tj
LO: 1.1:Definekeyterms.Di f fi
t j tj tj tj
culty: Easy Classification:
tj tj
Concept
AACSB: InformationTechnology
4) Legacysystemsoftencontaindataof tj tj qualityand aregenerallyhostedon
tj tj tj .
A) poor; personalcomputers tj tj
B) excellent; mainframes tj
C) poor;mainframes
D) excellent;workgroupcomputers ht
Answer: C
t j tj
LO: 3.1:Definekeyterms.
tj
,5) Program-datadependenceis caused by: tj ht tj
A) filedescriptionsbeing stored in eachdatabase application. ht tj ht tj
B) datadescriptionsbeingstored onaserver. tj tj 1t j tj
C) datadescriptionsbeing writteninto programming code.
ht ht tj tj tj
D) datacohabitingwith programs. ht 1 t
Answer: A
j tj
LO: 1.2:Name severallimitationsofconventionalfile processing systems. Diffic
t j ht ht tj ht ht 1tj tj
ulty: Moderate
tj tj
Classification: Concept
AACSB: InformationTechnology
6) Becauseapplicationsare oftendeveloped independentlyin fileprocessingsystems:
ht ht tj ht
A) thedataisalways non-redundant. t j
B) unplannedduplicatedata filesare the ruleratherthan the exception. tj tj ht tj
C) datacanalways beshared withothers. tj ht
D) there is alargevolumeoffileI/O. ht 1 tj tj
Answer: B tj
LO: 1.2:Nameseverallimitationsofconventionalfileprocessingsystems. Diffic
t j tj ht tj tj
ulty: Moderate tj
Classification: Concept
AACSB: InformationTechnology
7) Relationaldatabasesestablishtherelationshipsbetween entitiesbymeans ofcommonfieldsi nc
ht tj ht ht tj tj
luded in a file called a(n):
tj ht tj tj tj
A) entity.
B) relationship.
C) relation.
D) association. tj
Answer: C tj
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
8) A(n)
isoftendeveloped byidentifying a formorreport that a userneeds ona regular basis.
tj ht ht tj tj ht ht tj tj tj
A) enterprise view tj
B) reportingdocument tj
C) userview
D) usersnapshot ht
Answer: C
t j tj
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
, 9) Agraphicalsystemused to capturethenatureand relationships among data is called a(n):
ht tj tj tj tj ht tj tj tj
A) XML data model. ht ht
B) hypertextgraphic. tj
C) relationaldatabase.
D) datamodel. t
Answer: D
j tj
LO: 1.3:Explain atleast10advantages ofthedatabaseapproach,compared to traditional filepro cessing.
t j ht tj tj tj ht ht tj tj ht ht tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
10) Data that describethepropertiesof other dataare:
ht tj tj tj ht tj
A) relationships.
B) logical.
C) physical.
D) metadata. t
Answer: D
j tj
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
11) Metatdatatypicallydescribesall of thefollowingEXCEPT:ht tj ht ht tj tj
A) data definitions. tj
B) length.
C) allowable values. ht
D) locationon disk. ht 1 t
Answer: D
j
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
4
Copyright©2019PearsonEducation, Inc.tj tj tj tj tj
,Modern DatabaseManagement, 13e(Hoffer)
tj tj tj tj
Chapter1 TheDatabaseEnvironment andDevelopment Process jt jt tj jt tj
1) According toaMcKinseyGlobalInstituteReport, in2010alone,globalenterprisesstored mo r
ht ht ht ht ht tj tj
e than:
tj
A) 1 terabyteofdata.
tj tj
B) 3gigabytes ofdata.
tj tj
C) atleast 100petabytesofdata.
tj tj tj tj
D) morethan7billionexabytes ofdata. ht tj ht ht ht tj
Answer: D tj
LO: 1.1:Definekeyterms.Di f fi
t j tj tj tj
culty: Easy Classification:
tj tj
Concept
AACSB: InformationTechnology
2) Databasemanagement involvesallofthefollowing EXCEPT: t j tj ht
A) collecting data. ht
B) organizingdata. tj
C) design webpages. tj tj
D) managingdata.
Answer: C
tj tj
LO: 1.1:Definekeyterms.Di f fi
t j tj tj tj
culty: Easy Classification:
tj tj
Concept
AACSB: InformationTechnology
3) Adatabase is anorganized collection of tj ht tj ht tj related data.
ht
A) logically
B) physically
C) loosely
D) badlyA
nswer: A
tj tj
LO: 1.1:Definekeyterms.Di f fi
t j tj tj tj
culty: Easy Classification:
tj tj
Concept
AACSB: InformationTechnology
4) Legacysystemsoftencontaindataof tj tj qualityand aregenerallyhostedon
tj tj tj .
A) poor; personalcomputers tj tj
B) excellent; mainframes tj
C) poor;mainframes
D) excellent;workgroupcomputers ht
Answer: C
t j tj
LO: 3.1:Definekeyterms.
tj
,5) Program-datadependenceis caused by: tj ht tj
A) filedescriptionsbeing stored in eachdatabase application. ht tj ht tj
B) datadescriptionsbeingstored onaserver. tj tj 1t j tj
C) datadescriptionsbeing writteninto programming code.
ht ht tj tj tj
D) datacohabitingwith programs. ht 1 t
Answer: A
j tj
LO: 1.2:Name severallimitationsofconventionalfile processing systems. Diffic
t j ht ht tj ht ht 1tj tj
ulty: Moderate
tj tj
Classification: Concept
AACSB: InformationTechnology
6) Becauseapplicationsare oftendeveloped independentlyin fileprocessingsystems:
ht ht tj ht
A) thedataisalways non-redundant. t j
B) unplannedduplicatedata filesare the ruleratherthan the exception. tj tj ht tj
C) datacanalways beshared withothers. tj ht
D) there is alargevolumeoffileI/O. ht 1 tj tj
Answer: B tj
LO: 1.2:Nameseverallimitationsofconventionalfileprocessingsystems. Diffic
t j tj ht tj tj
ulty: Moderate tj
Classification: Concept
AACSB: InformationTechnology
7) Relationaldatabasesestablishtherelationshipsbetween entitiesbymeans ofcommonfieldsi nc
ht tj ht ht tj tj
luded in a file called a(n):
tj ht tj tj tj
A) entity.
B) relationship.
C) relation.
D) association. tj
Answer: C tj
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
8) A(n)
isoftendeveloped byidentifying a formorreport that a userneeds ona regular basis.
tj ht ht tj tj ht ht tj tj tj
A) enterprise view tj
B) reportingdocument tj
C) userview
D) usersnapshot ht
Answer: C
t j tj
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
, 9) Agraphicalsystemused to capturethenatureand relationships among data is called a(n):
ht tj tj tj tj ht tj tj tj
A) XML data model. ht ht
B) hypertextgraphic. tj
C) relationaldatabase.
D) datamodel. t
Answer: D
j tj
LO: 1.3:Explain atleast10advantages ofthedatabaseapproach,compared to traditional filepro cessing.
t j ht tj tj tj ht ht tj tj ht ht tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
10) Data that describethepropertiesof other dataare:
ht tj tj tj ht tj
A) relationships.
B) logical.
C) physical.
D) metadata. t
Answer: D
j tj
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
11) Metatdatatypicallydescribesall of thefollowingEXCEPT:ht tj ht ht tj tj
A) data definitions. tj
B) length.
C) allowable values. ht
D) locationon disk. ht 1 t
Answer: D
j
LO: 1.3:Explainat least10advantagesofthedatabaseapproach, comparedtotraditionalfilepro cessing.
t j t j ht tj tj tj tj tj
Difficulty:ModerateClassific ati tj
on: Concept
tj
AACSB: InformationTechnology
4
Copyright©2019PearsonEducation, Inc.tj tj tj tj tj
