BCIS 4620 Final Exam With Valid
Solutions
ANSI-standard rrSQL rrallows rrthe rruse rrof rrspecial rroperators rrin rrconjunction rrwith rrthe
rrWHERE rrclause. rr- rrCORRECT✅✅True
When rrusing rrthe rrOracle rrTO_DATE rrfunction, rrthe rrcode rr_____ rrrepresents rra rrthree-
letter rrmonth rrname. rr- rrCORRECT✅✅MON
The rrANSI rrSQL rrstandards rrare rralso rraccepted rrby rrthe rrISO. rr- rrCORRECT✅✅True
_____ rris rra rrrelational rrset rroperator. rr- rrCORRECT✅✅except
In rrsubquery rrterminology, rrthe rrfirst rrquery rrin rrthe rrSQL rrstatement rris rrknown rras rrthe
rr_____ rrquery. rr- rrCORRECT✅✅outer rrquery
How rrmany rrrows rrwould rrbe rrreturned rrfrom rra rrcross rrjoin rrof rrtables rrA rrand rrB, rrif rrA
rrcontains rr8 rrrows rrand rrB rrcontains rr18? rr- rrCORRECT✅✅144
Date rrprocedures rrare rroften rrmore rrsoftware-specific rrthan rrother rrSQL rrprocedures. rr-
rrCORRECT✅✅True
When rrusing rra(n) rr_____ rrjoin, rronly rrrows rrfrom rrthe rrtables rrthat rrmatch rron rra
rrcommon rrvalue rrare rrreturned. rr- rrCORRECT✅✅inner
The rr_____ rrfunction rrreturns rrthe rrcurrent rrsystem rrdate rrin rrMS rrAccess. rr-
rrCORRECT✅✅DATE()
Comparison rroperators rrcannot rrbe rrused rrto rrplace rrrestrictions rron rrcharacter-based
rrattributes. rr- rrCORRECT✅✅False
The rrSQL rrdata rrmanipulation rrcommand rrHAVING: rr- rrCORRECT✅✅restricts rrthe
rrselection rrof rrgrouped rrrows rrbased rron rra rrcondition.
If rra rrdesigner rrwishes rrto rrcreate rran rrinner rrjoin, rrbut rrthe rrtwo rrtables rrdo rrnot rrhave
rra rrcommonly rrnamed rrattribute, rrhe rrcan rruse rra(n) rr_____ rrclause. rr-
rrCORRECT✅✅Join rrOn
Numeric rrfunctions rrtake rrone rrnumeric rrparameter rrand rrreturn rrone rrvalue. rr-
rrCORRECT✅✅true
Which rris rra rrfeature rrof rra rrcorrelated rrsubquery? rr- rrCORRECT✅✅The rrouter
rrsubquery rrinitiates rrthe rrprocess rrof rrexecution rrin rra rrsubquery.
, What rrtype rrof rrcommand rrdoes rrthis rrSQL rrstatement rruse?
SELECT rrP_CODE, rrP_DESCRIPT, rrP_PRICE_V_NAME
FROM rrPRODUCT, rrVENDOR
WHERE rrPRODUCT.V_CODE=VENDOR. rrV_CODE rr- rrCORRECT✅✅old rrstyle rrjoin
The rrspecial rroperator rrused rrto rrcheck rrwhether rran rrattribute rrvalue rris rrwithin rra
rrrange rrof rrvalues rris rr_____. rr- rrCORRECT✅✅Between
The rrOracle rr_____ rrfunction rrcompares rran rrattribute rror rrexpression rrwith rra rrseries
rrof rrvalues rrand rrreturns rran rrassociated rrvalue rror rra rrdefault rrvalue rrif rrno rrmatch rris
rrfound. rr- rrCORRECT✅✅DECODE
Which rrquery rris rrused rrto rrlist rra rrunique rrvalue rrfor rrV_CODE, rrwhere rrthe rrlist rrwill
rrproduce rronly rra rrlist rrof rrthose rrvalues rrthat rrare rrdifferent rrfrom rrone rranother? rr-
rrCORRECT✅✅Distinct
Oracle rrusers rrcan rruse rrthe rrAccess rrQBE rr(query rrby rrexample) rrquery rrgenerator. rr-
rrCORRECT✅✅false
The rrspecial rroperator rrused rrto rrcheck rrwhether rra rrsubquery rrreturns rrany rrrows rris
rr_____. rr- rrCORRECT✅✅EXISTS
The rrsyntax rrfor rra rrleft rrouter rrjoin rris rr_____. rr- rrCORRECT✅✅SELECT rrcolumn-list
FROM rrtable1 rrLEFT rr[OUTER] rrJOIN rrtable2
ON rrjoin-condition
Most rrSQL rrimplementations rryield rrcase-insensitive rrsearches. rr-
rrCORRECT✅✅False
Which rrcomparison rroperator rrindicates rra rrvalue rris rrnot rrequal? rr- rrCORRECT✅✅<>
Some rrRDBMSs, rrsuch rras rrMicrosoft rrAccess, rrautomatically rrmake rrthe rrnecessary
rrconversions rrto rreliminate rrcase rrsensitivity. rr- rrCORRECT✅✅True
All rrchanges rrin rra rrtable rrstructure rrare rrmade rrusing rrthe rr_____ rrTABLE rrcommand,
rrfollowed rrby rra rrkeyword rrthat rrproduces rrthe rrspecific rrchanges rra rruser rrwants rrto
rrmake. rr- rrCORRECT✅✅ALTER
The rrOracle rrequivalent rrto rran rrMS rrAccess rrAutoNumber rris rra(n) rr_____. rr-
rrCORRECT✅✅sequence
A rrstatement-level rrtrigger rris rrassumed rrif rra rrdesigner rromits rrthe rrFOR rrEACH rrROW
rrkeywords. rr- rrCORRECT✅✅True
Solutions
ANSI-standard rrSQL rrallows rrthe rruse rrof rrspecial rroperators rrin rrconjunction rrwith rrthe
rrWHERE rrclause. rr- rrCORRECT✅✅True
When rrusing rrthe rrOracle rrTO_DATE rrfunction, rrthe rrcode rr_____ rrrepresents rra rrthree-
letter rrmonth rrname. rr- rrCORRECT✅✅MON
The rrANSI rrSQL rrstandards rrare rralso rraccepted rrby rrthe rrISO. rr- rrCORRECT✅✅True
_____ rris rra rrrelational rrset rroperator. rr- rrCORRECT✅✅except
In rrsubquery rrterminology, rrthe rrfirst rrquery rrin rrthe rrSQL rrstatement rris rrknown rras rrthe
rr_____ rrquery. rr- rrCORRECT✅✅outer rrquery
How rrmany rrrows rrwould rrbe rrreturned rrfrom rra rrcross rrjoin rrof rrtables rrA rrand rrB, rrif rrA
rrcontains rr8 rrrows rrand rrB rrcontains rr18? rr- rrCORRECT✅✅144
Date rrprocedures rrare rroften rrmore rrsoftware-specific rrthan rrother rrSQL rrprocedures. rr-
rrCORRECT✅✅True
When rrusing rra(n) rr_____ rrjoin, rronly rrrows rrfrom rrthe rrtables rrthat rrmatch rron rra
rrcommon rrvalue rrare rrreturned. rr- rrCORRECT✅✅inner
The rr_____ rrfunction rrreturns rrthe rrcurrent rrsystem rrdate rrin rrMS rrAccess. rr-
rrCORRECT✅✅DATE()
Comparison rroperators rrcannot rrbe rrused rrto rrplace rrrestrictions rron rrcharacter-based
rrattributes. rr- rrCORRECT✅✅False
The rrSQL rrdata rrmanipulation rrcommand rrHAVING: rr- rrCORRECT✅✅restricts rrthe
rrselection rrof rrgrouped rrrows rrbased rron rra rrcondition.
If rra rrdesigner rrwishes rrto rrcreate rran rrinner rrjoin, rrbut rrthe rrtwo rrtables rrdo rrnot rrhave
rra rrcommonly rrnamed rrattribute, rrhe rrcan rruse rra(n) rr_____ rrclause. rr-
rrCORRECT✅✅Join rrOn
Numeric rrfunctions rrtake rrone rrnumeric rrparameter rrand rrreturn rrone rrvalue. rr-
rrCORRECT✅✅true
Which rris rra rrfeature rrof rra rrcorrelated rrsubquery? rr- rrCORRECT✅✅The rrouter
rrsubquery rrinitiates rrthe rrprocess rrof rrexecution rrin rra rrsubquery.
, What rrtype rrof rrcommand rrdoes rrthis rrSQL rrstatement rruse?
SELECT rrP_CODE, rrP_DESCRIPT, rrP_PRICE_V_NAME
FROM rrPRODUCT, rrVENDOR
WHERE rrPRODUCT.V_CODE=VENDOR. rrV_CODE rr- rrCORRECT✅✅old rrstyle rrjoin
The rrspecial rroperator rrused rrto rrcheck rrwhether rran rrattribute rrvalue rris rrwithin rra
rrrange rrof rrvalues rris rr_____. rr- rrCORRECT✅✅Between
The rrOracle rr_____ rrfunction rrcompares rran rrattribute rror rrexpression rrwith rra rrseries
rrof rrvalues rrand rrreturns rran rrassociated rrvalue rror rra rrdefault rrvalue rrif rrno rrmatch rris
rrfound. rr- rrCORRECT✅✅DECODE
Which rrquery rris rrused rrto rrlist rra rrunique rrvalue rrfor rrV_CODE, rrwhere rrthe rrlist rrwill
rrproduce rronly rra rrlist rrof rrthose rrvalues rrthat rrare rrdifferent rrfrom rrone rranother? rr-
rrCORRECT✅✅Distinct
Oracle rrusers rrcan rruse rrthe rrAccess rrQBE rr(query rrby rrexample) rrquery rrgenerator. rr-
rrCORRECT✅✅false
The rrspecial rroperator rrused rrto rrcheck rrwhether rra rrsubquery rrreturns rrany rrrows rris
rr_____. rr- rrCORRECT✅✅EXISTS
The rrsyntax rrfor rra rrleft rrouter rrjoin rris rr_____. rr- rrCORRECT✅✅SELECT rrcolumn-list
FROM rrtable1 rrLEFT rr[OUTER] rrJOIN rrtable2
ON rrjoin-condition
Most rrSQL rrimplementations rryield rrcase-insensitive rrsearches. rr-
rrCORRECT✅✅False
Which rrcomparison rroperator rrindicates rra rrvalue rris rrnot rrequal? rr- rrCORRECT✅✅<>
Some rrRDBMSs, rrsuch rras rrMicrosoft rrAccess, rrautomatically rrmake rrthe rrnecessary
rrconversions rrto rreliminate rrcase rrsensitivity. rr- rrCORRECT✅✅True
All rrchanges rrin rra rrtable rrstructure rrare rrmade rrusing rrthe rr_____ rrTABLE rrcommand,
rrfollowed rrby rra rrkeyword rrthat rrproduces rrthe rrspecific rrchanges rra rruser rrwants rrto
rrmake. rr- rrCORRECT✅✅ALTER
The rrOracle rrequivalent rrto rran rrMS rrAccess rrAutoNumber rris rra(n) rr_____. rr-
rrCORRECT✅✅sequence
A rrstatement-level rrtrigger rris rrassumed rrif rra rrdesigner rromits rrthe rrFOR rrEACH rrROW
rrkeywords. rr- rrCORRECT✅✅True