TESTBANK
,Modern Database Management, 13e (Hoffer)
ht ht ht ht
Chapter 1 The Database Environment and Development Process
ht h t ht ht ht ht ht
1) According to a McKinsey Global InstituteReport, in2010 alone, globalenterprises stored mo
ht ht ht ht ht ht ht ht ht ht ht ht ht
re than:
ht
A) 1 terabyte of data.
ht ht ht
B) 3 gigabytes of data.
ht ht ht
C) at least 100 petabytes of data.
ht ht ht ht ht
D) morethan 7 billion exabytes ofdata.
ht ht ht ht ht ht ht
Answer: D ht
LO: 1.1:Define keyterms. Di f
h t ht ht ht ht ht
ficulty: Easy Classification:
ht ht
Concept
AACSB: Information Technology h t ht
2) Database management involves allofthe following EXCEPT: ht ht ht ht ht ht ht
A) collecting data. ht
B) organizing data. ht
C) design web pages. 1a ht
D) managingdata. ht ht
Answer: C ht
LO: 1.1:Define keyterms. Di f
h t ht ht ht ht ht
ficulty: Easy Classification:
ht ht
Concept
AACSB: Information Technology h t ht
3) Adatabase is an organized collection of
ht ht ht ht ht ht related data. ht
A) logically
B) physically
C) loosely
D) badly A ht ht
nswer: A ht
LO: 1.1:Define keyterms. Di f
h t ht ht ht ht ht
ficulty: Easy Classification:
ht ht
Concept
AACSB: Information Technology h t ht
4) Legacysystems often contain data of ht ht ht ht ht quality and are generally hosted on
ht ht ht ht ht .
A) poor; personal computers ht ht
B) excellent; mainframes ht
C) poor;mainframes ht
D) excellent; workgroupcomputers ht ht ht
Answer: C ht
LO: 3.1: Define key terms.
ht ht ht ht
,5) Program-datadependence is caused by: ht ht ht 1a
A) file descriptions being stored in each database application.
ht ht ht ht ht ht ht
B) datadescriptions being stored on a server.
ht ht ht 1a ht ht
C) datadescriptions being written into programming code.
ht ht ht ht 1a ht
D) data cohabitingwith programs.
1a ht 1a ht
Answer: A ht
LO: 1.2:Name severallimitations ofconventional file processing systems. Diffic
h t ht ht ht ht ht ht ht 1a ht
ulty: Moderate
ht
Classification: Concept h t
AACSB: Information Technology h t ht
6) Because applications are often developed independently in file processing systems:
ht ht ht ht ht ht ht ht ht
A) the data is always non-redundant.
ht ht ht ht
B) unplanned duplicate data files are the rule rather than the exception. ht ht ht ht ht ht ht ht ht ht
C) datacan always be shared with others.
ht ht ht ht ht ht
D) there is a large volumeoffile I/O.
ht 1a ht ht ht ht ht ht
Answer: B ht
LO: 1.2: Name severallimitations ofconventional file processing systems. Diffic
h t ht ht ht ht ht ht ht ht ht
ulty: Moderate
ht
Classification: Concept h t
AACSB: Information Technology h t ht
7) Relationaldatabases establish the relationships between entities bymeans ofcommon fields i nc
ht ht ht ht ht 1a ht ht ht ht ht ht ht
luded in a file called a(n):
ht ht ht ht ht
A) entity.
B) relationship.
C) relation.
D) association. h
Answer: C
t ht
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept
ht
AACSB: Information Technology h t ht
8) A(n)
is often developed by identifying a form or report that a user needs on a regular basis.
ht ht ht ht ht ht ht ht 1a ht ht ht ht ht ht ht
A) enterprise view ht
B) reporting document ht
C) user view ht
D) usersnapshot ht
Answer: C ht
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
, 9) Agraphical systemused to capturethe nature and relationships among data is called a(n):
ht ht ht ht ht ht ht ht ht ht ht ht ht ht
A) XMLdata model. ht ht
B) hypertext graphic. 1a
C) relational database. ht
D) data model. ht h
Answer: D
t ht
LO: 1.3:Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht 1a ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept ht
AACSB: Information Technology h t ht
10) Datathat describe the properties ofother data are:
ht ht ht ht ht ht ht ht
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
ht ht
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept ht
AACSB: Information Technology h t ht
11) Metatdatatypically describes all of the following EXCEPT: ht ht ht ht ht ht ht
A) data definitions.1a
B) length.
C) allowable values. ht
D) locationon disk. ht 1a ht
Answer: D h t
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept ht
AACSB: Information Technology h t ht
4
Copyright © 2019 Pearson Education, Inc.
ht ht ht ht ht
,Modern Database Management, 13e (Hoffer)
ht ht ht ht
Chapter 1 The Database Environment and Development Process
ht h t ht ht ht ht ht
1) According to a McKinsey Global InstituteReport, in2010 alone, globalenterprises stored mo
ht ht ht ht ht ht ht ht ht ht ht ht ht
re than:
ht
A) 1 terabyte of data.
ht ht ht
B) 3 gigabytes of data.
ht ht ht
C) at least 100 petabytes of data.
ht ht ht ht ht
D) morethan 7 billion exabytes ofdata.
ht ht ht ht ht ht ht
Answer: D ht
LO: 1.1:Define keyterms. Di f
h t ht ht ht ht ht
ficulty: Easy Classification:
ht ht
Concept
AACSB: Information Technology h t ht
2) Database management involves allofthe following EXCEPT: ht ht ht ht ht ht ht
A) collecting data. ht
B) organizing data. ht
C) design web pages. 1a ht
D) managingdata. ht ht
Answer: C ht
LO: 1.1:Define keyterms. Di f
h t ht ht ht ht ht
ficulty: Easy Classification:
ht ht
Concept
AACSB: Information Technology h t ht
3) Adatabase is an organized collection of
ht ht ht ht ht ht related data. ht
A) logically
B) physically
C) loosely
D) badly A ht ht
nswer: A ht
LO: 1.1:Define keyterms. Di f
h t ht ht ht ht ht
ficulty: Easy Classification:
ht ht
Concept
AACSB: Information Technology h t ht
4) Legacysystems often contain data of ht ht ht ht ht quality and are generally hosted on
ht ht ht ht ht .
A) poor; personal computers ht ht
B) excellent; mainframes ht
C) poor;mainframes ht
D) excellent; workgroupcomputers ht ht ht
Answer: C ht
LO: 3.1: Define key terms.
ht ht ht ht
,5) Program-datadependence is caused by: ht ht ht 1a
A) file descriptions being stored in each database application.
ht ht ht ht ht ht ht
B) datadescriptions being stored on a server.
ht ht ht 1a ht ht
C) datadescriptions being written into programming code.
ht ht ht ht 1a ht
D) data cohabitingwith programs.
1a ht 1a ht
Answer: A ht
LO: 1.2:Name severallimitations ofconventional file processing systems. Diffic
h t ht ht ht ht ht ht ht 1a ht
ulty: Moderate
ht
Classification: Concept h t
AACSB: Information Technology h t ht
6) Because applications are often developed independently in file processing systems:
ht ht ht ht ht ht ht ht ht
A) the data is always non-redundant.
ht ht ht ht
B) unplanned duplicate data files are the rule rather than the exception. ht ht ht ht ht ht ht ht ht ht
C) datacan always be shared with others.
ht ht ht ht ht ht
D) there is a large volumeoffile I/O.
ht 1a ht ht ht ht ht ht
Answer: B ht
LO: 1.2: Name severallimitations ofconventional file processing systems. Diffic
h t ht ht ht ht ht ht ht ht ht
ulty: Moderate
ht
Classification: Concept h t
AACSB: Information Technology h t ht
7) Relationaldatabases establish the relationships between entities bymeans ofcommon fields i nc
ht ht ht ht ht 1a ht ht ht ht ht ht ht
luded in a file called a(n):
ht ht ht ht ht
A) entity.
B) relationship.
C) relation.
D) association. h
Answer: C
t ht
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept
ht
AACSB: Information Technology h t ht
8) A(n)
is often developed by identifying a form or report that a user needs on a regular basis.
ht ht ht ht ht ht ht ht 1a ht ht ht ht ht ht ht
A) enterprise view ht
B) reporting document ht
C) user view ht
D) usersnapshot ht
Answer: C ht
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
, 9) Agraphical systemused to capturethe nature and relationships among data is called a(n):
ht ht ht ht ht ht ht ht ht ht ht ht ht ht
A) XMLdata model. ht ht
B) hypertext graphic. 1a
C) relational database. ht
D) data model. ht h
Answer: D
t ht
LO: 1.3:Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht 1a ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept ht
AACSB: Information Technology h t ht
10) Datathat describe the properties ofother data are:
ht ht ht ht ht ht ht ht
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer: D
ht ht
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept ht
AACSB: Information Technology h t ht
11) Metatdatatypically describes all of the following EXCEPT: ht ht ht ht ht ht ht
A) data definitions.1a
B) length.
C) allowable values. ht
D) locationon disk. ht 1a ht
Answer: D h t
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro cessing.
h t ht ht ht ht ht ht ht ht ht ht ht ht ht ht ht
Difficulty: Moderate Classific ht ht ht
ation: Concept ht
AACSB: Information Technology h t ht
4
Copyright © 2019 Pearson Education, Inc.
ht ht ht ht ht