Chapter 01: Database Systems
True / False
1. Data and information are essentially the same thing.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
3. Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
4. When data are entered into a form and saved, they are placed in the underlying database as knowledge.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
5. Data constitute the building blocks of information.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
6. Metadata describe the data characteristics and the set of relationships that links the data found within the database.
a. True
b. False
Copyright Cengage Learning. Powered by Cognero. Page 1
,Chapter 01: Database Systems
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
7. The only way to access the data in a database is through the DBMS.
a. True
b. False
ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
8. Database programming languages receive all application requests and translate them into the complex operations
required to fulfill those requests.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
11. An operational database is sometimes referred to as an enterprise database.
a. True
b. False
Copyright Cengage Learning. Powered by Cognero. Page 2
,Chapter 01: Database Systems
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
12. A data warehouse can store data derived from many sources.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
13. Structure is based on the type of processing to be performed on the data.
a. True
b. False
ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
14. Corporations use only structured data.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
15. Field refers to a collection of related records.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-5b Computerized File Systems
LEARNING OBJECTIVES: 01.04 - See how modern databases evolved from file systems
16. Structural dependence exists when it is possible to make changes in the file structure without affecting the application
program’s ability to access the data.
a. True
b. False
ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 3
, Chapter 01: Database Systems
DIFFICULTY: Moderate
REFERENCES: 1-6a Structural and Data Dependence
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
17. One disadvantage of a database system over previous data management approaches is increased costs.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
18. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world
events and conditions.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-6b Data Redundancy
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system
20. One advantage of a database system over previous data management approaches is that the database system is
considerably less complex.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system
Multiple Choice
21. _____ is the result of revealing the meaning of raw facts.
a. End-user data b. An encoded sample
c. An encrypted bit d. Information
ANSWER: d
DIFFICULTY: Easy
Copyright Cengage Learning. Powered by Cognero. Page 4
True / False
1. Data and information are essentially the same thing.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
3. Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
4. When data are entered into a form and saved, they are placed in the underlying database as knowledge.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
5. Data constitute the building blocks of information.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
6. Metadata describe the data characteristics and the set of relationships that links the data found within the database.
a. True
b. False
Copyright Cengage Learning. Powered by Cognero. Page 1
,Chapter 01: Database Systems
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
7. The only way to access the data in a database is through the DBMS.
a. True
b. False
ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
8. Database programming languages receive all application requests and translate them into the complex operations
required to fulfill those requests.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
11. An operational database is sometimes referred to as an enterprise database.
a. True
b. False
Copyright Cengage Learning. Powered by Cognero. Page 2
,Chapter 01: Database Systems
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
12. A data warehouse can store data derived from many sources.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
13. Structure is based on the type of processing to be performed on the data.
a. True
b. False
ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
14. Corporations use only structured data.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTI 01.02 - Describe what a database is, the various types of databases, and why they are valuable
VES: assets for decision making
15. Field refers to a collection of related records.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-5b Computerized File Systems
LEARNING OBJECTIVES: 01.04 - See how modern databases evolved from file systems
16. Structural dependence exists when it is possible to make changes in the file structure without affecting the application
program’s ability to access the data.
a. True
b. False
ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 3
, Chapter 01: Database Systems
DIFFICULTY: Moderate
REFERENCES: 1-6a Structural and Data Dependence
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
17. One disadvantage of a database system over previous data management approaches is increased costs.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
18. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world
events and conditions.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-6b Data Redundancy
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system
20. One advantage of a database system over previous data management approaches is that the database system is
considerably less complex.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-7c Managing the Database System: A Shift in Focus
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system
Multiple Choice
21. _____ is the result of revealing the meaning of raw facts.
a. End-user data b. An encoded sample
c. An encrypted bit d. Information
ANSWER: d
DIFFICULTY: Easy
Copyright Cengage Learning. Powered by Cognero. Page 4
