Test Bank for Database Concepts, 10th edition by David Kroenke, Chapter 1-7 | All Chapters

TEST BANK
Database Concepts, 10th edition
by David Kroenke, David Auer
LU
XE
LI
BR
AR
Y

, TABLE OF CONTENT

PART 1: DATABASE FUNDAMENTALS

1.Getting Started

2.The Relational Model

3.Structured Query Language

PART 2: DATABASE DESIGN

4.Data Modeling and the Entity-Relationship Model
LU
5.Database Design

PART 3: DATABASE MANAGEMENT

6.Database Administration and the Cloud
XE
7.Business Intelligence Systems, Data Warehouses, and Big Data

ONLINE EXTENSIONS

A.Working with MySQL
LI
B.Advanced SQL

C.Advanced Business Intelligence, Nonrelational Databases, and the Cloud
BR
AR
Y

, kjhgfdsa All Chapters Included


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
LU
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
XE
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
LI
Chapter Obj.: Know the components of a database system.
Classification: Concept
BR
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
AR
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.
Y
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
LU
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
XE
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
LI
backup and recovery systems.
Answer: FALSE
Diff: 2 Page Ref: 20
BR
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
AR
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.
Y
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