Test Bank for Database Systems Design, Implementation, & Management, 14th Edition Carlos Coronel, Steven Morris

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

mentation 14th Edition Kroenke
i i i




DatabaseiProcessing,i14ei(Kroenke)
Chapteri2:iIntroductionitoiStructurediQueryiLanguage

1) BusinessiIntelligencei(BI)isystemsitypicallyistoreitheiridataiinidataiwarehouses.iAn
swer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Easy
LO:i Toiunderstanditheiuseiofiextractedidataisetsiinibusinessiintelligencei(BI)isystemsiClas
sification:i Concept

2) Aniad-
hociSQLiqueryiisitypicallyiwritteniwithinianiapplicationiprogram.iAnswer:i FA
LSE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i Toiunderstanditheiuseiofiad-
hociqueriesiinibusinessiintelligencei(BI)isystemsiClassification:i Concept

3) SQListandsiforiStandardiQueryiLanguage.
Answer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Easy
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

4) SQLiincludesiaidataidefinitionilanguage,iaidataimanipulationilanguage,iandiSQL/Persistentistor
edimodules.
Answer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

5) SQLiisionlyiaidataimanipulationilanguagei(DML).iA
nswer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Difficult
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

6) TheiAmericaniNationaliStandardsiInstitutei(ANSI)imaintainsitheistandardsiforiSQL.iAn
swer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Difficult
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

1
Copyrighti©i2016iPearsoniEducation,iInc.
mynursytest.store

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

mentation 14th Edition Kroenke
i i i




7) SQLiwasidevelopedibyiIBMiinitheilatei1970s.iA
nswer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Easy
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

8) SQLiisinotiaicompleteiprogrammingilanguage.iRatheriitiisiaidataisublanguage.iAns
wer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

9) Iniadditionitoibeingiaidataisublanguage,iSQLiisialsoiaiprogrammingilanguage,ilikeiJavaioriC#.iAns
wer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:iToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iClas
sification:i Concept

10) SQLicommandsicanibeiembeddediiniapplicationiprograms.iA
nswer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Difficult
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:i Concept

11) SQL,ialthoughiveryipopular,ihasineveribecomeiainationalistandard.iAn
swer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i ToiunderstanditheihistoryiandisignificanceiofiStructurediQueryiLanguagei(SQL)iCla
ssification:iConcept

12) TheiSQLikeywordiSELECTiisiuseditoispecifyitheicolumnsitoibeilistediinitheiqueryiresults.iAns
wer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i ToiunderstanditheiSQLiSELECT/FROM/WHEREiframeworkiasitheibasisiforidatabaseique
ries
Classification:i Concept




2
Copyrighti©i2016iPearsoniEducation,iInc.
mynursytest.store

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

mentation 14th Edition Kroenke i i i




13) TheiSQLikeywordiWHEREiisiuseditoispecifyitheitable(s)ithaticontain(s)itheidataitoibeiretri
eved.
Answer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Easy
LO:i ToiunderstanditheiSQLiSELECT/FROM/WHEREiframeworkiasitheibasisiforidatabaseique
ries
Classification:i Concept

14) TheiSQLikeywordiFROMiisiuseditoispecifyitheitableitoibeiused.iAns
wer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Easy
LO:iToiunderstanditheiSQLiSELECT/FROM/WHEREiframeworkiasitheibasisiforidatabaseique
ries
Classification:i Concept

15) SQLicanionlyiqueryiaisingleitable.iA
nswer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i ToiunderstanditheiSQLiSELECT/FROM/WHEREiframeworkiasitheibasisiforidatabaseique
ries
Classification:i Concept

16) SQListatementsiendiwithiaicolon.iA
nswer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Easy
LO:i ToiunderstanditheiSQLiSELECT/FROM/WHEREiframeworkiasitheibasisiforidatabaseique
ries
Classification:i Concept

17) TheicolumnsitoibeiobtainedibyianiSQLicommandiareilistediafteritheiFROMikeyword.iAns
wer:i FALSE
AACSB:iInformationiTechnologyiDifficu
lty:i Moderate
LO:i ToiunderstanditheiSQLiSELECT/FROM/WHEREiframeworkiasitheibasisiforidatabaseique
ries
Classification:i Concept

18) Toiremoveiduplicateirowsifromitheiresultiofiaiquery,ispecifyitheiSQLiDISTINCTikeyword.iAns
wer:i TRUE
AACSB:iInformationiTechnologyiDifficu
lty:i Difficult
LO:i ToicreateiSQLiqueriesithatiuseitheiSQLiDISTINCT,iTOP,iandiTOPiPERCENTikeywordsiClas
sification:i Concept
3
Copyrighti©i2016iPearsoniEducation,iInc.
mynursytest.store