Test Bank - Database Processing: Fundamentals, Design, and Implementation, 16th Edition | David M. Kroenke & David J. Auer

Pa
Database Processing, 16e (Kroenke/Auer/Vandenberg)
Chapter 1 Introduction

1) The purpose of a database is to help people keep track of things.
Answer: TRUE
Page Ref: 6




ss
AACSB: Information Technology
Difficulty: Easy
LO: To understand the nature and characteristics of databases
Classification: Concept

2) In a database, each table stores data about a different type of thing.
Answer: TRUE




vi
Page Ref: 6
AACSB: Information Technology
Difficulty: Easy
LO: To understand the nature and characteristics of databases
Classification: Concept

3) Like a spreadsheet, a database table has rows and columns.
Answer: TRUE
Page Ref: 6
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the nature and characteristics of databases
Classification: Concept
be
Answer: FALSE
Page Ref: 7
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the nature and characteristics of databases
Classification: Concept
s
4) In every database, not just the databases discussed in this book, table names are capitalized.




5) A database shows data in tables as well as the relationships among the rows in those tables.
Answer: TRUE
Page Ref: 8
AACSB: Information Technology
Difficulty: Easy
LO: To gain a general understanding of tables and relationships
Classification: Concept




1
Copyright © 2022 Pearson Education, Inc.

, Pa
6) Data is recorded facts and figures; information is knowledge derived from data.
Answer: TRUE
Page Ref: 10
AACSB: Information Technology
Difficulty: Easy
LO: To understand the nature and characteristics of databases




ss
Classification: Concept

7) Databases record data in such a way that they can produce information.
Answer: TRUE
Page Ref: 10
AACSB: Information Technology
Difficulty: Easy




vi
LO: To understand the nature and characteristics of databases
Classification: Concept

8) Enterprise Resource Planning (ERP) is an example of a data mining application.
Answer: FALSE
Page Ref: 11
AACSB: Information Technology
Difficulty: Moderate
LO: To survey some important and interesting database applications
Classification: Concept

be
9) Databases are a key component of e-commerce order entry, billing, shipping, and customer
support.
Answer: TRUE
Page Ref: 11
AACSB: Information Technology
Difficulty: Moderate
LO: To survey some important and interesting database applications
Classification: Concept

10) The largest databases in e-commerce are the order entry databases.
Answer: FALSE
s
Page Ref: 11
AACSB: Information Technology
Difficulty: Difficult
LO: To survey some important and interesting database applications
Classification: Concept




2
Copyright © 2022 Pearson Education, Inc.

, Pa
11) E-commerce companies use Web activity databases to determine which items on a Web page
are popular and successful.
Answer: TRUE
Page Ref: 11
AACSB: Information Technology
Difficulty: Moderate




ss
LO: To understand the importance of databases in Internet Web applications and smartphone
apps
Classification: Concept

12) A surrogate key is a key typically used in place of a foreign key.
Answer: FALSE
Page Ref: 8




vi
AACSB: Information Technology
Difficulty: Easy
LO: To understand the nature and characteristics of databases
Classification: Concept

13) A database system is typically defined as its four components: users, database applications,
the DBMS and the databases.
Answer: TRUE
Page Ref: 12
AACSB: Information Technology
Difficulty: Easy
LO: To understand the nature and characteristics of databases
Classification: Concept
be
14) Databases based on the CODASYL standard are based on the network data model.
Answer: TRUE
Page Ref: 30
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the history and development of database processing
Classification: Concept
s
15) Applications are computer programs used directly by users.
Answer: TRUE
Page Ref: 13
AACSB: Information Technology
Difficulty: Easy
LO: To gain a general understanding of tables and relationships
Classification: Concept




3
Copyright © 2022 Pearson Education, Inc.

, Pa
16) Applications usually write data directly to the database.
Answer: FALSE
Page Ref: 13
AACSB: Information Technology
Difficulty: Easy
LO: To gain a general understanding of tables and relationships




ss
Classification: Concept

17) Sequenced Query Language (SQL) is an internationally recognized standard language that is
understood by all commercial database management system products.
Answer: FALSE
Page Ref: 12
AACSB: Information Technology




vi
Difficulty: Moderate
LO: To gain a general understanding of tables and relationships
Classification: Concept

18) In database systems, indexes are held in the database.
Answer: TRUE
Page Ref: 38
AACSB: Information Technology
Difficulty: Difficult


be
LO: To define the term database and describe what is contained within the database
Classification: Concept

19) A database management system (DBMS) creates, processes and administers databases.
Answer: TRUE
Page Ref: 38
AACSB: Information Technology
Difficulty: Easy
s
LO: To define the term database management system (DBMS) and describe the functions of a
DBMS
Classification: Concept

20) The database management system (DBMS) is responsible for inserting, modifying, reading,
and deleting data.
Answer: TRUE
Page Ref: 15
AACSB: Information Technology
Difficulty: Easy
LO: To define the term database management system (DBMS) and describe the functions of a
DBMS
Classification: Concept




4
Copyright © 2022 Pearson Education, Inc.