Test Bank For Database Processing Fundamentals, Design, and Implementation 14th Edition by David Kroenke, isbn 9780133876703..pdf

,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and Implem
n n n n n n n n n n

entation 14th Edition Kroenke
n n n




DatabasenProcessing,n14en(Kroenke)
Chaptern2:nIntroductionntonStructurednQuerynLanguage

1) Businessn Intelligencen (BI)n systemsn typicallynstoren theirn dataninn datan warehouses.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Easy
LO:n Ton understand nthen usenofnextractedndatansetsn innbusinessn intelligencen (BI)n systemsn Classificati
on:n Concept

2) Ann ad-
hocn SQLn queryn isn typicallynwrittenn withinn ann applicationn program.n Answer:n
FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand n then usen of n ad-
hocn queriesn inn businessn intelligencen (BI)n systemsn Classification:n Concept

3) SQLn standsn forn Standardn Queryn Language.
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Easy
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

4) SQLnincludesn an datandefinitionnlanguage,n andatanmanipulationn language,n and nSQL/Persistent ns
tored n modules.
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

5) SQLnisn onlynan datan manipulationn languagen (DML).n
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Difficult
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

6) Then Americann Nationaln StandardsnInstituten(ANSI)nmaintainsn thenstandardsnforn SQL.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Difficult
LO:n Ton understand nthenhistorynandnsignificancen of nStructurednQuerynLanguagen(SQL)n Classificati
on:n Concept

1
Copyright n©n 2016 n Pearson nEducation,nInc.
mynursytest.store

,DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and Implem
n n n n n n n n n n

entation 14th Edition Kroenke
n n n




7) SQLnwasn developed nbynIBMninnthenlaten 1970s.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Easy
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

8) SQLnisn not n an completen programmingn language.n Rathern it n isn an datan sublanguage.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

9) Inn additionn tonbeingn an datan sublanguage,n SQLn isn alson an programmingn language,n liken Javan orn C#.n
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

10) SQLncommandsn cann benembeddedn inn applicationn programs.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Difficult
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

11) SQL,n althoughn veryn popular,n hasnnevern becomenan nationaln standard.n
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthenhistorynandnsignificancen of nStructured nQuerynLanguagen(SQL)nClassificati
on:n Concept

12) Then SQLn keyword nSELECTn isn used ntonspecifyn then columnsn ton ben listed n inn then queryn results.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthen SQLnSELECT/FROM/WHERE nframeworkn asnthenbasisn forndatabasenqueri
es
Classification:n Concept




2
Copyright n©n 2016 n Pearson nEducation,nInc.
mynursytest.store

, DOWNLOAD THE Test Bank for Database Processing Fundamentals Design and Implem
n n n n n n n n n n

entation 14th Edition Kroenke n n n




13) Then SQLn keyword nWHEREnisn used ntonspecifynthentable(s)n thatncontain(s)n thendatanton ben r
etrieved.
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Easy
LO:n Ton understand nthenSQLnSELECT/FROM/WHERE nframeworkn asn thenbasisn forndatabasen queri
es
Classification:n Concept

14) Then SQLn keyword nFROMn isn usedntonspecifynthentablen ton ben used.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Easy
LO:n Ton understand nthenSQLnSELECT/FROM/WHERE nframeworkn asn thenbasisn forndatabasen queri
es
Classification:n Concept

15) SQLncann onlynquerynan singlen table.n
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthen SQLnSELECT/FROM/WHERE nframeworkn asnthenbasisn forndatabasenqueri
es
Classification:n Concept

16) SQLnstatementsn endnwithnancolon.n
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Easy
LO:n Ton understand nthen SQLnSELECT/FROM/WHERE nframeworkn asnthenbasisn forndatabasenqueri
es
Classification:n Concept

17) Then columnsn ton ben obtained nbynann SQLncommand naren listednaftern then FROMn keyword.n
Answer:n FALSE
AACSB:n InformationnTechnologyn Difficulty
:n Moderate
LO:n Ton understand nthen SQLnSELECT/FROM/WHERE nframeworkn asnthenbasisn forndatabasenqueri
es
Classification:n Concept

18) Ton removen duplicaten rowsn fromn thenresult n ofnan query,nspecifynthenSQLn DISTINCTn keyword.n
Answer:n TRUE
AACSB:n InformationnTechnologyn Difficulty
:n Difficult
LO:n Ton createn SQLnqueriesn that nusenthenSQLnDISTINCT,n TOP,nand nTOPnPERCENTn keywordsn C
lassification:n Concept
3
Copyright n©n 2016 n Pearson nEducation,nInc.
mynursytest.store