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