Database Concepts, 10e (Kroenke) All Answers Included
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.
N
Answer: FALSE
Diff: 1 Page Ref: 17
AACSB: Information Technology
U
Chapter Obj.: Know the components of a database system.
Classification: Concept
R
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
SE
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
D
Diff: 1 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
O
Classification: Concept
5) A database is self-describing because the user maintains a record of the database structure
outside the database itself.
C
Answer: FALSE
Diff: 2 Page Ref: 18
AACSB: Information Technology
S
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: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
lkjhgfds
, kjhgfdsa
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
N
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
U
9) Referential integrity constraints must be enforced by the application program.
Answer: FALSE
Diff: 2 Page Ref: 19
R
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
SE
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).
D
Classification: Concept
11) A relational database stores data in the form of lists.
O
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.
C
Classification: Concept
12) Usually, a database table containing both rows and columns is designed to store data for
S
exactly two themes.
Answer: FALSE
Diff: 2 Page Ref: 11
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
Classification: Concept
lkjhgfds
, kjhgfdsa
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
N
Diff: 1 Page Ref: 16
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists.
U
Classification: Concept
15) Relational database tables are commonly combined, queried, and processed using Structured
R
Query Language (SQL).
Answer: TRUE
Diff: 1 Page Ref: 16
AACSB: Information Technology
SE
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
D
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
O
17) In the general division of labor between database applications and the DBMS, the processing
of forms is considered a DBMS task.
Answer: FALSE
C
Diff: 3 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
S
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.
, kjhgfdsa
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: 21
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.
N
Answer: FALSE
Diff: 2 Page Ref: 22
AACSB: Information Technology
U
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
R
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
SE
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
22) Microsoft Access is a personal database that combines a DBMS with an application
generator.
D
Answer: TRUE
Diff: 1 Page Ref: 43
AACSB: Information Technology
O
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
23) The Microsoft Access application generator provides the ability to create and store forms,
C
reports, and queries.
Answer: TRUE
Diff: 2 Page Ref: 43
S
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
24) Microsoft Access databases are stored using the file extension .accdb.
Answer: TRUE
Diff: 2 Page Ref: 48
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
4
Copyright © 2024 Pearson Education, Inc.