THIS DOCUMENT BELONGS TO TESTBANKSPROF
Test Bank for Modern Database Management 13th Edition
By Heikki Topi Jeffrey A Hoffer Ramesh Venkataraman
All Chapter (1-14) |Verified Q&A| Graded A+
ISBN: 9780805360547
~1~
, THIS DOCUMENT BELONGS TO TESTBANKSPROF
TABLE OF CONTENTS
Chapter 1 The Database Environment and Development Process .................... 3
Chapter 2 Modeling Data in the Organization .................................................. 35
Chapter 3 The Enhanced E-R Model ................................................................. 61
Chapter 4 Logical Database Design and the Relational Model......................... 89
Chapter 5 Introduction to SQL ........................................................................ 115
Chapter 6 Advanced SQL ................................................................................. 142
Chapter 7 Databases in Applications.............................................................. 168
Chapter 8 Physical Database Design and Database Infrastructure ............... 193
Chapter 9 Data Warehousing and Data Integration ....................................... 238
Chapter 10 Big Data Technologies .................................................................. 279
Chapter 11 Analytics and Its Implications ..................................................... 297
Chapter 12 Data and Database Administration with Focus on Data Quality . 306
Chapter 13 Distributed Databases ................................................................. 324
Chapter 14 Object-Oriented Data Modeling ................................................... 351
~2~
, THIS DOCUMENT BELONGS TO TESTBANKSPROF
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.
CORRECT ANSWER: 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.
CORRECT ANSWER: 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
CORRECT ANSWER: 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
~3~
, THIS DOCUMENT BELONGS TO TESTBANKSPROF
C) poor; mainframes
D) excellent; workgroup computers
CORRECT ANSWER: C
LO: 3.1: Define key terms.
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.
CORRECT ANSWER: 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.
CORRECT ANSWER: 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.
~4~
Test Bank for Modern Database Management 13th Edition
By Heikki Topi Jeffrey A Hoffer Ramesh Venkataraman
All Chapter (1-14) |Verified Q&A| Graded A+
ISBN: 9780805360547
~1~
, THIS DOCUMENT BELONGS TO TESTBANKSPROF
TABLE OF CONTENTS
Chapter 1 The Database Environment and Development Process .................... 3
Chapter 2 Modeling Data in the Organization .................................................. 35
Chapter 3 The Enhanced E-R Model ................................................................. 61
Chapter 4 Logical Database Design and the Relational Model......................... 89
Chapter 5 Introduction to SQL ........................................................................ 115
Chapter 6 Advanced SQL ................................................................................. 142
Chapter 7 Databases in Applications.............................................................. 168
Chapter 8 Physical Database Design and Database Infrastructure ............... 193
Chapter 9 Data Warehousing and Data Integration ....................................... 238
Chapter 10 Big Data Technologies .................................................................. 279
Chapter 11 Analytics and Its Implications ..................................................... 297
Chapter 12 Data and Database Administration with Focus on Data Quality . 306
Chapter 13 Distributed Databases ................................................................. 324
Chapter 14 Object-Oriented Data Modeling ................................................... 351
~2~
, THIS DOCUMENT BELONGS TO TESTBANKSPROF
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.
CORRECT ANSWER: 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.
CORRECT ANSWER: 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
CORRECT ANSWER: 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
~3~
, THIS DOCUMENT BELONGS TO TESTBANKSPROF
C) poor; mainframes
D) excellent; workgroup computers
CORRECT ANSWER: C
LO: 3.1: Define key terms.
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.
CORRECT ANSWER: 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.
CORRECT ANSWER: 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.
~4~
