EDITION, JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI
TOPI ,ISBN: 9780134877006, LATEST UPDATE
,Modern cDatabase cManagement, c13e c(Hoffer)
Chapter c1 c The cDatabase cEnvironment cand cDevelopment cProcess
1) According cto ca cMcKinsey cGlobal cInstitute cReport, cin c2010 calone, cglobal centerprises
cstored cmore cthan:
A) 1 cterabyte cof cdata.
B) 3 cgigabytes cof cdata.
C) at cleast c100 cpetabytes cof cdata.
D) more cthan c7 cbillion cexabytes cof
cdata. cAnswer: cD
LO: c 1.1: cDefine ckey cterms.
cDifficulty: cEasy
cClassification: c Concept
AACSB: c Information cTechnology
2) Database cmanagement c involves call cof cthe cfollowing cEXCEPT:
A) collecting cdata.
B) organizing cdata.
C) design cweb cpages.
D) managing
cdata.
Answer: cC
LO: c 1.1: cDefine ckey cterms.
cDifficulty: cEasy
cClassification: c Concept
AACSB: c Information cTechnology
3) A cdatabase cis can corganized ccollection cof related cdata.
A) logically
B) physically
C) loosely
D) badly
cAnswer:
cA
LO: c 1.1: cDefine ckey cterms.
cDifficulty: cEasy
cClassification: c Concept
AACSB: c Information cTechnology
4) Legacy csystems coften ccontain cdata cof quality cand care cgenerally chosted con .
A) poor; cpersonal ccomputers
B) excellent; cmainframes
C) poor; cmainframes
D) excellent; cworkgroup
ccomputers cAnswer: cC
LO: c3.1: cDefine ckey cterms.
,5) Program-data cdependence cis ccaused cby:
A) file cdescriptions cbeing cstored cin ceach cdatabase capplication.
B) data cdescriptions cbeing cstored con ca cserver.
C) data cdescriptions cbeing cwritten cinto cprogramming ccode.
D) data ccohabiting cwith
cprograms. cAnswer: cA
LO: c 1.2: cName cseveral climitations cof cconventional cfile cprocessing
csystems. cDifficulty: cModerate
Classification: c Concept
AACSB: c Information cTechnology
6) Because capplications care coften cdeveloped cindependently cin cfile cprocessing csystems:
A) the cdata cis calways cnon-redundant.
B) unplanned cduplicate cdata cfiles care cthe crule crather cthan cthe cexception.
C) data ccan calways cbe cshared cwith cothers.
D) there cis ca clarge cvolume cof cfile
cI/O. cAnswer: cB
LO: c 1.2: cName cseveral climitations cof cconventional cfile cprocessing
csystems. cDifficulty: cModerate
Classification: c Concept
AACSB: c Information cTechnology
7) Relational cdatabases cestablish cthe crelationships cbetween centities cby cmeans cof ccommon
cfields cincluded cin ca cfile ccalled ca(n):
A) entity.
B) relationship.
C) relation.
D) association.
cAnswer: cC
LO: c 1.3: cExplain cat cleast c10 cadvantages cof cthe cdatabase capproach, ccompared cto ctraditional
cfile cprocessing.
Difficulty: cModerate
cClassification: c Concept
AACSB: c Information cTechnology
8) A(n) is coften cdeveloped cby cidentifying ca cform cor creport cthat ca cuser
cneeds con ca cregular cbasis.
A) enterprise cview
B) reporting cdocument
C) user cview
D) user
csnapshot
cAnswer: cC
LO: c 1.3: cExplain cat cleast c10 cadvantages cof cthe cdatabase capproach, ccompared cto ctraditional
cfile cprocessing.
, 9) A cgraphical csystem cused cto ccapture cthe cnature cand crelationships camong cdata cis ccalled
ca(n):
A) XML cdata cmodel.
B) hypertext cgraphic.
C) relational cdatabase.
D) data
cmodel.
Answer: cD
LO: c 1.3: cExplain cat cleast c10 cadvantages cof cthe cdatabase capproach, ccompared cto ctraditional
cfile cprocessing.
Difficulty: cModerate
cClassification: c Concept
AACSB: c Information cTechnology
10) Data cthat cdescribe cthe cproperties cof cother cdata care:
A) relationships.
B) logical.
C) physical.
D) metadata.
cAnswer: cD
LO: c 1.3: cExplain cat cleast c10 cadvantages cof cthe cdatabase capproach, ccompared cto ctraditional
cfile cprocessing.
Difficulty: cModerate
cClassification: c Concept
AACSB: c Information cTechnology
11) Metatdata ctypically cdescribes call cof cthe cfollowing cEXCEPT:
A) data cdefinitions.
B) length.
C) allowable cvalues.
D) location con
cdisk.
Answer: c D
LO: c 1.3: cExplain cat cleast c10 cadvantages cof cthe cdatabase capproach, ccompared cto ctraditional
cfile cprocessing.
Difficulty: cModerate
cClassification: c Concept
AACSB: c Information cTechnology
4
Copyright c© c2019 cPearson cEducation,
cInc.