Database Concepts 9th edition by David Kroenke test bank

Database Concepts, 9e (Kroenke)
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
 
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
 

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