Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
TEST BANK
Database Concepts
David M. Kroenke; David J. Auer; Scott L. Vandenberg; Robert C. Yoder
10th Edition
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
Table of Contents
PART 1: DATABASE FUNDAMENTALS
Chapter 1. Getting Started
Chapter 2. The Relational Model
Chapter 3. Structured Query Language
PART 2: DATABASE DESIGN
Chapter 4. Data Modeling and the Entity-Relationship Model
Chapter 5. Database Design
PART 3: DATABASE MANAGEMENT
Chapter 6. Database Administration and the Cloud
Chapter 7. Business Intelligence Systems, Data Warehouses, and Big Data
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
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.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
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.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
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 (Kroenke, 2024) -Test Bank
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.
Answer: FALSE
Diff: 2 Page Ref: 22
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 is a personal database that combines a DBMS with an application generator.
Answer: TRUE
Diff: 1 Page Ref: 43
AACSB: Information Technology
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,
reports, and queries.
Answer: TRUE
Diff: 2 Page Ref: 43
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.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
25) Microsoft Access uses the Access 2003 .mdb file format as the default file format for database
files.
Answer: FALSE
Diff: 2 Page Ref: 48
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
26) Microsoft Access uses the AutoNumber data type to create surrogate keys.
Answer: TRUE
Diff: 2 Page Ref: 56
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
27) Web 2.0 Web sites were popular due to their static, unchanging content.
Answer: FALSE
Diff: 1 Page Ref: 5
AACSB: Information Technology
Chapter Obj.: Understand the importance of databases in Internet Web applications and mobile
apps.
Classification: Concept
28) Theoretically, databases could store instances in columns and characteristics in rows, instead
of the other way around.
Answer: TRUE
Diff: 1 Page Ref: 12
AACSB: Information Technology
Chapter Obj.: Understand the nature and characteristics of databases.
Classification: Concept
29) A possible problem with keeping data in lists is that if you delete a row of data from a list, you
may also delete some data items that you want to keep.
Answer: TRUE
Diff: 1 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
30) An advantage of keeping data in lists is that if you update a data value in one row of data in a
list, other occurrences of the same data item in other rows will be automatically updated as well.
Answer: FALSE
Diff: 1 Page Ref: 9
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
5
Copyright © 2024 Pearson Education, Inc.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
31) An advantage of keeping data in lists is that if you add a row of data to the list, you will never
have null values occurring for any data item in the row.
Answer: FALSE
Diff: 1 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
32) One problem with storing duplicated data is the potential for inconsistent values.
Answer: TRUE
Diff: 2 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
33) The purpose of a database is to help people keep track of things.
Answer: TRUE
Diff: 1 Page Ref: 8
AACSB: Information Technology
Chapter Obj.: Understand the reasons for using a database.
Classification: Concept
34) Regarding Big Data, what does the term NoSQL really mean?
A) No SQL used
B) NortonOS Query Language
C) Notational Query Language
D) Nonrelational Database
Answer: D
Diff: 2 Page Ref: 27
AACSB: Information Technology
Chapter Obj.: Introduce Big Data and cloud computing.
Classification: Concept
35) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
C) Web user interface
D) Back-end Database Management System
Answer: C
Diff: 1 Page Ref: 26
AACSB: Information Technology
Chapter Obj.: Introduce Web database applications.
Classification: Concept
6
Copyright © 2024 Pearson Education, Inc.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
36) Which of the following is not a basic component of a database system?
A) Database
B) User
C) ERD
D) DBMS
Answer: C
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
37) A relational database is ________.
A) a self-describing collection of related tables
B) a collection of forms and reports that support a given purpose
C) a library of queries and data files for querying
D) a set of applications and the data sets for those applications
Answer: A
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
38) The component of a database that makes it self-describing is the ________.
A) related tables
B) applications
C) metadata
D) data set
Answer: C
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
39) Which of the following would not be an example of database metadata?
A) Queries against records in the database tables
B) Properties of tables in a database
C) Names of columns in a database and their associated tables
D) Properties of columns
Answer: A
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
7
Copyright © 2024 Pearson Education, Inc.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
40) The creation of a database and its tables is a function of which component of the database
system?
A) Users
B) Application
C) DBMS
D) Database
Answer: C
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
41) Which of the following is a function of the DBMS in a database system?
A) Create and transmit queries
B) Control applications
C) Create and process forms
D) Perform backup and recovery
Answer: D
Diff: 3 Page Ref: 19
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
42) Microsoft SQL Server is an example of a ________.
A) database
B) database management system
C) data manipulation system
D) table
Answer: B
Diff: 1 Page Ref: 25
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
43) Microsoft Access is a personal database system. A personal database system is characterized
by ________.
A) the DBMS removing the metadata from the database
B) the DBMS product taking the role of the DBMS and the database application generator
C) the database being stored inside the DBMS
D) the DBMS product being limited to a maximum of ten tables in any given database
Answer: B
Diff: 1 Page Ref: 43
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
8
Copyright © 2024 Pearson Education, Inc.
TEST BANK
Database Concepts
David M. Kroenke; David J. Auer; Scott L. Vandenberg; Robert C. Yoder
10th Edition
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
Table of Contents
PART 1: DATABASE FUNDAMENTALS
Chapter 1. Getting Started
Chapter 2. The Relational Model
Chapter 3. Structured Query Language
PART 2: DATABASE DESIGN
Chapter 4. Data Modeling and the Entity-Relationship Model
Chapter 5. Database Design
PART 3: DATABASE MANAGEMENT
Chapter 6. Database Administration and the Cloud
Chapter 7. Business Intelligence Systems, Data Warehouses, and Big Data
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
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.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
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.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
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 (Kroenke, 2024) -Test Bank
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.
Answer: FALSE
Diff: 2 Page Ref: 22
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 is a personal database that combines a DBMS with an application generator.
Answer: TRUE
Diff: 1 Page Ref: 43
AACSB: Information Technology
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,
reports, and queries.
Answer: TRUE
Diff: 2 Page Ref: 43
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.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
25) Microsoft Access uses the Access 2003 .mdb file format as the default file format for database
files.
Answer: FALSE
Diff: 2 Page Ref: 48
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
26) Microsoft Access uses the AutoNumber data type to create surrogate keys.
Answer: TRUE
Diff: 2 Page Ref: 56
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application.
Classification: Concept
27) Web 2.0 Web sites were popular due to their static, unchanging content.
Answer: FALSE
Diff: 1 Page Ref: 5
AACSB: Information Technology
Chapter Obj.: Understand the importance of databases in Internet Web applications and mobile
apps.
Classification: Concept
28) Theoretically, databases could store instances in columns and characteristics in rows, instead
of the other way around.
Answer: TRUE
Diff: 1 Page Ref: 12
AACSB: Information Technology
Chapter Obj.: Understand the nature and characteristics of databases.
Classification: Concept
29) A possible problem with keeping data in lists is that if you delete a row of data from a list, you
may also delete some data items that you want to keep.
Answer: TRUE
Diff: 1 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
30) An advantage of keeping data in lists is that if you update a data value in one row of data in a
list, other occurrences of the same data item in other rows will be automatically updated as well.
Answer: FALSE
Diff: 1 Page Ref: 9
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
5
Copyright © 2024 Pearson Education, Inc.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
31) An advantage of keeping data in lists is that if you add a row of data to the list, you will never
have null values occurring for any data item in the row.
Answer: FALSE
Diff: 1 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
32) One problem with storing duplicated data is the potential for inconsistent values.
Answer: TRUE
Diff: 2 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists.
Classification: Concept
33) The purpose of a database is to help people keep track of things.
Answer: TRUE
Diff: 1 Page Ref: 8
AACSB: Information Technology
Chapter Obj.: Understand the reasons for using a database.
Classification: Concept
34) Regarding Big Data, what does the term NoSQL really mean?
A) No SQL used
B) NortonOS Query Language
C) Notational Query Language
D) Nonrelational Database
Answer: D
Diff: 2 Page Ref: 27
AACSB: Information Technology
Chapter Obj.: Introduce Big Data and cloud computing.
Classification: Concept
35) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
C) Web user interface
D) Back-end Database Management System
Answer: C
Diff: 1 Page Ref: 26
AACSB: Information Technology
Chapter Obj.: Introduce Web database applications.
Classification: Concept
6
Copyright © 2024 Pearson Education, Inc.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
36) Which of the following is not a basic component of a database system?
A) Database
B) User
C) ERD
D) DBMS
Answer: C
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
37) A relational database is ________.
A) a self-describing collection of related tables
B) a collection of forms and reports that support a given purpose
C) a library of queries and data files for querying
D) a set of applications and the data sets for those applications
Answer: A
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
38) The component of a database that makes it self-describing is the ________.
A) related tables
B) applications
C) metadata
D) data set
Answer: C
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
39) Which of the following would not be an example of database metadata?
A) Queries against records in the database tables
B) Properties of tables in a database
C) Names of columns in a database and their associated tables
D) Properties of columns
Answer: A
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Know the components of a database system.
Classification: Concept
7
Copyright © 2024 Pearson Education, Inc.
, Database Concepts 10th Edition (Kroenke, 2024) -Test Bank
40) The creation of a database and its tables is a function of which component of the database
system?
A) Users
B) Application
C) DBMS
D) Database
Answer: C
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
41) Which of the following is a function of the DBMS in a database system?
A) Create and transmit queries
B) Control applications
C) Create and process forms
D) Perform backup and recovery
Answer: D
Diff: 3 Page Ref: 19
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
42) Microsoft SQL Server is an example of a ________.
A) database
B) database management system
C) data manipulation system
D) table
Answer: B
Diff: 1 Page Ref: 25
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
43) Microsoft Access is a personal database system. A personal database system is characterized
by ________.
A) the DBMS removing the metadata from the database
B) the DBMS product taking the role of the DBMS and the database application generator
C) the database being stored inside the DBMS
D) the DBMS product being limited to a maximum of ten tables in any given database
Answer: B
Diff: 1 Page Ref: 43
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS).
Classification: Concept
8
Copyright © 2024 Pearson Education, Inc.
