Test Bank for Concepts of Database Management 9th Edition by Joy L. Starks

Chapter 01: Introduction to Database Management

1. Redundancy wastes space because you are storing multiple copies of the same data.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: BITS Company Background

2. Redundancy makes changing data more cumbersome and time-consuming.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: BITS Company Background

3. An entity is a person, place, object, event, or idea for which you want to store and process data.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Terminology

4. A client is an example of an attribute.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Terminology

5. An attribute is known as a row in most databases.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Terminology

6. A database will not only hold information about multiple types of entities, but also information about the
relationships among these multiple entities.


1

,Chapter 01: Introduction to Database Management

a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Storing Data

7. Each table in a database represents two or more entities.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Storing Data

8. The relationship between different entities (in different tables) is handled by their common columns.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Storing Data

9. Users never interact with a database directly; database interaction is always through the DBMS.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Database Management Systems

10. Programs created with Visual Basic, Java, Perl, PHP, or C++ can interact with the database directly.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Management Systems

11. A spreadsheet is a screen object used to maintain and view data from a database.
a. True
b. False


2

,Chapter 01: Introduction to Database Management

ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Management Systems

12. Increased complexity is one advantage of database processing.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Advantages of Database Processing

13. An advantage of using the database approach to processing is that it facilitates consistency.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Advantages of Database Processing

14. If a user is authorized to access database data, the user will always be able to make changes to the data.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Advantages of Database Processing

15. There is a greater impact of failure in a nondatabase, file-oriented system.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Disadvantages of Database Processing

16. Which term can be described as the duplication of data and storing it in multiple locations?
a. data independence
b. redundancy
c. data integrity
d. security


3

, Chapter 01: Introduction to Database Management

ANSWER: b
POINTS: 1
DIFFICULTY: Easy
REFERENCES: BITS Company Background

17. Which of the following is called a field or column in many database systems?
a. attribute
b. entity
c. data file
d. relationship
ANSWER: a
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Terminology

18. Which database term is a person, place, object, event, or idea for which you want to store and process data?
a. attribute
b. DBMS
c. entity
d. DBA
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Database Terminology

19. In database terms, what is the analogy to an ordinary paper file you might keep in a file cabinet or an
accounting ledger?
a. database
b. spreadsheet
c. data file
d. attribute
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Storing Data

20. Which aspect of an entity becomes the columns in the database table?
a. attributes
b. relationships
c. data files
d. E-R diagrams



4