Database Concepts, 9e (Kroenke)
Chapter 1 Getting Started
1) Regarding Big Data, what does the term NoSQL really mean?
A) No SQL used
B) NortonOS Query Language
C) Notational Query Language
D) Non-Blocking Query Language
E) Nonrelational Database
Answer: E
Diff: 2 Page Ref: 29
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
2) What is the name of Microsoft's cloud services?
Answer: Azure
Diff: 2 Page Ref: 31
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
3) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
C) Web user interface
D) Back-end Database Management System
E) Bug-reporting System
Answer: C
Diff: 1 Page Ref: 28
AACSB: Information Technology
Chapter Obj: Introduce Web database applications
Classification: Concept
4) For efficiency purposes, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 29
AACSB: Information Technology
Chapter Obj: Introduce data warehouses and business intelligence (BI) systems
Classification: Concept
5) Although users use database systems, they are not considered part of a database system.
Answer: FALSE
Diff: 1 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
1
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
,6) A #ntdatabase #ntis #nta #ntset #ntof #ntone #ntor #ntmore #ntcomputer #ntprograms #ntthat #ntserves #ntas #ntan
#ntintermediary #ntbetween #ntthe #ntusers #ntand #ntthe #ntdatabase #ntmanagement #ntsystem #nt(DBMS).
Answer: # n t FALSE
Diff: #nt2 Page #ntRef: #nt18
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
7) Which #ntof #ntthe #ntfollowing #ntis #ntnot #nta #ntbasic #ntcomponent #ntof #nta #ntdatabase #ntsystem?
A) Database
B) User
C) ERD
D) DBMS
E) Database
#ntapplications #ntAnswer:
#n t C
Diff: #nt2 Page #ntRef: #nt18
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
8) A #ntrelational #ntdatabase #ntis #nt .
A) a #ntself-describing #ntcollection #ntof #ntrelated #nttables
B) a #ntcollection #ntof #ntforms #ntand #ntreports #ntthat #ntsupport #nta #ntgiven #ntpurpose
C) a #ntlibrary #ntof #ntqueries #ntand #ntdata #ntfiles #ntfor #ntquerying
D) a #ntset #ntof #ntapplications #ntand #ntthe #ntdata #ntsets #ntfor #ntthose #ntapplications
E) a #ntset #ntof
#ntmetadata
#ntAnswer: # n t A
Diff: #nt2 Page #ntRef: #nt18
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
9) The #ntcomponent #ntof #nta #ntdatabase #ntthat #ntmakes #ntit #ntself-describing #ntis #ntthe #nt .
A) related #nttables
B) applications
C) library
D) data #ntset
E) metadata
#ntAnswer:
#n t E
Diff: #nt2 Page #ntRef: #nt19
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
2
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
,10) Which #ntof #ntthe #ntfollowing #ntwould #ntnot #ntbe #ntan #ntexample #ntof #ntdatabase #ntmetadata?
A) Names #ntof #nttables #ntin #nta #ntdatabase
B) Properties #ntof #nttables #ntin #nta #ntdatabase
C) Names #ntof #ntcolumns #ntin #nta #ntdatabase #ntand #nttheir #ntassociated #nttables
D) Properties #ntof #ntcolumns
E) Queries #ntagainst #ntrecords #ntin #ntthe #ntdatabase
#nttables #ntAnswer: # n t E
Diff: #nt2 Page #ntRef: #nt19
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
11) In #ntrelational #ntdatabases, #ntquery #ntrequests #ntuse #nta #ntlanguage #ntcalled #nt .
Answer: Structured #ntQuery #ntLanguage #nt(SQL); #ntStructured #ntQuery #ntLanguage;
#ntSQL #ntDiff: #nt1 Page #ntRef: #nt16-17
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
12) Briefly #ntdescribe #ntthe #ntfour #ntcomponents #ntof #nta #ntdatabase #ntsystem.
Answer: # n t The #ntcomponents #ntof #nta #ntdatabase #ntsystem #ntare: #nt(1) #ntthe #ntusers, #nt(2) #ntthe #ntapplication
#ntprograms,
(3) #ntthe #ntDBMS, #ntand #nt(4) #ntthe #ntdatabase. #ntThe #ntusers #ntare #ntthe #ntpeople #ntthat #ntwill #ntemploy #ntthe
#ntsystem #ntto #ntinput #ntnew #ntdata, #ntmodify #ntexisting #ntdata, #ntand #ntdelete #ntdata #ntin #ntorder #ntto
#ntperform #nttheir #ntjobs. #ntThe #ntapplication #ntprograms #ntare #ntcomputer #ntprograms #ntthat #ntact #ntas
#ntintermediaries #ntbetween #ntthe #ntusers #ntand #ntthe #ntDBMS. #ntThe #ntapplication #ntprograms #ntproduce
#ntforms, #ntreports, #ntand #ntqueries; #ntthey #ntalso #nttranslate #ntuser #ntactions #ntinto #ntdata #ntmanagement
#ntrequests #ntfor #ntthe #ntDBMS. #ntThe #ntDBMS #ntmanipulates #ntthe #ntdatabase. #ntIt #ntreceives #ntdata
#ntmanagement #ntrequests #ntfrom #ntthe #ntcomputer #ntapplications #ntand #nttranslates #ntthem #ntinto #ntread
#ntand #ntwrite #ntcommands #ntfor #ntthe #ntdatabase. #ntThe #ntdatabase #ntcontains #ntthe #ntactual #ntuser #ntdata
#ntthat #ntthe #ntusers #ntneed #ntto #ntperform #nttheir #ntjobs.
Diff: #nt2 Page #ntRef: #nt18-21
#ntAACSB: # n t Information
#ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
13) What #ntcomponents #ntare #ntincluded #ntin #nta #ntdatabase?
Answer: # n t The #ntdatabase #ntcontains #ntuser #ntdata, #ntmetadata, #ntindexes #ntand #ntother #ntoverhead
#ntdata, #ntand #ntapplication #ntmetadata. #ntUser #ntdata #ntis #ntthe #ntdata #ntfrom #ntthe #ntusers' #ntenvironment
#ntthat #ntthey #ntwant #ntto #nttrack. #ntMetadata #ntis #ntdata #ntabout #ntthe #ntstructure #ntof #ntthe #ntdatabase.
#nt Indexes #ntand #ntother #ntoverhead #ntdata #ntare #ntstructures #ntthat #ntthe #ntdatabase #ntuses #ntto #ntimprove
#ntperformance. #ntFinally, #ntthe #ntapplication #ntmetadata #ntis #ntdata #ntabout #ntforms, #ntreports, #ntand
#ntother #ntapplication #ntcomponents #ntthat #ntsome #ntdatabases, #ntparticularly #ntthose #ntcreated #ntwith
#ntdesktop #ntDBMS #ntproducts, #ntstore #ntwith #ntthe #ntdatabase.
Diff: #nt2 Page #ntRef: #nt19
AACSB: # n t Information #ntTechnology
3
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
, Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
4
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
Chapter 1 Getting Started
1) Regarding Big Data, what does the term NoSQL really mean?
A) No SQL used
B) NortonOS Query Language
C) Notational Query Language
D) Non-Blocking Query Language
E) Nonrelational Database
Answer: E
Diff: 2 Page Ref: 29
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
2) What is the name of Microsoft's cloud services?
Answer: Azure
Diff: 2 Page Ref: 31
AACSB: Information Technology
Chapter Obj: Introduce Big Data and cloud computing
Classification: Concept
3) What role does the Web browser play in a Web database application?
A) Hardware support
B) Microchip accelerator
C) Web user interface
D) Back-end Database Management System
E) Bug-reporting System
Answer: C
Diff: 1 Page Ref: 28
AACSB: Information Technology
Chapter Obj: Introduce Web database applications
Classification: Concept
4) For efficiency purposes, data analysis should be done on the production database.
Answer: FALSE
Diff: 2 Page Ref: 29
AACSB: Information Technology
Chapter Obj: Introduce data warehouses and business intelligence (BI) systems
Classification: Concept
5) Although users use database systems, they are not considered part of a database system.
Answer: FALSE
Diff: 1 Page Ref: 18
AACSB: Information Technology
Chapter Obj: Know the components of a database system
Classification: Concept
1
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
,6) A #ntdatabase #ntis #nta #ntset #ntof #ntone #ntor #ntmore #ntcomputer #ntprograms #ntthat #ntserves #ntas #ntan
#ntintermediary #ntbetween #ntthe #ntusers #ntand #ntthe #ntdatabase #ntmanagement #ntsystem #nt(DBMS).
Answer: # n t FALSE
Diff: #nt2 Page #ntRef: #nt18
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
7) Which #ntof #ntthe #ntfollowing #ntis #ntnot #nta #ntbasic #ntcomponent #ntof #nta #ntdatabase #ntsystem?
A) Database
B) User
C) ERD
D) DBMS
E) Database
#ntapplications #ntAnswer:
#n t C
Diff: #nt2 Page #ntRef: #nt18
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
8) A #ntrelational #ntdatabase #ntis #nt .
A) a #ntself-describing #ntcollection #ntof #ntrelated #nttables
B) a #ntcollection #ntof #ntforms #ntand #ntreports #ntthat #ntsupport #nta #ntgiven #ntpurpose
C) a #ntlibrary #ntof #ntqueries #ntand #ntdata #ntfiles #ntfor #ntquerying
D) a #ntset #ntof #ntapplications #ntand #ntthe #ntdata #ntsets #ntfor #ntthose #ntapplications
E) a #ntset #ntof
#ntmetadata
#ntAnswer: # n t A
Diff: #nt2 Page #ntRef: #nt18
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
9) The #ntcomponent #ntof #nta #ntdatabase #ntthat #ntmakes #ntit #ntself-describing #ntis #ntthe #nt .
A) related #nttables
B) applications
C) library
D) data #ntset
E) metadata
#ntAnswer:
#n t E
Diff: #nt2 Page #ntRef: #nt19
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
2
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
,10) Which #ntof #ntthe #ntfollowing #ntwould #ntnot #ntbe #ntan #ntexample #ntof #ntdatabase #ntmetadata?
A) Names #ntof #nttables #ntin #nta #ntdatabase
B) Properties #ntof #nttables #ntin #nta #ntdatabase
C) Names #ntof #ntcolumns #ntin #nta #ntdatabase #ntand #nttheir #ntassociated #nttables
D) Properties #ntof #ntcolumns
E) Queries #ntagainst #ntrecords #ntin #ntthe #ntdatabase
#nttables #ntAnswer: # n t E
Diff: #nt2 Page #ntRef: #nt19
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
11) In #ntrelational #ntdatabases, #ntquery #ntrequests #ntuse #nta #ntlanguage #ntcalled #nt .
Answer: Structured #ntQuery #ntLanguage #nt(SQL); #ntStructured #ntQuery #ntLanguage;
#ntSQL #ntDiff: #nt1 Page #ntRef: #nt16-17
AACSB: # n t Information #ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
12) Briefly #ntdescribe #ntthe #ntfour #ntcomponents #ntof #nta #ntdatabase #ntsystem.
Answer: # n t The #ntcomponents #ntof #nta #ntdatabase #ntsystem #ntare: #nt(1) #ntthe #ntusers, #nt(2) #ntthe #ntapplication
#ntprograms,
(3) #ntthe #ntDBMS, #ntand #nt(4) #ntthe #ntdatabase. #ntThe #ntusers #ntare #ntthe #ntpeople #ntthat #ntwill #ntemploy #ntthe
#ntsystem #ntto #ntinput #ntnew #ntdata, #ntmodify #ntexisting #ntdata, #ntand #ntdelete #ntdata #ntin #ntorder #ntto
#ntperform #nttheir #ntjobs. #ntThe #ntapplication #ntprograms #ntare #ntcomputer #ntprograms #ntthat #ntact #ntas
#ntintermediaries #ntbetween #ntthe #ntusers #ntand #ntthe #ntDBMS. #ntThe #ntapplication #ntprograms #ntproduce
#ntforms, #ntreports, #ntand #ntqueries; #ntthey #ntalso #nttranslate #ntuser #ntactions #ntinto #ntdata #ntmanagement
#ntrequests #ntfor #ntthe #ntDBMS. #ntThe #ntDBMS #ntmanipulates #ntthe #ntdatabase. #ntIt #ntreceives #ntdata
#ntmanagement #ntrequests #ntfrom #ntthe #ntcomputer #ntapplications #ntand #nttranslates #ntthem #ntinto #ntread
#ntand #ntwrite #ntcommands #ntfor #ntthe #ntdatabase. #ntThe #ntdatabase #ntcontains #ntthe #ntactual #ntuser #ntdata
#ntthat #ntthe #ntusers #ntneed #ntto #ntperform #nttheir #ntjobs.
Diff: #nt2 Page #ntRef: #nt18-21
#ntAACSB: # n t Information
#ntTechnology
Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
13) What #ntcomponents #ntare #ntincluded #ntin #nta #ntdatabase?
Answer: # n t The #ntdatabase #ntcontains #ntuser #ntdata, #ntmetadata, #ntindexes #ntand #ntother #ntoverhead
#ntdata, #ntand #ntapplication #ntmetadata. #ntUser #ntdata #ntis #ntthe #ntdata #ntfrom #ntthe #ntusers' #ntenvironment
#ntthat #ntthey #ntwant #ntto #nttrack. #ntMetadata #ntis #ntdata #ntabout #ntthe #ntstructure #ntof #ntthe #ntdatabase.
#nt Indexes #ntand #ntother #ntoverhead #ntdata #ntare #ntstructures #ntthat #ntthe #ntdatabase #ntuses #ntto #ntimprove
#ntperformance. #ntFinally, #ntthe #ntapplication #ntmetadata #ntis #ntdata #ntabout #ntforms, #ntreports, #ntand
#ntother #ntapplication #ntcomponents #ntthat #ntsome #ntdatabases, #ntparticularly #ntthose #ntcreated #ntwith
#ntdesktop #ntDBMS #ntproducts, #ntstore #ntwith #ntthe #ntdatabase.
Diff: #nt2 Page #ntRef: #nt19
AACSB: # n t Information #ntTechnology
3
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
, Chapter #ntObj: # n t Know #ntthe #ntcomponents #ntof #nta #ntdatabase
#ntsystem #ntClassification: # n t Concept
4
Copyright #nt© #nt2020 #ntPearson #ntEducation,
#ntInc.
SCHOLARVAULT
