Database Concepts, 10e (Kroenke)
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
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
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
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: 17
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: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
1
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
,7) Currently, #dworganizations #dwuse #dwtheir #dwown
#dwhardware. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw20
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
8) The #dwDBMS #dwis #dwused #dwto #dwcreate #dwthe
#dwdatabase #dwitself. #dwAnswer: # d w TRUE
Diff: #dw1 Page #dwRef: #dw17
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
9) Referential #dwintegrity #dwconstraints #dwmust #dwbe #dwenforced #dwby #dwthe
#dwapplication #dwprogram. #dwAnswer: # d w FALSE
Diff: #dw2 Page #dwRef: #dw19
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
10) Application #dwprograms #dware #dwresponsible #dwfor #dwcreating, #dwmaintaining, #dwand
#dwsupporting #dwdatabase #dwbackup #dwand #dwrecovery #dwsystems.
Answer: # d w # d w FALSE
Diff: #dw2 Page #dwRef: #dw20
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
11) A #dwrelational #dwdatabase #dwstores #dwdata #dwin #dwthe
#dwform #dwof #dwlists. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw11
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
12) Usually, #dwa #dwdatabase #dwtable #dwcontaining #dwboth #dwrows #dwand #dwcolumns #dwis #dwdesigned
#dwto #dwstore #dwdata #dwfor #dwexactly #dwtwo #dwthemes.
Answer: # d w # d w FALSE
Diff: #dw2 Page #dwRef: #dw11
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
2
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
,13) MySQL #dwCommunity #dwServer #dw8.0 #dwedition #dwis #dwa #dwwidely #dwused #dwstandard, #dwfull-
strength #dwedition #dwof #dwMySQL, #dwwhich #dwcan #dwbe #dwdownloaded #dwfor #dwfree #dwand #dwwhich #dwmay
#dwbe #dwused #dwin #dwproduction #dwenvironments. #dwAnswer: # d w TRUE
Diff: #dw2 Page #dwRef: #dw25
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwdifference #dwbetween #dwpersonal #dwand #dwenterprise-
class #dwdatabase #dwsystems.
Classification: # d w # d w Concept
14) SQL #dwstands #dwfor #dwStructural #dwQuestion
#dwLanguage. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw16
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
15) Relational #dwdatabase #dwtables #dware #dwcommonly #dwcombined, #dwqueried, #dwand #dwprocessed
#dwusing #dwStructured #dwQuery #dwLanguage #dw(SQL).
Answer: # d w # d w TRUE
Diff: #dw1 Page #dwRef: #dw16
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
16) The #dwDBMS #dwreceives #dwdata #dwupdate #dwrequests #dwfrom #dwthe
#dwapplication #dwprogram. #dwAnswer: # d w TRUE
Diff: #dw3 Page #dwRef: #dw17
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
17) In #dwthe #dwgeneral #dwdivision #dwof #dwlabor #dwbetween #dwdatabase #dwapplications #dwand #dwthe #dwDBMS,
#dwthe #dwprocessing #dwof #dwforms #dwis #dwconsidered #dwa #dwDBMS #dwtask.
Answer: # d w # d w FALSE
Diff: #dw3 Page #dwRef: #dw20
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
18) Database #dwapplications #dwthat #dwhide #dwthe #dwunderlying #dwdatabase #dwtechnology #dware
#dwuseful #dwonly #dwfor #dwpersonal #dwdatabase #dwapplications.
Answer: # d w # d w TRUE
Diff: #dw3 Page #dwRef: #dw23
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwdifference #dwbetween #dwpersonal #dwand #dwenterprise-
class #dwdatabase #dwsystems.
Classification: # d w
# d w Concept
3
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
, 19) In #dwthe #dwgeneral #dwdivision #dwof #dwlabor #dwbetween #dwdatabase #dwapplications #dwand #dwthe #dwDBMS,
#dwthe #dwapplication #dwprogram #dwformats #dwthe #dwresults #dwof #dwa #dwquery #dwinto #dwa #dwreport.
Answer: # d w # d w TRUE
Diff: #dw3 Page #dwRef: #dw21
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
20) Personal #dwDBMS #dwproducts, #dwsuch #dwas #dwMicrosoft #dwAccess, #dwcreate #dwa #dwclear
#dwdistinction #dwbetween #dwthe #dwDBMS #dwand #dwthe #dwdatabase #dwapplication.
Answer: # d w # d w FALSE
Diff: #dw2 Page #dwRef: #dw22
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
21) There #dwis #dwno #dwreason #dwfor #dwserious #dwdatabase #dwdevelopers #dwto #dwlearn #dwmany
#dwaspects #dwof #dwdatabase #dwprocessing #dwtechnology #dwbecause #dwDBMS #dwproducts #dwlike
#dwMicrosoft #dwAccess #dwhide #dwthese #dwaspects. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw24
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
22) Microsoft #dwAccess #dwis #dwa #dwpersonal #dwdatabase #dwthat #dwcombines #dwa #dwDBMS #dwwith
#dwan #dwapplication #dwgenerator.
Answer: # d w # d w TRUE
Diff: #dw1 Page #dwRef: #dw43
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
23) The #dwMicrosoft #dwAccess #dwapplication #dwgenerator #dwprovides #dwthe #dwability #dwto #dwcreate
#dwand #dwstore #dwforms, #dwreports, #dwand #dwqueries.
Answer: # d w # d w TRUE
Diff: #dw2 Page #dwRef: #dw43
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
24) Microsoft #dwAccess #dwdatabases #dware #dwstored #dwusing #dwthe #dwfile
#dwextension #dw.accdb. #dwAnswer: # d w TRUE
Diff: #dw2 Page #dwRef: #dw48
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase #dwapplication.
Classification: # d w
# d w Concept
4
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
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
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
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
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: 17
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: 17
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database.
Classification: Concept
1
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
,7) Currently, #dworganizations #dwuse #dwtheir #dwown
#dwhardware. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw20
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
8) The #dwDBMS #dwis #dwused #dwto #dwcreate #dwthe
#dwdatabase #dwitself. #dwAnswer: # d w TRUE
Diff: #dw1 Page #dwRef: #dw17
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
9) Referential #dwintegrity #dwconstraints #dwmust #dwbe #dwenforced #dwby #dwthe
#dwapplication #dwprogram. #dwAnswer: # d w FALSE
Diff: #dw2 Page #dwRef: #dw19
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
10) Application #dwprograms #dware #dwresponsible #dwfor #dwcreating, #dwmaintaining, #dwand
#dwsupporting #dwdatabase #dwbackup #dwand #dwrecovery #dwsystems.
Answer: # d w # d w FALSE
Diff: #dw2 Page #dwRef: #dw20
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Learn #dwthe #dwpurpose #dwof #dwa #dwdatabase #dwmanagement #dwsystem
#dw(DBMS). #dwClassification: # d w Concept
11) A #dwrelational #dwdatabase #dwstores #dwdata #dwin #dwthe
#dwform #dwof #dwlists. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw11
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
12) Usually, #dwa #dwdatabase #dwtable #dwcontaining #dwboth #dwrows #dwand #dwcolumns #dwis #dwdesigned
#dwto #dwstore #dwdata #dwfor #dwexactly #dwtwo #dwthemes.
Answer: # d w # d w FALSE
Diff: #dw2 Page #dwRef: #dw11
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
2
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
,13) MySQL #dwCommunity #dwServer #dw8.0 #dwedition #dwis #dwa #dwwidely #dwused #dwstandard, #dwfull-
strength #dwedition #dwof #dwMySQL, #dwwhich #dwcan #dwbe #dwdownloaded #dwfor #dwfree #dwand #dwwhich #dwmay
#dwbe #dwused #dwin #dwproduction #dwenvironments. #dwAnswer: # d w TRUE
Diff: #dw2 Page #dwRef: #dw25
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwdifference #dwbetween #dwpersonal #dwand #dwenterprise-
class #dwdatabase #dwsystems.
Classification: # d w # d w Concept
14) SQL #dwstands #dwfor #dwStructural #dwQuestion
#dwLanguage. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw16
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
15) Relational #dwdatabase #dwtables #dware #dwcommonly #dwcombined, #dwqueried, #dwand #dwprocessed
#dwusing #dwStructured #dwQuery #dwLanguage #dw(SQL).
Answer: # d w # d w TRUE
Diff: #dw1 Page #dwRef: #dw16
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwhow #dwusing #dwrelated #dwtables #dwhelps #dwyou #dwavoid #dwthe
#dwproblems #dwof #dwusing #dwlists. #dwClassification: # d w Concept
16) The #dwDBMS #dwreceives #dwdata #dwupdate #dwrequests #dwfrom #dwthe
#dwapplication #dwprogram. #dwAnswer: # d w TRUE
Diff: #dw3 Page #dwRef: #dw17
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
17) In #dwthe #dwgeneral #dwdivision #dwof #dwlabor #dwbetween #dwdatabase #dwapplications #dwand #dwthe #dwDBMS,
#dwthe #dwprocessing #dwof #dwforms #dwis #dwconsidered #dwa #dwDBMS #dwtask.
Answer: # d w # d w FALSE
Diff: #dw3 Page #dwRef: #dw20
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
18) Database #dwapplications #dwthat #dwhide #dwthe #dwunderlying #dwdatabase #dwtechnology #dware
#dwuseful #dwonly #dwfor #dwpersonal #dwdatabase #dwapplications.
Answer: # d w # d w TRUE
Diff: #dw3 Page #dwRef: #dw23
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwdifference #dwbetween #dwpersonal #dwand #dwenterprise-
class #dwdatabase #dwsystems.
Classification: # d w
# d w Concept
3
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
, 19) In #dwthe #dwgeneral #dwdivision #dwof #dwlabor #dwbetween #dwdatabase #dwapplications #dwand #dwthe #dwDBMS,
#dwthe #dwapplication #dwprogram #dwformats #dwthe #dwresults #dwof #dwa #dwquery #dwinto #dwa #dwreport.
Answer: # d w # d w TRUE
Diff: #dw3 Page #dwRef: #dw21
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
20) Personal #dwDBMS #dwproducts, #dwsuch #dwas #dwMicrosoft #dwAccess, #dwcreate #dwa #dwclear
#dwdistinction #dwbetween #dwthe #dwDBMS #dwand #dwthe #dwdatabase #dwapplication.
Answer: # d w # d w FALSE
Diff: #dw2 Page #dwRef: #dw22
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
21) There #dwis #dwno #dwreason #dwfor #dwserious #dwdatabase #dwdevelopers #dwto #dwlearn #dwmany
#dwaspects #dwof #dwdatabase #dwprocessing #dwtechnology #dwbecause #dwDBMS #dwproducts #dwlike
#dwMicrosoft #dwAccess #dwhide #dwthese #dwaspects. #dwAnswer: # d w FALSE
Diff: #dw1 Page #dwRef: #dw24
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
22) Microsoft #dwAccess #dwis #dwa #dwpersonal #dwdatabase #dwthat #dwcombines #dwa #dwDBMS #dwwith
#dwan #dwapplication #dwgenerator.
Answer: # d w # d w TRUE
Diff: #dw1 Page #dwRef: #dw43
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
23) The #dwMicrosoft #dwAccess #dwapplication #dwgenerator #dwprovides #dwthe #dwability #dwto #dwcreate
#dwand #dwstore #dwforms, #dwreports, #dwand #dwqueries.
Answer: # d w # d w TRUE
Diff: #dw2 Page #dwRef: #dw43
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase
#dwapplication. #dwClassification: # d w Concept
24) Microsoft #dwAccess #dwdatabases #dware #dwstored #dwusing #dwthe #dwfile
#dwextension #dw.accdb. #dwAnswer: # d w TRUE
Diff: #dw2 Page #dwRef: #dw48
AACSB: # d w # d w Information #dwTechnology
Chapter #dwObj.: # d w # d w Understand #dwthe #dwfunctions #dwof #dwa #dwdatabase #dwapplication.
Classification: # d w
# d w Concept
4
Copyright #dw© #dw2024 #dwPearson
#dwEducation, #dwInc.
SCHOLARVAULT
