lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
lOMoAR cPSD| 3013804
Test Bank
Database Systems Design, Implementation, & Management, 14th
Edition Carlos Coronel, Steven Morris
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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
, lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
, lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
, lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
Chapter 01: Database Systems
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
lOMoAR cPSD| 3013804
Test Bank
Database Systems Design, Implementation, & Management, 14th
Edition Carlos Coronel, Steven Morris
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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
, lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
, lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
, lOMoAR cPSD| 3013804
mentation,
, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
Test
& Management,
Bank Database
14thSystems
Edition Carlos
Design,Coronel,
Implementation,
Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@
& Management, 14th Edition Carlos Coronel, Steven Morris.docx@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#
Chapter 01: Database Systems
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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 OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable 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
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
@#@(H*HNRMD*R)(#I$M*)(I$($)_I_@)I$)(#I($*Y$NHHMN&*(@*$I(@(@@@@@@@@@@@@!@ED@EKDLKEIO@IOPO@#)__$)))%)_)#_
