TESTBANK fh
MODERN DATABASE MANAGEMENT, 14TH EDITION
fh fh fh fh
Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
fh fh fh fh fh
,Modern Database Management, 13e (Hoffer)
fh fh fh fh
Chapter 1 The Database Environment and Development Process
fh f h f h fh fh fh fh fh
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
fh fh fh fh fh fh fh fh fh fh fh fh
more than:
fh fh
A) 1 terabyte of data.
fh fh fh
B) 3 gigabytes of data.
fh fh fh
C) at least 100 petabytes of data.
fh fh fh fh fh
D) more than 7 billion exabytes of data.
fh fh fh fh fh fh
Answer: D
fh f h
LO: 1.1:Define key terms.
f h fh fh fh
Difficulty: Easy
fh f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
2) Database management involves all of the following EXCEPT:fh fh fh fh fh fh fh
A) collecting data. fh
B) organizing data. fh
C) design web pages. fh fh
D) managingdata. fh
Answer: C
fh f h
LO: 1.1:Define key terms.
f h fh fh fh
Difficulty: Easy
fh f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
3) A database is an organized collection of
fh fh fh fh fh fh fh related data. fh
A) logically
B) physically
C) loosely
D) badly
Answer:
fh
A
f h
LO: 1.1:Define key terms.
f h fh fh fh
Difficulty: Easy
fh f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
4) Legacy systems often contain data of fh fh fh fh fh fh quality and are generally hosted on
fh fh fh fh fh fh .
A) poor; personal computers
fh fh
B) excellent; mainframes fh
C) poor; mainframes fh
D) excellent;workgroupcomputers fh fh
Answer: C
fh f h
LO: 3.1:Define key terms.
f h fh fh fh
Difficulty: Moderate
fh f h
Classification: Concept
fh f h
100
Copyright © 2019 Pearson Education, Inc. fh fh fh fh fh
,AACSB: Information Technology
f h fh
100
Copyright © 2019 Pearson Education, Inc.
fh fh fh fh fh
, 5) Program-data dependence is caused by: fh fh fh fh
A) file descriptions being stored in each database application.
fh fh fh fh fh fh fh
B) data descriptions being stored on a server.
fh fh fh fh fh fh
C) data descriptions being written into programming code.
fh fh fh fh fh fh
D) datacohabitingwithprograms.
fh fh fh
Answer: A
fh f h
LO: 1.2: Name several limitations of conventional file processing systems.
f h fh fh fh fh fh fh fh fh
Difficulty: Moderate
fh f h
Classification: Concept f h
AACSB: Information Technology f h fh
6) Because applications are often developed independently in file processing systems:
fh fh fh fh fh fh fh fh fh
A) the data is always non-redundant.
fh fh fh fh
B) unplanned duplicate data files are the rule rather than the exception. fh fh fh fh fh fh fh fh fh fh
C) data can always be shared with others.
fh fh fh fh fh fh
D) there is a large volume of file I/O.
fh fh fh fh fh fh fh
Answer: B
fh f h
LO: 1.2: Name several limitations of conventional file processing systems.
f h fh fh fh fh fh fh fh fh
Difficulty: Moderate
fh f h
Classification: Concept f h
AACSB: Information Technology f h fh
7) Relational databases establish the relationships between entities by means of common fields
fh fh fh fh fh fh fh fh fh fh fh
included in a file called a(n):
fh fh fh fh fh fh
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
fh f h
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
f h fh fh fh fh fh fh fh fh fh fh fh fh fh
processing.
fh
Difficulty: Moderate f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
8) A(n) is often developed by identifying a form or report that a user needs on a
fh fh fh fh fh fh fh fh fh fh fh fh fh fh fh
regular basis.
fh fh
A) enterprise view fh
B) reporting document fh
C) user view fh
D) usersnapshot fh
Answer: C
fh f h
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
f h fh fh fh fh fh fh fh fh fh fh fh fh fh
processing.
fh
Difficulty: Moderate f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
100
Copyright © 2019 Pearson Education, Inc. fh fh fh fh fh
MODERN DATABASE MANAGEMENT, 14TH EDITION
fh fh fh fh
Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
fh fh fh fh fh
,Modern Database Management, 13e (Hoffer)
fh fh fh fh
Chapter 1 The Database Environment and Development Process
fh f h f h fh fh fh fh fh
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
fh fh fh fh fh fh fh fh fh fh fh fh
more than:
fh fh
A) 1 terabyte of data.
fh fh fh
B) 3 gigabytes of data.
fh fh fh
C) at least 100 petabytes of data.
fh fh fh fh fh
D) more than 7 billion exabytes of data.
fh fh fh fh fh fh
Answer: D
fh f h
LO: 1.1:Define key terms.
f h fh fh fh
Difficulty: Easy
fh f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
2) Database management involves all of the following EXCEPT:fh fh fh fh fh fh fh
A) collecting data. fh
B) organizing data. fh
C) design web pages. fh fh
D) managingdata. fh
Answer: C
fh f h
LO: 1.1:Define key terms.
f h fh fh fh
Difficulty: Easy
fh f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
3) A database is an organized collection of
fh fh fh fh fh fh fh related data. fh
A) logically
B) physically
C) loosely
D) badly
Answer:
fh
A
f h
LO: 1.1:Define key terms.
f h fh fh fh
Difficulty: Easy
fh f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
4) Legacy systems often contain data of fh fh fh fh fh fh quality and are generally hosted on
fh fh fh fh fh fh .
A) poor; personal computers
fh fh
B) excellent; mainframes fh
C) poor; mainframes fh
D) excellent;workgroupcomputers fh fh
Answer: C
fh f h
LO: 3.1:Define key terms.
f h fh fh fh
Difficulty: Moderate
fh f h
Classification: Concept
fh f h
100
Copyright © 2019 Pearson Education, Inc. fh fh fh fh fh
,AACSB: Information Technology
f h fh
100
Copyright © 2019 Pearson Education, Inc.
fh fh fh fh fh
, 5) Program-data dependence is caused by: fh fh fh fh
A) file descriptions being stored in each database application.
fh fh fh fh fh fh fh
B) data descriptions being stored on a server.
fh fh fh fh fh fh
C) data descriptions being written into programming code.
fh fh fh fh fh fh
D) datacohabitingwithprograms.
fh fh fh
Answer: A
fh f h
LO: 1.2: Name several limitations of conventional file processing systems.
f h fh fh fh fh fh fh fh fh
Difficulty: Moderate
fh f h
Classification: Concept f h
AACSB: Information Technology f h fh
6) Because applications are often developed independently in file processing systems:
fh fh fh fh fh fh fh fh fh
A) the data is always non-redundant.
fh fh fh fh
B) unplanned duplicate data files are the rule rather than the exception. fh fh fh fh fh fh fh fh fh fh
C) data can always be shared with others.
fh fh fh fh fh fh
D) there is a large volume of file I/O.
fh fh fh fh fh fh fh
Answer: B
fh f h
LO: 1.2: Name several limitations of conventional file processing systems.
f h fh fh fh fh fh fh fh fh
Difficulty: Moderate
fh f h
Classification: Concept f h
AACSB: Information Technology f h fh
7) Relational databases establish the relationships between entities by means of common fields
fh fh fh fh fh fh fh fh fh fh fh
included in a file called a(n):
fh fh fh fh fh fh
A) entity.
B) relationship.
C) relation.
D) association.
Answer: C
fh f h
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
f h fh fh fh fh fh fh fh fh fh fh fh fh fh
processing.
fh
Difficulty: Moderate f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
8) A(n) is often developed by identifying a form or report that a user needs on a
fh fh fh fh fh fh fh fh fh fh fh fh fh fh fh
regular basis.
fh fh
A) enterprise view fh
B) reporting document fh
C) user view fh
D) usersnapshot fh
Answer: C
fh f h
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
f h fh fh fh fh fh fh fh fh fh fh fh fh fh
processing.
fh
Difficulty: Moderate f h
Classification: Concept
fh f h
AACSB: Information Technology f h fh
100
Copyright © 2019 Pearson Education, Inc. fh fh fh fh fh
