COMPLETE TEST BANK Modern Database Management 12th Edition by Jeffrey Hoffer, Ramesh Venkataraman, Heikki Topi

COMPLETE TEST BANK

Modern Database Management 12th Edition

by Jeffrey Hoffer, Ramesh Venkataraman, Heikki Topi


12th Edition

,Table of Contents
Part I The Context of Database Management ......................................... 3
Chapter 1 The Database Environment and Development Process ............................................. 3
Part II Database Analysis and Logical Design ....................................... 46
Chapter 2: Modeling Data in the Organization ........................................................................ 46
Chapter 3: The Enhanced E-R Model ........................................................................................ 79
Chapter 4: Logical Database Design and the Relational Model ............................................. 100
Part III: Database Implementation and Use ......................................... 130
Chapter 5: Introduction to SQL ............................................................................................... 130
Chapter 6: Advanced SQL........................................................................................................ 142
Chapter 7: Databases in Applications (Includes transaction integrity, multi-user solutions,
application security) ................................................................................................................ 168
Chapter 8: Physical Database Design and Database Infrastructure (Includes security,
backup/recovery, and cloud solutions) ................................................................................... 178
Part IV Advanced Database Topics ...................................................... 234
Chapter 9: Data Warehousing and Data Integration............................................................... 234
Chapter 10: Big Data Technologies ......................................................................................... 244
Chapter 11: Analytics and Its Implications ............................................................................. 293
Chapter 12: Data and Database Administration with Focus on Data Quality ....... 304

,Part I The Context of Database Management
Chapter 1 The Database Environment and Development Process

1) One application of data warehouses is:

A) shipping of information.

B) order processing.

C) decision support.

D) file updating.

Accurate answer: C

Diff: 3 Page Ref:4 Topic: Introduction

AACSB: Use of Information Technology



2) Older systems that often contain data of poor quality are called systems.

A) controlled

B) legacy

C) database

D) mainframe

Accurate answer: B

Diff: 3 Page Ref:4 Topic: Introduction

AACSB: Use of Information Technology Subtopic: Conversion Costs



3) A database is an organized collection of related data.

A) logically

B) physically

C) loosely

D) badly

Accurate answer: A

Diff: 1 Page Ref:5

Topic: Basic Concepts and Definitions AACSB: Use of Information Technology

, 4) Which of the following types of data can be stored in a database?

A) Voice

B) Letters

C) Numbers

D) All of the above

Accurate answer: D

Diff: 1 Page Ref:5

Topic: Basic Concepts and Definitions

AACSB: Analytic Skills, Use of Information Technology Subtopic: Data



5) Data processed in a way that increases a user's knowledge is:

A) text.

B) graphics

C) information.

D) hyperlink.

Accurate answer: C

Diff: 1 Page Ref:6

Topic: Basic Concepts and Definitions AACSB: Use of Information Technology Subtopic: Data
Versus Information



6) Data that describe the properties of other data are:

A) relationships.

B) logical.

C) physical.

D) none of the above.

Accurate answer: D

Diff: 2 Page Ref:7

Topic: Basic Concepts and Definitions AACSB: Use of Information Technology Subtopic:
Metadata