Test bank for database processing fundamentals design and implementation 15th edition kroenke full chapter

,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design andImple
m m m m m m m m m m

mentation 15th Edition Kroenke
m m m




DatabasemProcessing,m15em(Kroenke)
Chapterm2:mIntroductionmtomStructuredmQuerymLanguage

1) BusinessmIntelligencem(BI)msystemsmtypicallymstoremtheirmdataminmdatamwarehous
es.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Easy
LO:m Tomunderstandmthemusemofmextractedmdatamsetsminmbusinessmintelligencem(BI)msystemsmClassifi
cation:m Concept

2) Anmad-
hocmSQLmquerymismtypicallymwrittenmwithinmanmapplicationmprogram.mAnswe
r:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m Tomunderstandmthemusemofmad-
hocmqueriesminmbusinessmintelligencem(BI)msystemsmClassification:m Concept

3) SQLmstandsmformStandardmQuerymLanguage.
Answer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Easy
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

4) SQLmincludesmamdatamdefinitionmlanguage,mamdatammanipulationmlanguage,mandmSQL/Persist
entmstoredmmodules.
Answer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

5) SQLmismonlymamdatammanipulationmlanguagem(DML
).mAnswer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Difficult
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

6) ThemAmericanmNationalmStandardsmInstitutem(ANSI)mmaintainsmthemstandardsmformSQ
L.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Difficult
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

1
Copyrightm©m2019mPearsonmEducation,mIn
c.
mynursytest.store

,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design andImple
m m m m m m m m m m

mentation 15th Edition Kroenke
m m m




7) SQLmwasmdevelopedmbymIBMminmthemlatem1970
s.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Easy
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

8) SQLmismnotmamcompletemprogrammingmlanguage.mRathermitmismamdatamsublangua
ge.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

9) Inmadditionmtombeingmamdatamsublanguage,mSQLmismalsomamprogrammingmlanguage,mlikemJavamorm
C#.mAnswer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

10) SQLmcommandsmcanmbemembeddedminmapplicationmprogram
s.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Difficult
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

11) SQL,malthoughmverympopular,mhasmnevermbecomemamnationalmstandar
d.mAnswer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemhistorymandmsignificancemofmStructuredmQuerymLanguagem(SQL)mClassifi
cation:m Concept

12) ThemSQLmkeywordmSELECTmismusedmtomspecifymthemcolumnsmtombemlistedminmthemquerymresu
lts.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemSQLmSELECT/FROM/WHEREmframeworkmasmthembasismformdatabasemq
ueries
Classification:m Concept




2
Copyrightm©m2019mPearsonmEducation,mIn
c.
mynursytest.store

, DOWNLOAD THE Test Bank for Database Processing Fundamentals Design andImple
m m m m m m m m m m

mentation 15th Edition Kroenkem m m




13) ThemSQLmkeywordmWHEREmismusedmtomspecifymthemtable(s)mthatmcontain(s)mthemdatamto
mbem
retrieved.
Answer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Easy
LO:m TomunderstandmthemSQLmSELECT/FROM/WHEREmframeworkmasmthembasismformdatabasemq
ueries
Classification:m Concept

14) ThemSQLmkeywordmFROMmismusedmtomspecifymthemtablemtombemus
ed.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Easy
LO:m TomunderstandmthemSQLmSELECT/FROM/WHEREmframeworkmasmthembasismformdatabasemq
ueries
Classification:m Concept

15) SQLmcanmonlymquerymamsinglemtabl
e.mAnswer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemSQLmSELECT/FROM/WHEREmframeworkmasmthembasismformdatabasemq
ueries
Classification:m Concept

16) SQLmstatementsmendmwithmamcolo
n.mAnswer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Easy
LO:m TomunderstandmthemSQLmSELECT/FROM/WHEREmframeworkmasmthembasismformdatabasemq
ueries
Classification:m Concept

17) ThemcolumnsmtombemobtainedmbymanmSQLmcommandmaremlistedmaftermthemFROMmkeywo
rd.mAnswer:m FALSE
AACSB:mInformationmTechnologym
Difficulty:m Moderate
LO:m TomunderstandmthemSQLmSELECT/FROM/WHEREmframeworkmasmthembasismformdatabasemq
ueries
Classification:m Concept

18) Tomremovemduplicatemrowsmfrommthemresultmofmamquery,mspecifymthemDISTINCTmkeywo
rd.mAnswer:m TRUE
AACSB:mInformationmTechnologym
Difficulty:m Difficult
LO:m TomcreatemSQLmqueriesmthatmusemthemSQLmDISTINCT,mTOP,mandmTOPmPERCENTmkeywor
dsmClassification:m Concept
3
Copyrightm©m2019mPearsonmEducation,mIn
c.
mynursytest.store