Database Processing, 16e (Kroenke/Auer/Vandenberg) Chapt
nm nm nm nm
er 1 Introduction
nm n m
1) The purpose of a database is to help people keep track of thing
nm nm nm nm nm nm nm nm nm nm nm nm
s. Answer: TRUE
nm n m
Page Ref: 6 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
2) In a database, each table stores data about a different type of thin
nm nm nm nm nm nm nm nm nm nm nm nm
g. Answer: TRUE
nm n m
Page Ref: 6 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
3) Like a spreadsheet, a database table has rows and column
nm nm nm nm nm nm nm nm nm
s. Answer: TRUE
nm n m
Page Ref: 6 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
4) In every database, not just the databases discussed in this book, table names are capitalize
nm nm nm nm nm nm nm nm nm nm nm nm nm nm
d. Answer: FALSE
nm n m
Page Ref: 7 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
5) A database shows data in tables as well as the relationships among the rows in those tabl
nm nm nm nm nm nm nm nm nm nm nm nm nm nm nm nm
es. Answer: TRUE
nm n m
Page Ref: 8 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
Classification: Concept
m n m
1
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
,6) Data is recorded facts and figures; information is knowledge derived from dat
nm nm nm nm nm nm nm nm nm nm nm
a. Answer: TRUE
nm n m
Page Ref: 10
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
7) Databases record data in such a way that they can produce informatio
nm nm nm nm nm nm nm nm nm nm nm
n. Answer: TRUE
nm n m
Page Ref: 10
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
8) Enterprise Resource Planning (ERP) is an example of a data mining applicatio
nm nm nm nm nm nm nm nm nm nm nm
n. Answer: FALSE
nm n m
Page Ref: 11
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To survey some important and interesting database applications Classific
n m nm nm nm nm nm nm nm nm
ation: Conceptn m
9) Databases are a key component of e- nm nm nm nm nm nm
commerce order entry, billing, shipping, and customer support.
nm nm nm nm nm nm nm
Answer: TRUE nm nm
Page Ref: 11
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To survey some important and interesting database applications Classific
n m nm nm nm nm nm nm nm nm
ation: Conceptn m
10) The largest databases in e-
nm nm nm nm
commerce are the order entry databases. Answer: FALSE
nm nm nm nm nm nm n m
Page Ref: 11
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Difficult
n m
LO: To survey some important and interesting database applications Classific
n m nm nm nm nm nm nm nm nm
ation: Conceptn m
2
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
,11) E-
commerce companies use Web activity databases to determine which items on a Web page are
nm nm nm nm nm nm nm nm nm nm nm nm nm nm nm
popular and successful. nm nm
Answer: TRUE nm nm
Page Ref: 11 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the importance of databases in Internet Web applications and smartphone
n m nm nm nm nm nm nm nm nm nm nm nm nm
apps
Classification: Concept n m
12) A surrogate key is a key typically used in place of a foreign ke
nm nm nm nm nm nm nm nm nm nm nm nm nm
y. Answer: FALSE
nm n m
Page Ref: 8 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
13) A database system is typically defined as its four components: users, database application
nm nm nm nm nm nm nm nm nm nm nm nm
s, the DBMS and the databases.
nm nm nm nm nm
Answer: TRUE nm nm
Page Ref: 12 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
14) Databases based on the CODASYL standard are based on the network data mode
nm nm nm nm nm nm nm nm nm nm nm nm
l. Answer: TRUE
nm n m
Page Ref: 30 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the history and development of database processing Class
n m nm nm nm nm nm nm nm nm nm
ification: Concept n m
15) Applications are computer programs used directly by users nm nm nm nm nm nm nm
. Answer: TRUE
nm n m
Page Ref: 13 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
mClassification: Concept n m
3
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
, 16) Applications usually write data directly to the databasenm nm nm nm nm nm nm
. Answer: FALSE
nm n m
Page Ref: 13 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
mClassification: Concept n m
17) Sequenced Query Language (SQL) is an internationally recognized standard language that
nm nm nm nm nm nm nm nm nm nm nm
is understood by all commercial database management system products.
nm nm nm nm nm nm nm nm
Answer: FALSE nm n
mPage Ref: 12 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
mClassification: Concept n m
18) In database systems, indexes are held in the database
nm nm nm nm nm nm nm nm
. Answer: TRUE
nm n m
Page Ref: 38 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Difficult
n m
LO: To define the term database and describe what is contained within the database Classificat
n m nm nm nm nm nm nm nm nm nm nm nm nm nm
ion: Concept n m
19) A database management system (DBMS) creates, processes and administers databases
nm nm nm nm nm nm nm nm nm
. Answer: TRUE
nm n m
Page Ref: 38 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To define the term database management system (DBMS) and describe the functions of a
n m nm nm nm nm nm nm nm nm nm nm nm nm nm nm
DBMS
Classification: Concept n m
20) The database management system (DBMS) is responsible for inserting, modifying, readin
nm nm nm nm nm nm nm nm nm nm
g, and deleting data.
nm nm nm
Answer: TRUE nm nm
Page Ref: 15 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To define the term database management system (DBMS) and describe the functions of a
n m nm nm nm nm nm nm nm nm nm nm nm nm nm nm
DBMS
Classification: Concept n m
4
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
nm nm nm nm
er 1 Introduction
nm n m
1) The purpose of a database is to help people keep track of thing
nm nm nm nm nm nm nm nm nm nm nm nm
s. Answer: TRUE
nm n m
Page Ref: 6 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
2) In a database, each table stores data about a different type of thin
nm nm nm nm nm nm nm nm nm nm nm nm
g. Answer: TRUE
nm n m
Page Ref: 6 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
3) Like a spreadsheet, a database table has rows and column
nm nm nm nm nm nm nm nm nm
s. Answer: TRUE
nm n m
Page Ref: 6 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
4) In every database, not just the databases discussed in this book, table names are capitalize
nm nm nm nm nm nm nm nm nm nm nm nm nm nm
d. Answer: FALSE
nm n m
Page Ref: 7 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
5) A database shows data in tables as well as the relationships among the rows in those tabl
nm nm nm nm nm nm nm nm nm nm nm nm nm nm nm nm
es. Answer: TRUE
nm n m
Page Ref: 8 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
Classification: Concept
m n m
1
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
,6) Data is recorded facts and figures; information is knowledge derived from dat
nm nm nm nm nm nm nm nm nm nm nm
a. Answer: TRUE
nm n m
Page Ref: 10
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
7) Databases record data in such a way that they can produce informatio
nm nm nm nm nm nm nm nm nm nm nm
n. Answer: TRUE
nm n m
Page Ref: 10
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy
n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
8) Enterprise Resource Planning (ERP) is an example of a data mining applicatio
nm nm nm nm nm nm nm nm nm nm nm
n. Answer: FALSE
nm n m
Page Ref: 11
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To survey some important and interesting database applications Classific
n m nm nm nm nm nm nm nm nm
ation: Conceptn m
9) Databases are a key component of e- nm nm nm nm nm nm
commerce order entry, billing, shipping, and customer support.
nm nm nm nm nm nm nm
Answer: TRUE nm nm
Page Ref: 11
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To survey some important and interesting database applications Classific
n m nm nm nm nm nm nm nm nm
ation: Conceptn m
10) The largest databases in e-
nm nm nm nm
commerce are the order entry databases. Answer: FALSE
nm nm nm nm nm nm n m
Page Ref: 11
nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Difficult
n m
LO: To survey some important and interesting database applications Classific
n m nm nm nm nm nm nm nm nm
ation: Conceptn m
2
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
,11) E-
commerce companies use Web activity databases to determine which items on a Web page are
nm nm nm nm nm nm nm nm nm nm nm nm nm nm nm
popular and successful. nm nm
Answer: TRUE nm nm
Page Ref: 11 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the importance of databases in Internet Web applications and smartphone
n m nm nm nm nm nm nm nm nm nm nm nm nm
apps
Classification: Concept n m
12) A surrogate key is a key typically used in place of a foreign ke
nm nm nm nm nm nm nm nm nm nm nm nm nm
y. Answer: FALSE
nm n m
Page Ref: 8 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
13) A database system is typically defined as its four components: users, database application
nm nm nm nm nm nm nm nm nm nm nm nm
s, the DBMS and the databases.
nm nm nm nm nm
Answer: TRUE nm nm
Page Ref: 12 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To understand the nature and characteristics of databases C
n m nm nm nm nm nm nm nm nm
lassification: Concept n m
14) Databases based on the CODASYL standard are based on the network data mode
nm nm nm nm nm nm nm nm nm nm nm nm
l. Answer: TRUE
nm n m
Page Ref: 30 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To understand the history and development of database processing Class
n m nm nm nm nm nm nm nm nm nm
ification: Concept n m
15) Applications are computer programs used directly by users nm nm nm nm nm nm nm
. Answer: TRUE
nm n m
Page Ref: 13 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
mClassification: Concept n m
3
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER
, 16) Applications usually write data directly to the databasenm nm nm nm nm nm nm
. Answer: FALSE
nm n m
Page Ref: 13 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
mClassification: Concept n m
17) Sequenced Query Language (SQL) is an internationally recognized standard language that
nm nm nm nm nm nm nm nm nm nm nm
is understood by all commercial database management system products.
nm nm nm nm nm nm nm nm
Answer: FALSE nm n
mPage Ref: 12 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Moderate
n m
LO: To gain a general understanding of tables and relationships
n m nm nm nm nm nm nm nm nm n
mClassification: Concept n m
18) In database systems, indexes are held in the database
nm nm nm nm nm nm nm nm
. Answer: TRUE
nm n m
Page Ref: 38 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Difficult
n m
LO: To define the term database and describe what is contained within the database Classificat
n m nm nm nm nm nm nm nm nm nm nm nm nm nm
ion: Concept n m
19) A database management system (DBMS) creates, processes and administers databases
nm nm nm nm nm nm nm nm nm
. Answer: TRUE
nm n m
Page Ref: 38 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To define the term database management system (DBMS) and describe the functions of a
n m nm nm nm nm nm nm nm nm nm nm nm nm nm nm
DBMS
Classification: Concept n m
20) The database management system (DBMS) is responsible for inserting, modifying, readin
nm nm nm nm nm nm nm nm nm nm
g, and deleting data.
nm nm nm
Answer: TRUE nm nm
Page Ref: 15 nm nm
AACSB: Information Technology Difficult
n m nm nm
y: Easy n m
LO: To define the term database management system (DBMS) and describe the functions of a
n m nm nm nm nm nm nm nm nm nm nm nm nm nm nm
DBMS
Classification: Concept n m
4
Copyright © 2022 Pearson Education, Inc.
VERIFIEDBRAINBOOSTER