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