Concepts of Database Management, 10th Edition, Friedrichsen - Test Bank - All Chapters Covered

TEST BANK

CONCEPTS OF DATABASE MANAGEMENT
10TH EDITION
CHAPTER NO 1: INTRODUCTION TO DATABASE MANAGEMENT


True / False


1. Redundancy refers to the duplication of data, or the storing of the same data in more than
one place.

a. True

b. False

ANSWER: True

POINTS: 1

DIFFICULTY: Easy

REFERENCES: JC Consulting Company Background

QUESTION TYPE: True / False

LEARNING OBJECTIVES: CDBM.PRAT.21.01.01 - Examine JC Consulting (JCC), the company used
for many of the examples throughout the text

KEYWORDS: Bloom’s: Remember


2. Redundancy makes changing data more cumbersome and time-consuming.

a. True

b. False

ANSWER: True

POINTS: 1

DIFFICULTY: Easy

REFERENCES: JC Consulting Company Background

QUESTION TYPE: True / False

,LEARNING OBJECTIVES: CDBM.PRAT.21.01.01 - Examine JC Consulting (JCC), the company used
for many of the examples throughout the text

KEYWORDS: Bloom’s: Understand


3. An entity is a person, place, event, item, or other transaction for which you want to store
and process data.

a. True

b. False

ANSWER: True

POINTS: 1

DIFFICULTY: Easy

REFERENCES: Selecting a Database Solution

QUESTION TYPE: True / False

LEARNING OBJECTIVES: CDBM.PRAT.21.01.02 - Define basic database terminology

KEYWORDS: Bloom’s: Remember


4. An employee’s last name is an example of an attribute.

a. True

b. False

ANSWER: False

POINTS: 1

DIFFICULTY: Easy

REFERENCES: Selecting a Database Solution

QUESTION TYPE: True / False

LEARNING OBJECTIVES: CDBM.PRAT.21.01.02 - Define basic database terminology

KEYWORDS: Bloom’s: Remember


5. An attribute is known as a row in most databases.

, a. True

b. False

ANSWER: False

POINTS: 1

DIFFICULTY: Easy

REFERENCES: Selecting a Database Solution

QUESTION TYPE: True / False

LEARNING OBJECTIVES: CDBM.PRAT.21.01.02 - Define basic database terminology

KEYWORDS: Bloom’s: Remember



Multiple Choice


6. A(n) _____ can store information about multiple types of entities and the relationships
among the entities.

a. flat file

b. attribute

c. relational database

d. spreadsheet

ANSWER: c

POINTS: 1

DIFFICULTY: Easy

REFERENCES: Storing Data

QUESTION TYPE: Multiple Choice

LEARNING OBJECTIVES: CDBM.PRAT.21.01.02 - Define basic database terminology

KEYWORDS: Bloom’s: Remember


7. Which of the following is a visual way to represent and analyze a database?

, a. entity-relationship (E-R) diagram

b. algorithm

c. encryption diagram

d. metadata

ANSWER: a

POINTS: 1

DIFFICULTY: Easy

REFERENCES: Storing Data

QUESTION TYPE: Multiple Choice

LEARNING OBJECTIVES: CDBM.PRAT.21.01.02 - Define basic database terminology

KEYWORDS: Bloom’s: Remember


8. What do two tables use to link related records from each table?

a. a form

b. an orphan record

c. a unique value

d. a common field

ANSWER: d

POINTS: 1

DIFFICULTY: Moderate

REFERENCES: Storing Data

QUESTION TYPE: Multiple Choice

LEARNING OBJECTIVES: CDBM.PRAT.21.01.02 - Define basic database terminology

KEYWORDS: Bloom’s: Remember