.png){kind=logo}
1 Copyright © 2020 Pearson Education, Inc.Chapter 1 Getting Started
1) For efficiency purposes, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 29
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: 18
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 serves as an intermediary between the users and the database management system (DBMS).
Answer: FALSE
Diff: 2 Page Ref: 18
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: 18
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.
Answer: FALSE
Diff: 1 Page Ref: 19
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database
Classification: Concept
(Database Concepts, 9e David Kroenke, David Auer, Scott Vandenberg, Robert Yoder) (Test Bank all Chapter) 1 / 4
2 Copyright © 2020 Pearson Education, Inc.7) Most organizations create and use their own database management system (DBMS) products.
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: 20
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: 20
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: 10
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: 10
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
- / 4
3 Copyright © 2020 Pearson Education, Inc.13) By separating data into tables containing data on only one theme each, making changes to the data is simplified.
Answer: TRUE
Diff: 2 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
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: 21
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: 21
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
18) In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.
Answer: TRUE
Diff: 3 Page Ref: 23
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
- / 4
4 Copyright © 2020 Pearson Education, Inc.19) In the general division of labor between database applications and the DBMS, the application program formats the results of a query into a report.
Answer: TRUE
Diff: 3 Page Ref: 22
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
20) Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.
Answer: FALSE
Diff: 2 Page Ref: 23
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
21) There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects.
Answer: FALSE
Diff: 1 Page Ref: 24
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
22) Microsoft Access 2019 is a personal database that combines a DBMS with an application generator.
Answer: TRUE
Diff: 1 Page Ref: 32
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
23) The Microsoft Access 2019 application generator provides the ability to create and store forms, reports, and queries.
Answer: TRUE
Diff: 2 Page Ref: 32
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
24) Microsoft Access 2019 databases are stored using the file extension .accdb.
Answer: TRUE
Diff: 2 Page Ref: 34
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
- / 4
.png)