TEST BANK
Database Systems: Design, Implementation, & Management | 12th
Edition
by Carlos Coronel, Steven Morris
LU
XE
LI
BR
AR
Y
, Table of content
Part 1. Database Concepts
Chapter 1. Database Systems
Chapter 2. Data Models
Part 2. Design Concepts
Chapter 3. The Relational Database Model
Chapter 4. Entity Relationship (ER) Modeling
Chapter 5. Advanced Data Modeling
LU
Chapter 6. Normalization of Database Tables
Part 3. Advanced Design and Implementation
Chapter 7. Introduction to Structured Query Language (SQL)
Chapter 8. Advanced SQL
XE
Chapter 9. Database Design
Part 4. Advanced Database Concepts
Chapter 10. Transaction Management and Concurrency Control
Chapter 11. Database Performance Tuning and Query Optimization
LI
Chapter 12. Distributed Database Management Systems
Chapter 13. Business Intelligence and Data Warehouses
BR
Chapter 14. Big Data Analytics and NoSQL
Part 5. Databases and the Internet
Chapter 15. Database Connectivity and Web Technologies
Part 6. Database Administration
AR
Chapter 16. Database Administration and Security
Y
,CHAPTER 1: DATABASE SYSTEMS
1. Data and information are essentially the same thing.
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.4
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Data versus Information
LU
2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.4
XE
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Data versus Information
3. Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
LI
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.4
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
BR
KEY: Bloom's: Knowledge TOP: Data versus 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
AR
PTS: 1 DIF: Difficulty: Moderate REF: p.4
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Data versus Information
5. Data constitute the building blocks of information.
a. True
b. False
Y
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.4
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Data versus Information
6. Metadata describe the data characteristics and the set of relationships that links the data found within the
database.
, a. True
b. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.6
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Introducing the Database
7. The only way to access the data in a database is through the DBMS.
a. True
b. False
LU
ANSWER: True
PTS: 1 DIF: Difficulty: Moderate REF: p.6
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Introducing the Database
8. Database programming languages receive all application requests and translate them into the complex operations
XE
required to fulfill those requests.
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Moderate REF: p.6
LI
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Introducing the Database
9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
BR
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Moderate REF: p.6
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Introducing the Database
AR
10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.7
Y
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Introducing the Database
11. An operational database is sometimes referred to as an enterprise database.
a. True
b. False
Database Systems: Design, Implementation, & Management | 12th
Edition
by Carlos Coronel, Steven Morris
LU
XE
LI
BR
AR
Y
, Table of content
Part 1. Database Concepts
Chapter 1. Database Systems
Chapter 2. Data Models
Part 2. Design Concepts
Chapter 3. The Relational Database Model
Chapter 4. Entity Relationship (ER) Modeling
Chapter 5. Advanced Data Modeling
LU
Chapter 6. Normalization of Database Tables
Part 3. Advanced Design and Implementation
Chapter 7. Introduction to Structured Query Language (SQL)
Chapter 8. Advanced SQL
XE
Chapter 9. Database Design
Part 4. Advanced Database Concepts
Chapter 10. Transaction Management and Concurrency Control
Chapter 11. Database Performance Tuning and Query Optimization
LI
Chapter 12. Distributed Database Management Systems
Chapter 13. Business Intelligence and Data Warehouses
BR
Chapter 14. Big Data Analytics and NoSQL
Part 5. Databases and the Internet
Chapter 15. Database Connectivity and Web Technologies
Part 6. Database Administration
AR
Chapter 16. Database Administration and Security
Y
,CHAPTER 1: DATABASE SYSTEMS
1. Data and information are essentially the same thing.
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.4
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Data versus Information
LU
2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.4
XE
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Data versus Information
3. Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
LI
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.4
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
BR
KEY: Bloom's: Knowledge TOP: Data versus 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
AR
PTS: 1 DIF: Difficulty: Moderate REF: p.4
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Data versus Information
5. Data constitute the building blocks of information.
a. True
b. False
Y
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.4
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Data versus Information
6. Metadata describe the data characteristics and the set of relationships that links the data found within the
database.
, a. True
b. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.6
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Introducing the Database
7. The only way to access the data in a database is through the DBMS.
a. True
b. False
LU
ANSWER: True
PTS: 1 DIF: Difficulty: Moderate REF: p.6
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Introducing the Database
8. Database programming languages receive all application requests and translate them into the complex operations
XE
required to fulfill those requests.
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Moderate REF: p.6
LI
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Introducing the Database
9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
BR
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Moderate REF: p.6
NAT: BUSPROG: Analytic STATE: DISC: Information Technologies
KEY: Bloom's: Comprehension TOP: Introducing the Database
AR
10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
a. True
b. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.7
Y
NAT: BUSPROG: Technology STATE: DISC: Information Technologies
KEY: Bloom's: Knowledge TOP: Introducing the Database
11. An operational database is sometimes referred to as an enterprise database.
a. True
b. False
