• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 10 pages
Exam (elaborations)

BCIS 4620 Final

Document preview thumbnail
Preview 2 out of 10 pages

Exam of 10 pages for the course BCIS 4620 at BCIS 4620 (BCIS 4620 Final)

Content preview

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

Document information

Uploaded on
June 26, 2025
Number of pages
10
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$15.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Sold
0
Followers
0
Items
776
Last sold
-



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions