TEST BANK
DATABASE SYSTEMS DESIGN
IMPLEMENTATION & MANAGEMENT
14TH EDITION
CHAPTER 01 DATABASE MODELS
1. Data is the result of interpreting facts to reveal meaning.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. Data is the result of processing raw facts to reveal their meaning.
Incorrect Incorrect. Data is the result of processing raw facts to reveal their meaning.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.01 - Define the difference between data and information
TOPICS: Data versus Information
KEYWORDS: Bloom's: Understand
2. A data warehouse can store data derived from many sources.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. The data warehouse stores historical data obtained from many sources.
Incorrect Incorrect. The data warehouse stores historical data obtained from many sources.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.02 - Describe what a database is, the various types of databases, and
why they are valuable assets for decision making
TOPICS: Introducing the Database
KEYWORDS: Bloom's: Remember
3. Unstructured data is data that exists in the format in which it was collected (raw state). While Structured data
is the result of formatting unstructured data to enable storage, use, and generation of information.
a. True
b. False
,ANSWER: True
FEEDBACK: Correct Correct. Unstructured data is in its raw state while structured data is formatted to
enable storage and generation of meaningful information.
Incorrect Incorrect. Unstructured data is in its raw state while structured data is formatted to
enable storage and generation of meaningful information.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.02 - Describe what a database is, the various types of databases, and
why they are valuable assets for decision making
TOPICS: Data versus Information
KEYWORDS: Bloom's: Remember
4. A good Database Management System (DBMS) will perform well even with a badly designed database.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. A well designed database is essential for a DBMS to perform well.
Incorrect Incorrect. A well designed database is essential for a DBMS to perform well.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.03 - Explain the importance of database design
TOPICS: Why database design is important
KEYWORDS: Bloom's: Understand
5. Thorough database planning and design is important to ensure that data is properly used to give the
organization the most benefit.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. Thorough database planning and design is important for a DBMS to
perform well and to give the organization the most benefit.
Incorrect Incorrect. Thorough database planning and design is important for a DBMS to
perform well and to give the organization the most benefit.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.03 - Explain the importance of database design
TOPICS: Why database design is important
KEYWORDS: Bloom's: Understand
,6. 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: True
FEEDBACK: Correct Correct. It is true that 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.
Incorrect Incorrect. It is true that 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.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.05 - Understand flaws in file system data management
TOPICS: Problems with File System Data Processing
KEYWORDS: Bloom's: Remember
7. Data redundancy exists when data is duplicated and stored unnecessarily at different places.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. Data redundancy exists when data is duplicated and stored unnecessarily
at different places.
Incorrect Incorrect. Data redundancy exists when data is duplicated and stored
unnecessarily at different places.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.06 - Outline the main components of the database system
TOPICS: Database System
KEYWORDS: Bloom's: Remember
8. One of the advantages of a database system over previous data management approaches is reduced costs.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. Database systems require sophisticated hardware and software and highly
skilled personnel. This increases costs.
, Incorrect Incorrect. Database systems require sophisticated hardware and software and
highly skilled personnel. This increases costs.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.07 - Describe the main functions of a database management system
(DBMS)
TOPICS: Database Systems
KEYWORDS: Bloom's: Understand
9. The term database system refers to an organization of components that define and regulate the collection,
storage, management, and use of data within a database environment.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. Database system refers to an organization of components that define and
regulate the collection, storage, management, and use of data within a database
environment.
Incorrect Incorrect. Database system refers to an organization of components that define
and regulate the collection, storage, management, and use of data within a
database environment.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.07 - Describe the main functions of a database management system
(DBMS)
TOPICS: Database Systems
KEYWORDS: Bloom's: Remember
10. It is unnecessary for the database designer to determine which data to enter into the database and how to
organize that data in the database management system.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. It is vital for the database designer to determine which data to enter into the
database and how to organize that data.
Incorrect Incorrect. It is vital for the database designer to determine which data to enter into the
database and how to organize that data.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
DATABASE SYSTEMS DESIGN
IMPLEMENTATION & MANAGEMENT
14TH EDITION
CHAPTER 01 DATABASE MODELS
1. Data is the result of interpreting facts to reveal meaning.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. Data is the result of processing raw facts to reveal their meaning.
Incorrect Incorrect. Data is the result of processing raw facts to reveal their meaning.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.01 - Define the difference between data and information
TOPICS: Data versus Information
KEYWORDS: Bloom's: Understand
2. A data warehouse can store data derived from many sources.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. The data warehouse stores historical data obtained from many sources.
Incorrect Incorrect. The data warehouse stores historical data obtained from many sources.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.02 - Describe what a database is, the various types of databases, and
why they are valuable assets for decision making
TOPICS: Introducing the Database
KEYWORDS: Bloom's: Remember
3. Unstructured data is data that exists in the format in which it was collected (raw state). While Structured data
is the result of formatting unstructured data to enable storage, use, and generation of information.
a. True
b. False
,ANSWER: True
FEEDBACK: Correct Correct. Unstructured data is in its raw state while structured data is formatted to
enable storage and generation of meaningful information.
Incorrect Incorrect. Unstructured data is in its raw state while structured data is formatted to
enable storage and generation of meaningful information.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.02 - Describe what a database is, the various types of databases, and
why they are valuable assets for decision making
TOPICS: Data versus Information
KEYWORDS: Bloom's: Remember
4. A good Database Management System (DBMS) will perform well even with a badly designed database.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. A well designed database is essential for a DBMS to perform well.
Incorrect Incorrect. A well designed database is essential for a DBMS to perform well.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.03 - Explain the importance of database design
TOPICS: Why database design is important
KEYWORDS: Bloom's: Understand
5. Thorough database planning and design is important to ensure that data is properly used to give the
organization the most benefit.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. Thorough database planning and design is important for a DBMS to
perform well and to give the organization the most benefit.
Incorrect Incorrect. Thorough database planning and design is important for a DBMS to
perform well and to give the organization the most benefit.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.03 - Explain the importance of database design
TOPICS: Why database design is important
KEYWORDS: Bloom's: Understand
,6. 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: True
FEEDBACK: Correct Correct. It is true that 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.
Incorrect Incorrect. It is true that 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.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.05 - Understand flaws in file system data management
TOPICS: Problems with File System Data Processing
KEYWORDS: Bloom's: Remember
7. Data redundancy exists when data is duplicated and stored unnecessarily at different places.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. Data redundancy exists when data is duplicated and stored unnecessarily
at different places.
Incorrect Incorrect. Data redundancy exists when data is duplicated and stored
unnecessarily at different places.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.06 - Outline the main components of the database system
TOPICS: Database System
KEYWORDS: Bloom's: Remember
8. One of the advantages of a database system over previous data management approaches is reduced costs.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. Database systems require sophisticated hardware and software and highly
skilled personnel. This increases costs.
, Incorrect Incorrect. Database systems require sophisticated hardware and software and
highly skilled personnel. This increases costs.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.07 - Describe the main functions of a database management system
(DBMS)
TOPICS: Database Systems
KEYWORDS: Bloom's: Understand
9. The term database system refers to an organization of components that define and regulate the collection,
storage, management, and use of data within a database environment.
a. True
b. False
ANSWER: True
FEEDBACK: Correct Correct. Database system refers to an organization of components that define and
regulate the collection, storage, management, and use of data within a database
environment.
Incorrect Incorrect. Database system refers to an organization of components that define
and regulate the collection, storage, management, and use of data within a
database environment.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: CORMO.DBS14e.23.01.07 - Describe the main functions of a database management system
(DBMS)
TOPICS: Database Systems
KEYWORDS: Bloom's: Remember
10. It is unnecessary for the database designer to determine which data to enter into the database and how to
organize that data in the database management system.
a. True
b. False
ANSWER: False
FEEDBACK: Correct Correct. It is vital for the database designer to determine which data to enter into the
database and how to organize that data.
Incorrect Incorrect. It is vital for the database designer to determine which data to enter into the
database and how to organize that data.
POINTS: 1
QUESTION TYPE: True / False
HAS VARIABLES: False
