MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
TEST BANK MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF
HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI ALL CHAPTERS
COVERED QUESTIONS AND ANSWERS GRADED A+ 100% VERIFIED.
,MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
TABLE OF CONTENT
I. The Context of Database Management
1. The Database Environment and Development Process
II. Database Analysis and Logical Design
2. Modelling Data in the Organization
3. The Enhanced E-R Model
4. Logical Database Design and the Relational Model
III. Database Implementation and Use
5. Introduction to SQL
6. Advanced SQL
7. Databases in Applications
8. Physical Database Design and Database Infrastructure
IV. Advanced Database Topics
9. Data Warehousing and Data Integration
10. Big Data Technologies
11. Analytics and Its Implications
12. Data and Database Administration with Focus on Data
Quality
Online/Electronic Chapters
13. Distributed Databases
14. Object-Oriented Data Modelling
1
Copyright © 2019 Pearson Education, Inc.
,MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
Modern Database Management, 13e (Hoffer)
Chapter 1 The Database Environment and Development Process
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
more than:
A) 1 terabyte of data.
B) 3 gigabytes of data.
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of data.
ANS >> D
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
2) Database management involves all of the following EXCEPT:
A) collecting data.
B) organizing data.
C) design web pages.
D) managing data.
ANS >> C
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
D) badly
ANS >> A
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
4) Legacy systems often contain data of quality and are generally hosted on .
A) poor; personal computers
B) excellent; mainframes
C) poor; mainframes
D) excellent; workgroup computers
ANS >> C
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
2
Copyright © 2019 Pearson Education, Inc.
, MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
5) Program-data dependence is caused by:
A) file descriptions being stored in each database application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.
ANS >> A
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
6) Because applications are often developed independently in file processing systems:
A) the data is always non-redundant.
B) unplanned duplicate data files are the rule rather than the exception.
C) data can always be shared with others.
D) there is a large volume of file I/O.
ANS >> B
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
7) Relational databases establish the relationships between entities by means of common fields
included in a file called a(n):
A) entity.
B) relationship.
C) relation.
D) association.
ANS >> C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
8) A(n) is often developed by identifying a form or report that a user needs on a
regular basis.
A) enterprise view
B) reporting document
C) user view
D) user snapshot
ANS >> C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
3
Copyright © 2019 Pearson Education, Inc.
TEST BANK MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF
HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI ALL CHAPTERS
COVERED QUESTIONS AND ANSWERS GRADED A+ 100% VERIFIED.
,MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
TABLE OF CONTENT
I. The Context of Database Management
1. The Database Environment and Development Process
II. Database Analysis and Logical Design
2. Modelling Data in the Organization
3. The Enhanced E-R Model
4. Logical Database Design and the Relational Model
III. Database Implementation and Use
5. Introduction to SQL
6. Advanced SQL
7. Databases in Applications
8. Physical Database Design and Database Infrastructure
IV. Advanced Database Topics
9. Data Warehousing and Data Integration
10. Big Data Technologies
11. Analytics and Its Implications
12. Data and Database Administration with Focus on Data
Quality
Online/Electronic Chapters
13. Distributed Databases
14. Object-Oriented Data Modelling
1
Copyright © 2019 Pearson Education, Inc.
,MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
Modern Database Management, 13e (Hoffer)
Chapter 1 The Database Environment and Development Process
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored
more than:
A) 1 terabyte of data.
B) 3 gigabytes of data.
C) at least 100 petabytes of data.
D) more than 7 billion exabytes of data.
ANS >> D
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
2) Database management involves all of the following EXCEPT:
A) collecting data.
B) organizing data.
C) design web pages.
D) managing data.
ANS >> C
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
3) A database is an organized collection of related data.
A) logically
B) physically
C) loosely
D) badly
ANS >> A
LO: 1.1: Define key terms.
Difficulty: Easy
Classification: Concept
AACSB: Information Technology
4) Legacy systems often contain data of quality and are generally hosted on .
A) poor; personal computers
B) excellent; mainframes
C) poor; mainframes
D) excellent; workgroup computers
ANS >> C
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
2
Copyright © 2019 Pearson Education, Inc.
, MODERN DATABASE MANAGEMENT, 13TH EDITION BY JEFF HOFFER, RAMESH VENKATARAMAN, HEIKKI TOPI
5) Program-data dependence is caused by:
A) file descriptions being stored in each database application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.
ANS >> A
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
6) Because applications are often developed independently in file processing systems:
A) the data is always non-redundant.
B) unplanned duplicate data files are the rule rather than the exception.
C) data can always be shared with others.
D) there is a large volume of file I/O.
ANS >> B
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
7) Relational databases establish the relationships between entities by means of common fields
included in a file called a(n):
A) entity.
B) relationship.
C) relation.
D) association.
ANS >> C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
8) A(n) is often developed by identifying a form or report that a user needs on a
regular basis.
A) enterprise view
B) reporting document
C) user view
D) user snapshot
ANS >> C
LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file
processing.
Difficulty: Moderate
Classification: Concept
AACSB: Information Technology
3
Copyright © 2019 Pearson Education, Inc.
