TEST BANK-,
For-Modern Database Management by-,
Hoffer, Ramesh, ,and Topi-,
Latest-Update
13thEdition
,Modern-,Database-,Management,-,13e-,(Hoffer)
Chapter-,1- , The-,Database-,Environment-,and-,Development-,Process
1) According-,to-,a-,McKinsey-,Global-,Institute-,Report,-,in-,2010-,alone,-,global-,enterprises-,stored-
,more-,than:
A) 1-,terabyte-,of-,data.
B) 3-,gigabytes-,of-,data.
C) at-,least-,100-,petabytes-,of-,data.
D) more-,than-,7-,billion-,exabytes-,of-,data.-
,Answer:-,D
LO:- , 1.1:-,Define-,key-,terms.-
,Difficulty:-,Easy-
,Classification:- , Concept
AACSB:- , Information-,Technology
2) Database-,management-, involves-,all-,of-,the-,following-,EXCEPT:
A) collecting-,data.
B) organizing-,data.
C) design-,web-,pages.
D) managing-,data.
Answer:-,C
LO:- , 1.1:-,Define-,key-,terms.-
,Difficulty:-,Easy-
,Classification:- , Concept
AACSB:- , Information-,Technology
3) A-,database-,is-,an-,organized-,collection-,of related-,data.
A) logically
B) physically
C) loosely
D) badly-
,Answer:-, A
LO:- , 1.1:-,Define-,key-,terms.-
,Difficulty:-,Easy-
,Classification:- , Concept
AACSB:- , Information-,Technology
4) Legacy-,systems-,often-,contain-,data-,of quality-,and-,are-,generally-,hosted-,on .
A) poor;-,personal-,computers
B) excellent;-,mainframes
C) poor;-,mainframes
D) excellent;-,workgroup-,computers-
,Answer:-,C
LO:-,3.1:-,Define-,key-,terms.
,5) Program-data-,dependence-,is-,caused-,by:
A) file-,descriptions-,being-,stored-,in-,each-,database-,application.
B) data-,descriptions-,being-,stored-,on-,a-,server.
C) data-,descriptions-,being-,written-,into-,programming-,code.
D) data-,cohabiting-,with-,programs.-
,Answer:-,A
LO:- , 1.2:-,Name-,several-,limitations-,of-,conventional-,file-,processing-,systems.-
,Difficulty:-,Moderate
Classification:- , Concept
AACSB:- , Information-,Technology
6) Because-,applications-,are-,often-,developed-,independently-,in-,file-,processing-,systems:
A) the-,data-,is-,always-,non-redundant.
B) unplanned-,duplicate-,data-,files-,are-,the-,rule-,rather-,than-,the-,exception.
C) data-,can-,always-,be-,shared-,with-,others.
D) there-,is-,a-,large-,volume-,of-,file-,I/O.-
,Answer:-,B
LO:- , 1.2:-,Name-,several-,limitations-,of-,conventional-,file-,processing-,systems.-
,Difficulty:-,Moderate
Classification:- , Concept
AACSB:- , Information-,Technology
7) Relational-,databases-,establish-,the-,relationships-,between-,entities-,by-,means-,of-,common-,fields-
,included-,in-,a-,file-,called-,a(n):
A) entity.
B) relationship.
C) relation.
D) association.
-,Answer:-,C
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
8) A(n) is-,often-,developed-,by-,identifying-,a-,form-,or-,report-,that-,a-,user-,needs-,on-,a-
,regular-,basis.
A) enterprise-,view
B) reporting-,document
C) user-,view
D) user-
,snapshot-
,Answer:-,C
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
, 9) A-,graphical-,system-,used-,to-,capture-,the-,nature-,and-,relationships-,among-,data-,is-,called-,a(n):
A) XML-,data-,model.
B) hypertext-,graphic.
C) relational-,database.
D) data-,model.
Answer:-,D
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
10) Data-,that-,describe-,the-,properties-,of-,other-,data-,are:
A) relationships.
B) logical.
C) physical.
D) metadata.
-,Answer:-,D
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
11) Metatdata-,typically-,describes-,all-,of-,the-,following-,EXCEPT:
A) data-,definitions.
B) length.
C) allowable-,values.
D) location-,on-,disk.
Answer:- , D
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
4
Copyright-,©-,2019-,Pearson-,Education,-,Inc.
For-Modern Database Management by-,
Hoffer, Ramesh, ,and Topi-,
Latest-Update
13thEdition
,Modern-,Database-,Management,-,13e-,(Hoffer)
Chapter-,1- , The-,Database-,Environment-,and-,Development-,Process
1) According-,to-,a-,McKinsey-,Global-,Institute-,Report,-,in-,2010-,alone,-,global-,enterprises-,stored-
,more-,than:
A) 1-,terabyte-,of-,data.
B) 3-,gigabytes-,of-,data.
C) at-,least-,100-,petabytes-,of-,data.
D) more-,than-,7-,billion-,exabytes-,of-,data.-
,Answer:-,D
LO:- , 1.1:-,Define-,key-,terms.-
,Difficulty:-,Easy-
,Classification:- , Concept
AACSB:- , Information-,Technology
2) Database-,management-, involves-,all-,of-,the-,following-,EXCEPT:
A) collecting-,data.
B) organizing-,data.
C) design-,web-,pages.
D) managing-,data.
Answer:-,C
LO:- , 1.1:-,Define-,key-,terms.-
,Difficulty:-,Easy-
,Classification:- , Concept
AACSB:- , Information-,Technology
3) A-,database-,is-,an-,organized-,collection-,of related-,data.
A) logically
B) physically
C) loosely
D) badly-
,Answer:-, A
LO:- , 1.1:-,Define-,key-,terms.-
,Difficulty:-,Easy-
,Classification:- , Concept
AACSB:- , Information-,Technology
4) Legacy-,systems-,often-,contain-,data-,of quality-,and-,are-,generally-,hosted-,on .
A) poor;-,personal-,computers
B) excellent;-,mainframes
C) poor;-,mainframes
D) excellent;-,workgroup-,computers-
,Answer:-,C
LO:-,3.1:-,Define-,key-,terms.
,5) Program-data-,dependence-,is-,caused-,by:
A) file-,descriptions-,being-,stored-,in-,each-,database-,application.
B) data-,descriptions-,being-,stored-,on-,a-,server.
C) data-,descriptions-,being-,written-,into-,programming-,code.
D) data-,cohabiting-,with-,programs.-
,Answer:-,A
LO:- , 1.2:-,Name-,several-,limitations-,of-,conventional-,file-,processing-,systems.-
,Difficulty:-,Moderate
Classification:- , Concept
AACSB:- , Information-,Technology
6) Because-,applications-,are-,often-,developed-,independently-,in-,file-,processing-,systems:
A) the-,data-,is-,always-,non-redundant.
B) unplanned-,duplicate-,data-,files-,are-,the-,rule-,rather-,than-,the-,exception.
C) data-,can-,always-,be-,shared-,with-,others.
D) there-,is-,a-,large-,volume-,of-,file-,I/O.-
,Answer:-,B
LO:- , 1.2:-,Name-,several-,limitations-,of-,conventional-,file-,processing-,systems.-
,Difficulty:-,Moderate
Classification:- , Concept
AACSB:- , Information-,Technology
7) Relational-,databases-,establish-,the-,relationships-,between-,entities-,by-,means-,of-,common-,fields-
,included-,in-,a-,file-,called-,a(n):
A) entity.
B) relationship.
C) relation.
D) association.
-,Answer:-,C
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
8) A(n) is-,often-,developed-,by-,identifying-,a-,form-,or-,report-,that-,a-,user-,needs-,on-,a-
,regular-,basis.
A) enterprise-,view
B) reporting-,document
C) user-,view
D) user-
,snapshot-
,Answer:-,C
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
, 9) A-,graphical-,system-,used-,to-,capture-,the-,nature-,and-,relationships-,among-,data-,is-,called-,a(n):
A) XML-,data-,model.
B) hypertext-,graphic.
C) relational-,database.
D) data-,model.
Answer:-,D
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
10) Data-,that-,describe-,the-,properties-,of-,other-,data-,are:
A) relationships.
B) logical.
C) physical.
D) metadata.
-,Answer:-,D
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
11) Metatdata-,typically-,describes-,all-,of-,the-,following-,EXCEPT:
A) data-,definitions.
B) length.
C) allowable-,values.
D) location-,on-,disk.
Answer:- , D
LO:- , 1.3:-,Explain-,at-,least-,10-,advantages-,of-,the-,database-,approach,-,compared-,to-,traditional-,file-
,processing.
Difficulty:-,Moderate-
,Classification:-, Concept
AACSB:- , Information-,Technology
4
Copyright-,©-,2019-,Pearson-,Education,-,Inc.
