Chapter 01: Database Systems
True / False
DATABASE SYSTEMS
1. Data and information are essentially the same thing.
a. True
b. False
DESIGN, IMPLEMENTATION, & MANAGEMENT
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
CARLOS CORONEL STEVEN MORRIS 13TH EDIMON 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 Chapter 01: Database Systems
ANSWER: True ANSWER: False
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
7. The only way to access the data in a database is through the DBMS. 12. A data warehouse can store data derived from many sources.
a. True a. True
b. False b. False
ANSWER: True ANSWER: True
DIFFICULTY: Moderate DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
8. Database programming languages receive all application requests and translate them into the complex operations 13. Structure is based on the type of processing to be performed on the data.
required to fulfill those requests. a. True
a. True b. False
b. False ANSWER: True
ANSWER: False DIFFICULTY: Moderate
DIFFICULTY: Moderate REFERENCES: 1-3b Types of Databases
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
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making
valuable assets for decision making
14. Corporations use only structured data.
9. The DBMS reveals much of the database’s internal complexity to the application programs and users. a. True
a. True b. False
b. False ANSWER: False
ANSWER: False DIFFICULTY: Moderate
DIFFICULTY: Moderate REFERENCES: 1-3b Types of Databases
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
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making
valuable assets for decision making
15. Field refers to a collection of related records.
10. One disadvantage of the DBMS is that it increases the risk of data security breaches. a. True
a. True b. False
b. False ANSWER: False
ANSWER: False DIFFICULTY: Easy
DIFFICULTY: Easy REFERENCES: 1-5b Computerized File Systems
REFERENCES: 1-3a Role and Advantages of the DBMS LEARNING OBJECTIVES: 01.04 - See how modern databases evolved from file systems
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making 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.
11. An operational database is sometimes referred to as an enterprise database. a. True
a. True b. False
b. False ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 2 Copyright Cengage Learning. Powered by Cognero. Page 3
,Chapter 01: Database Systems Chapter 01: Database Systems
DIFFICULTY: Moderate REFERENCES: 1-2 Data versus Information
REFERENCES: 1-6a Structural and Data Dependence LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
22. _____ is the body of information and facts about a specific subject.
17. One disadvantage of a database system over previous data management approaches is increased costs. a. Validation b. A format
a. True c. Knowledge d. A database
b. False ANSWER: c
ANSWER: True DIFFICULTY: Easy
DIFFICULTY: Easy REFERENCES: 1-2 Data versus Information
REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
23. Accurate, relevant, and timely information is the key to ____.
18. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world a. data management b. good decision making
events and conditions. c. knowledge d. understanding
a. True ANSWER: b
b. False DIFFICULTY: Moderate
ANSWER: False REFERENCES: 1-2 Data versus Information
DIFFICULTY: Easy LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
REFERENCES: 1-6b Data Redundancy
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management 24. End-user data is _____.
a. knowledge about the end users b. raw facts of interest to the end user
19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches. c. information about a specific subject d. accurate, relevant and timely information
a. True ANSWER: b
b. False DIFFICULTY: Easy
ANSWER: False REFERENCES: 1-3 Introducing the Database
DIFFICULTY: Moderate LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
REFERENCES: 1-7c Managing the Database System: A Shift in Focus valuable assets for decision making
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system
25. _____ provide a description of the data characteristics and the set of relationships that link the data found within the
20. One advantage of a database system over previous data management approaches is that the database system is database.
considerably less complex. a. Queries b. End-user data
a. True c. Metadata d. Schemas
b. False ANSWER: c
ANSWER: False DIFFICULTY: Easy
DIFFICULTY: Moderate REFERENCES: 1-3 Introducing the Database
REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system valuable assets for decision making
Multiple Choice 26. _____ serve as the intermediary between the user and the database.
a. DBMSs b. Metadata
21. _____ is the result of revealing the meaning of raw facts. c. End-user data d. Programming languages
a. End-user data b. An encoded sample ANSWER: a
c. An encrypted bit d. Information DIFFICULTY: Easy
ANSWER: d REFERENCES: 1-3a Role and Advantages of the DBMS
DIFFICULTY: Easy LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making
Copyright Cengage Learning. Powered by Cognero. Page 4 Copyright Cengage Learning. Powered by Cognero. Page 5
, Chapter 01: Database Systems Chapter 01: Database Systems
32. A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department
27. The database structure in a DBMS is stored as a _____. within an organization.
a. single file b. collection of files a. desktop b. workgroup
c. set of key/value pairs d. collection of queries c. enterprise d. transactional
ANSWER: b ANSWER: b
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
28. A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. 33. A workgroup database is a(n) _____ database.
a. query b. operating system a. single-user b. multiuser
c. database management system d. application c. desktop d. distributed
ANSWER: d ANSWER: b
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
29. _____ exists when different versions of the same data appear in different places. 34. A desktop database is a _____ database.
a. Data inconsistency b. Poor data security a. single-user b. multiuser
c. Structural dependence d. Conceptual dependence c. workgroup d. distributed
ANSWER: a ANSWER: a
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
30. The response of the DBMS to a query is the ___________ 35. A data warehouse contains historical data obtained from the _____.
a. ad hoc query b. ad hoc response a. operational databases b. desktop database
c. query result set d. integrated view of the data c. enterprise databases d. workgroup databases
ANSWER: c ANSWER: a
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
31. A(n) _____ database is used by an organization and supports many users across many departments. 36. _____ data exist in the format in which they were collected.
a. desktop b. workgroup a. Structured b. Semistructured
c. enterprise d. transactional c. Unstructured d. Historical
ANSWER: c ANSWER: c
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
Copyright Cengage Learning. Powered by Cognero. Page 6 Copyright Cengage Learning. Powered by Cognero. Page 7
True / False
DATABASE SYSTEMS
1. Data and information are essentially the same thing.
a. True
b. False
DESIGN, IMPLEMENTATION, & MANAGEMENT
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
CARLOS CORONEL STEVEN MORRIS 13TH EDIMON 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 Chapter 01: Database Systems
ANSWER: True ANSWER: False
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
7. The only way to access the data in a database is through the DBMS. 12. A data warehouse can store data derived from many sources.
a. True a. True
b. False b. False
ANSWER: True ANSWER: True
DIFFICULTY: Moderate DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
8. Database programming languages receive all application requests and translate them into the complex operations 13. Structure is based on the type of processing to be performed on the data.
required to fulfill those requests. a. True
a. True b. False
b. False ANSWER: True
ANSWER: False DIFFICULTY: Moderate
DIFFICULTY: Moderate REFERENCES: 1-3b Types of Databases
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
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making
valuable assets for decision making
14. Corporations use only structured data.
9. The DBMS reveals much of the database’s internal complexity to the application programs and users. a. True
a. True b. False
b. False ANSWER: False
ANSWER: False DIFFICULTY: Moderate
DIFFICULTY: Moderate REFERENCES: 1-3b Types of Databases
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
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making
valuable assets for decision making
15. Field refers to a collection of related records.
10. One disadvantage of the DBMS is that it increases the risk of data security breaches. a. True
a. True b. False
b. False ANSWER: False
ANSWER: False DIFFICULTY: Easy
DIFFICULTY: Easy REFERENCES: 1-5b Computerized File Systems
REFERENCES: 1-3a Role and Advantages of the DBMS LEARNING OBJECTIVES: 01.04 - See how modern databases evolved from file systems
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making 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.
11. An operational database is sometimes referred to as an enterprise database. a. True
a. True b. False
b. False ANSWER: False
Copyright Cengage Learning. Powered by Cognero. Page 2 Copyright Cengage Learning. Powered by Cognero. Page 3
,Chapter 01: Database Systems Chapter 01: Database Systems
DIFFICULTY: Moderate REFERENCES: 1-2 Data versus Information
REFERENCES: 1-6a Structural and Data Dependence LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
22. _____ is the body of information and facts about a specific subject.
17. One disadvantage of a database system over previous data management approaches is increased costs. a. Validation b. A format
a. True c. Knowledge d. A database
b. False ANSWER: c
ANSWER: True DIFFICULTY: Easy
DIFFICULTY: Easy REFERENCES: 1-2 Data versus Information
REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management
23. Accurate, relevant, and timely information is the key to ____.
18. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world a. data management b. good decision making
events and conditions. c. knowledge d. understanding
a. True ANSWER: b
b. False DIFFICULTY: Moderate
ANSWER: False REFERENCES: 1-2 Data versus Information
DIFFICULTY: Easy LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
REFERENCES: 1-6b Data Redundancy
LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management 24. End-user data is _____.
a. knowledge about the end users b. raw facts of interest to the end user
19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches. c. information about a specific subject d. accurate, relevant and timely information
a. True ANSWER: b
b. False DIFFICULTY: Easy
ANSWER: False REFERENCES: 1-3 Introducing the Database
DIFFICULTY: Moderate LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
REFERENCES: 1-7c Managing the Database System: A Shift in Focus valuable assets for decision making
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system
25. _____ provide a description of the data characteristics and the set of relationships that link the data found within the
20. One advantage of a database system over previous data management approaches is that the database system is database.
considerably less complex. a. Queries b. End-user data
a. True c. Metadata d. Schemas
b. False ANSWER: c
ANSWER: False DIFFICULTY: Easy
DIFFICULTY: Moderate REFERENCES: 1-3 Introducing the Database
REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system valuable assets for decision making
Multiple Choice 26. _____ serve as the intermediary between the user and the database.
a. DBMSs b. Metadata
21. _____ is the result of revealing the meaning of raw facts. c. End-user data d. Programming languages
a. End-user data b. An encoded sample ANSWER: a
c. An encrypted bit d. Information DIFFICULTY: Easy
ANSWER: d REFERENCES: 1-3a Role and Advantages of the DBMS
DIFFICULTY: Easy LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making
Copyright Cengage Learning. Powered by Cognero. Page 4 Copyright Cengage Learning. Powered by Cognero. Page 5
, Chapter 01: Database Systems Chapter 01: Database Systems
32. A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department
27. The database structure in a DBMS is stored as a _____. within an organization.
a. single file b. collection of files a. desktop b. workgroup
c. set of key/value pairs d. collection of queries c. enterprise d. transactional
ANSWER: b ANSWER: b
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
28. A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. 33. A workgroup database is a(n) _____ database.
a. query b. operating system a. single-user b. multiuser
c. database management system d. application c. desktop d. distributed
ANSWER: d ANSWER: b
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
29. _____ exists when different versions of the same data appear in different places. 34. A desktop database is a _____ database.
a. Data inconsistency b. Poor data security a. single-user b. multiuser
c. Structural dependence d. Conceptual dependence c. workgroup d. distributed
ANSWER: a ANSWER: a
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
30. The response of the DBMS to a query is the ___________ 35. A data warehouse contains historical data obtained from the _____.
a. ad hoc query b. ad hoc response a. operational databases b. desktop database
c. query result set d. integrated view of the data c. enterprise databases d. workgroup databases
ANSWER: c ANSWER: a
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3a Role and Advantages of the DBMS REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
31. A(n) _____ database is used by an organization and supports many users across many departments. 36. _____ data exist in the format in which they were collected.
a. desktop b. workgroup a. Structured b. Semistructured
c. enterprise d. transactional c. Unstructured d. Historical
ANSWER: c ANSWER: c
DIFFICULTY: Easy DIFFICULTY: Easy
REFERENCES: 1-3b Types of Databases REFERENCES: 1-3b Types of Databases
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are
valuable assets for decision making valuable assets for decision making
Copyright Cengage Learning. Powered by Cognero. Page 6 Copyright Cengage Learning. Powered by Cognero. Page 7
