,Test Bank For
Database Concepts, 10th edition David M. Kroenke, David J. Auer,
Scott L. Vandenberg, Robert C. Yoder
Chapter 1-7 With Extension (a b c)
Chapter 1 Getting Started
1) To be as efficient as possible, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 26
AACSB: Information Technology
Chapter Obj.: Introduce data warehouses and business intelligence (BI) systems.
Classification: Concept
2) Although users use database systems, they are not considered part of a database system.
Answer: FALSE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
3) A database is a set of one or more computer programs that serve as an intermediary between the
users and the database management system (DBMS).
Answer: FALSE
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
4) A relational database can be defined as a self-describing collection of related tables.
Answer: TRUE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
5) A database is self-describing because the user maintains a record of the database structure
outside the database itself.
Answer: FALSE
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
6) Metadata is the user data stored in the database.
1
Copyright © 2024 Pearson Education, Inc.
,Answer: FALSE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
7) Currently, organizations use their own hardware.
Answer: FALSE
Diff: 1 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
8) The DBMS is used to create the database itself.
Answer: TRUE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
9) Referential integrity constraints must be enforced by the application program.
Answer: FALSE
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
10) Application programs are responsible for creating, maintaining, and supporting database
backup and recovery systems.
Answer: FALSE
Diff: 2 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
11) A relational database stores data in the form of lists.
Answer: FALSE
Diff: 1 Page Ref: 11
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
12) Usually, a database table containing both rows and columns is designed to store data for
exactly two themes.
Answer: FALSE
Diff: 2 Page Ref: 11
AACSB: Information Technology
2
Copyright © 2024 Pearson Education, Inc.
, Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
13) MySQL Community Server 8.0 edition is a widely used standard, full-strength edition of
MySQL, which can be downloaded for free and which may be used in production environments.
Answer: TRUE
Diff: 2 Page Ref: 25
AACSB: Information Technology
Chapter Obj.: Understand the difference between personal and enterprise-class database systems.
Classification: Concept
14) SQL stands for Structural Question Language.
Answer: FALSE
Diff: 1 Page Ref: 16
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
15) Relational database tables are commonly combined, queried, and processed using Structured
Query Language (SQL).
Answer: TRUE
Diff: 1 Page Ref: 16
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
16) The DBMS receives data update requests from the application program.
Answer: TRUE
Diff: 3 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
17) In the general division of labor between database applications and the DBMS, the processing
of forms is considered a DBMS task.
Answer: FALSE
Diff: 3 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
18) Database applications that hide the underlying database technology are useful only for
personal database applications.
Answer: TRUE
Diff: 3 Page Ref: 23
AACSB: Information Technology
Chapter Obj.: Understand the difference between personal and enterprise-class database systems.
Classification: Concept
3
Copyright © 2024 Pearson Education, Inc.
Database Concepts, 10th edition David M. Kroenke, David J. Auer,
Scott L. Vandenberg, Robert C. Yoder
Chapter 1-7 With Extension (a b c)
Chapter 1 Getting Started
1) To be as efficient as possible, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 26
AACSB: Information Technology
Chapter Obj.: Introduce data warehouses and business intelligence (BI) systems.
Classification: Concept
2) Although users use database systems, they are not considered part of a database system.
Answer: FALSE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
3) A database is a set of one or more computer programs that serve as an intermediary between the
users and the database management system (DBMS).
Answer: FALSE
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
4) A relational database can be defined as a self-describing collection of related tables.
Answer: TRUE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
5) A database is self-describing because the user maintains a record of the database structure
outside the database itself.
Answer: FALSE
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
6) Metadata is the user data stored in the database.
1
Copyright © 2024 Pearson Education, Inc.
,Answer: FALSE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
7) Currently, organizations use their own hardware.
Answer: FALSE
Diff: 1 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
8) The DBMS is used to create the database itself.
Answer: TRUE
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
9) Referential integrity constraints must be enforced by the application program.
Answer: FALSE
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
10) Application programs are responsible for creating, maintaining, and supporting database
backup and recovery systems.
Answer: FALSE
Diff: 2 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
11) A relational database stores data in the form of lists.
Answer: FALSE
Diff: 1 Page Ref: 11
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
12) Usually, a database table containing both rows and columns is designed to store data for
exactly two themes.
Answer: FALSE
Diff: 2 Page Ref: 11
AACSB: Information Technology
2
Copyright © 2024 Pearson Education, Inc.
, Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
13) MySQL Community Server 8.0 edition is a widely used standard, full-strength edition of
MySQL, which can be downloaded for free and which may be used in production environments.
Answer: TRUE
Diff: 2 Page Ref: 25
AACSB: Information Technology
Chapter Obj.: Understand the difference between personal and enterprise-class database systems.
Classification: Concept
14) SQL stands for Structural Question Language.
Answer: FALSE
Diff: 1 Page Ref: 16
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
15) Relational database tables are commonly combined, queried, and processed using Structured
Query Language (SQL).
Answer: TRUE
Diff: 1 Page Ref: 16
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
16) The DBMS receives data update requests from the application program.
Answer: TRUE
Diff: 3 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
17) In the general division of labor between database applications and the DBMS, the processing
of forms is considered a DBMS task.
Answer: FALSE
Diff: 3 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
18) Database applications that hide the underlying database technology are useful only for
personal database applications.
Answer: TRUE
Diff: 3 Page Ref: 23
AACSB: Information Technology
Chapter Obj.: Understand the difference between personal and enterprise-class database systems.
Classification: Concept
3
Copyright © 2024 Pearson Education, Inc.
