TESTBANK
,Modern Database Management, 13e (Hoffer)
mv mv mv mv
Chapter 1 The Database Environment and Development Process
mv mv mv mv mv m v
1) According to a McKinsey Global Institute Report, in 2010 alone, globalenterprises stored
mv mv n% mv mv m
v mv m
v mv mv mv m
more than:
v mv
A) 1 terabyte of data.
mv mv mv
B) 3 gigabytes of data.
mv mv mv
C) at least 100 petabytes of data.
mv m v mv mv mv
D) more than 7 billion exabytes of data.
m
v mv mv n% mv m
v m
vAnswer: D mv
LO: 1.1:Define keyterms. D
m v mv mv
i fficulty: Easy Classification
mv mv mv
:
Concept
AACSB: Information Technology mv
2) Database management involves all of the following EXCEPT:
mv m v mv m
v m
v mv n%
A) collecting data. mv
B) organizing data. mv
C) design web pages. mv mv
D) managing data. mv m
vAnswer: C mv
LO: 1.1:Define keyterms. D
m v mv mv
i fficulty: Easy Classification
mv mv mv
:
Concept
AACSB: Information Technology mv
3) A database is an organized collection of
mv mv mv mv mv mv related data. n%
A) logically
B) physically
C) loosely
D) badly A mv
mvnswer: A mv
LO: 1.1:Define keyterms. D
m v mv mv
i fficulty: Easy Classification
mv mv mv
:
Concept
AACSB: Information Technology mv
4) Legacysystems often contain data of mv mv mv mv quality and are generally hosted on
mv mv mv mv mv .
A) poor; personal computers mv mv
B) excellent; mainframes mv
C) poor; mainframes mv
D) excellent; workgroup computers mv n% m
vAnswer: C mv
LO: 3.1: Define key terms.
mv mv mv mv
,5) Program-data dependence is caused by: mv mv mv mv
A) file descriptions being stored in each database application.
mv mv mv mv mv mv mv
B) data descriptions being stored on a server.
mv mv mv mv mv mv
C) datadescriptions being written into programming code. mv mv mv mv m v
D) datacohabiting with programs. n% 1 m
Answer: A
v mv
LO: 1.2: Name several limitations ofconventional file processing systems. Di
m v m
v mv m
v mv mv mv 1mv mv
fficulty: Moderate
mv mv
Classification: Concept
AACSB: Information Technology mv
6) Because applications are often developed independently in file processing systems:
mv mv mv mv mv mv mv mv mv
A) the data is always non-redundant.
mv mv mv mv
B) unplanned duplicate data files are the rule rather than the exception.
mv mv mv mv mv mv mv mv mv mv
C) data can always be shared with others.
mv n% mv mv mv mv
D) there is a large volume of file I/O.
mv mv mv mv mv mv mv
Answer: B
mv mv
LO: 1.2: Name several limitations ofconventional file processing systems. Di
m v mv mv m
v mv mv mv mv mv mv
fficulty: Moderate mv
Classification: Concept
AACSB: Information Technology mv
7) Relationaldatabases establish the relationships between entities bymeans ofcommon fields mv mv mv mv 1mv mv mv mv n%
i ncluded in a file called a(n):
mv mv mv mv mv mv
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
mv mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
8) A(n)
is often developed by identifying a form or report that a user needs on a regular basis.
mv mv mv mv mv mv mv mv 1m v mv mv mv mv mv mv mv
A) enterprise view mv
B) reporting document mv
C) user view mv
D) usersnapshot n
Answer: C
m v mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
, 9) Agraphical systemused to capture the nature and relationships among data is called a(n):
mv mv mv mv mv mv mv mv mv mv mv mv
A) XML data model. m
v mv
B) hypertext graphic. mv
C) relational database. mv
D) data model. mv
Answer: D
mv mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
10) Data that describe the properties of other data are:
n% mv mv mv mv mv mv mv
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer:
mv mv
D
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
11) Metatdata typically describes all of the following EXCEPT:
mv mv mv mv mv mv mv
A) data definitions. mv
B) length.
C) allowable values. mv
D) location on disk. n% 1
Answer: D
mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
4
Copyright © 2019 Pearson Education, In
mv mv mv mv mv
c.
,Modern Database Management, 13e (Hoffer)
mv mv mv mv
Chapter 1 The Database Environment and Development Process
mv mv mv mv mv m v
1) According to a McKinsey Global Institute Report, in 2010 alone, globalenterprises stored
mv mv n% mv mv m
v mv m
v mv mv mv m
more than:
v mv
A) 1 terabyte of data.
mv mv mv
B) 3 gigabytes of data.
mv mv mv
C) at least 100 petabytes of data.
mv m v mv mv mv
D) more than 7 billion exabytes of data.
m
v mv mv n% mv m
v m
vAnswer: D mv
LO: 1.1:Define keyterms. D
m v mv mv
i fficulty: Easy Classification
mv mv mv
:
Concept
AACSB: Information Technology mv
2) Database management involves all of the following EXCEPT:
mv m v mv m
v m
v mv n%
A) collecting data. mv
B) organizing data. mv
C) design web pages. mv mv
D) managing data. mv m
vAnswer: C mv
LO: 1.1:Define keyterms. D
m v mv mv
i fficulty: Easy Classification
mv mv mv
:
Concept
AACSB: Information Technology mv
3) A database is an organized collection of
mv mv mv mv mv mv related data. n%
A) logically
B) physically
C) loosely
D) badly A mv
mvnswer: A mv
LO: 1.1:Define keyterms. D
m v mv mv
i fficulty: Easy Classification
mv mv mv
:
Concept
AACSB: Information Technology mv
4) Legacysystems often contain data of mv mv mv mv quality and are generally hosted on
mv mv mv mv mv .
A) poor; personal computers mv mv
B) excellent; mainframes mv
C) poor; mainframes mv
D) excellent; workgroup computers mv n% m
vAnswer: C mv
LO: 3.1: Define key terms.
mv mv mv mv
,5) Program-data dependence is caused by: mv mv mv mv
A) file descriptions being stored in each database application.
mv mv mv mv mv mv mv
B) data descriptions being stored on a server.
mv mv mv mv mv mv
C) datadescriptions being written into programming code. mv mv mv mv m v
D) datacohabiting with programs. n% 1 m
Answer: A
v mv
LO: 1.2: Name several limitations ofconventional file processing systems. Di
m v m
v mv m
v mv mv mv 1mv mv
fficulty: Moderate
mv mv
Classification: Concept
AACSB: Information Technology mv
6) Because applications are often developed independently in file processing systems:
mv mv mv mv mv mv mv mv mv
A) the data is always non-redundant.
mv mv mv mv
B) unplanned duplicate data files are the rule rather than the exception.
mv mv mv mv mv mv mv mv mv mv
C) data can always be shared with others.
mv n% mv mv mv mv
D) there is a large volume of file I/O.
mv mv mv mv mv mv mv
Answer: B
mv mv
LO: 1.2: Name several limitations ofconventional file processing systems. Di
m v mv mv m
v mv mv mv mv mv mv
fficulty: Moderate mv
Classification: Concept
AACSB: Information Technology mv
7) Relationaldatabases establish the relationships between entities bymeans ofcommon fields mv mv mv mv 1mv mv mv mv n%
i ncluded in a file called a(n):
mv mv mv mv mv mv
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
mv mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
8) A(n)
is often developed by identifying a form or report that a user needs on a regular basis.
mv mv mv mv mv mv mv mv 1m v mv mv mv mv mv mv mv
A) enterprise view mv
B) reporting document mv
C) user view mv
D) usersnapshot n
Answer: C
m v mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
, 9) Agraphical systemused to capture the nature and relationships among data is called a(n):
mv mv mv mv mv mv mv mv mv mv mv mv
A) XML data model. m
v mv
B) hypertext graphic. mv
C) relational database. mv
D) data model. mv
Answer: D
mv mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
10) Data that describe the properties of other data are:
n% mv mv mv mv mv mv mv
A) relationships.
B) logical.
C) physical.
D) metadata.
Answer:
mv mv
D
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
11) Metatdata typically describes all of the following EXCEPT:
mv mv mv mv mv mv mv
A) data definitions. mv
B) length.
C) allowable values. mv
D) location on disk. n% 1
Answer: D
mv
LO: 1.3: Explain at least 10 advantages ofthe database approach, compared to traditional file pro c
m v mv mv mv mv mv mv mv mv mv mv mv mv mv mv
es sing. mv
Difficulty: Moderate Classific mv mv n
ation: Concept
m v mv
AACSB: Information Technology mv
4
Copyright © 2019 Pearson Education, In
mv mv mv mv mv
c.