TEST BANK for Database Processing 16th Edition by David Kroenke | Fundamentals, Design & Implementation | Complete Questions and Answers

VE
Database Processing, 16e (Kroenke/Auer/Vandenberg)




R
Chapter 1 Introduction




IF
1) The purpose of a database is to help people keep track of things.




IE
Answer: TRUE
Page Ref: 6




D
AACSB: Information Technology




BR
Difficulty: Easy
LO: To understand the nature and characteristics of databases
Classification: Concept




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




N
Answer: TRUE
Page Ref: 6




BO
AACSB: Information Technology
Difficulty: Easy




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




ST
3) Like a spreadsheet, a database table has rows and columns.
Answer: TRUE




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

4) In every database, not just the databases discussed in this book, table names are capitalized.
Answer: FALSE
Page Ref: 7
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the nature and characteristics of databases
Classification: Concept

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.

VERIFIEDBRAINBOOSTER

, VE
6) Data is recorded facts and figures; information is knowledge derived from data.




R
Answer: TRUE




IF
Page Ref: 10
AACSB: Information Technology




IE
Difficulty: Easy
LO: To understand the nature and characteristics of databases




D
Classification: Concept




BR
7) Databases record data in such a way that they can produce information.
Answer: TRUE




AI
Page Ref: 10
AACSB: Information Technology




N
Difficulty: Easy
LO: To understand the nature and characteristics of databases




BO
Classification: Concept




O
8) Enterprise Resource Planning (ERP) is an example of a data mining application.
Answer: FALSE




ST
Page Ref: 11
AACSB: Information Technology
Difficulty: Moderate




ER
LO: To survey some important and interesting database applications
Classification: Concept

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
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.

VERIFIEDBRAINBOOSTER

, VE
11) E-commerce companies use Web activity databases to determine which items on a Web page




R
are popular and successful.




IF
Answer: TRUE
Page Ref: 11




IE
AACSB: Information Technology
Difficulty: Moderate




D
LO: To understand the importance of databases in Internet Web applications and smartphone




BR
apps
Classification: Concept




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




N
Page Ref: 8
AACSB: Information Technology




BO
Difficulty: Easy
LO: To understand the nature and characteristics of databases




O
Classification: Concept




ST
13) A database system is typically defined as its four components: users, database applications,
the DBMS and the databases.
Answer: TRUE




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

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

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.

VERIFIEDBRAINBOOSTER

, VE
16) Applications usually write data directly to the database.




R
Answer: FALSE




IF
Page Ref: 13
AACSB: Information Technology




IE
Difficulty: Easy
LO: To gain a general understanding of tables and relationships




D
Classification: Concept




BR
17) Sequenced Query Language (SQL) is an internationally recognized standard language that is
understood by all commercial database management system products.




AI
Answer: FALSE
Page Ref: 12




N
AACSB: Information Technology
Difficulty: Moderate




BO
LO: To gain a general understanding of tables and relationships
Classification: Concept




O
18) In database systems, indexes are held in the database.




ST
Answer: TRUE
Page Ref: 38
AACSB: Information Technology




ER
Difficulty: Difficult
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
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.

VERIFIEDBRAINBOOSTER