Cursor for Loops

Test:Quiz:CursorFORLoops 1. Wha What tis isw wro rong ngw wit ith hth the efo foll llow owin ing gpi piec ece eof ofc cod ode? e? BEGIN FORemp_recordINemp_cursorLOOP DBMS_OUTPUT.PUT_LINE(emp_record.last_name); ENDLOOP; IFemp_record.last_name='Patel'THEN... MarkforReview (1)Points

EMP_RECORDhasnotbeenexplicitlydeclared.

ThecursorhasnotbeenOPENed.

YoucannotreferenceEMP_RECORDoutsidetheloop.(*)

Itshouldread:DBMS_OUTPUT.PUT_LINE(emp_cursor.last_name);

Nothingiswrong,thecodewillexecutecorrectly.

Correct 2. You Youha have ved dec ecl lared areda ac cur urso sor ras asf fol ollo lows ws: : CURSORloc_cursISSELECT*FROMlocations; HowshouldyoucodeaFORlooptousethiscursor? MarkforReview (1)Points

FORloc_recIN1..loc_curs%ROWCOUNTLOOP...

WHILEloc_recINloc_cursLOOP...

FORloc_cursINloc_recLOOP...

IFloc_recINloc_cursLOOP...

FORloc_recINloc_cursLOOP...(*)

Correct 3. Look at the following code: DECLARE CURSORemp_cursorISSELECT*FROMemployees;

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.

BEGIN FORemp_recordINemp_cursorLOOP DBMS_OUTPUT.PUT_LINE(--PointA--); ENDLOOP; END; Todisplaythesalaryofanemployee,whatcod Todisplaythesalary ofanemployee,whatcodeshouldyouwriteatPoi eshouldyouwriteatPointA? ntA? MarkforReview (1)Points

emp_record.salary(*)

emp_cursor.salary

employees.salary

emp_record.employees.salary

TO_CHAR(salary)

Correct 4. Whi Which cho one neo of fth the efo foll llow owin ing gis isa av val alid idc cur urso sor rFO FOR Rlo loop opw wit ith ha asu subq bque uery ry? ? MarkforReview (1)Points

FORemp_recIN(SELECTlast_name||first_name FORemp_recIN(SELECT last_name||first_nameFROMemployees)LOOP... FROMemployees)LOOP...

FORemp_recIN(SELECTUPPER(last_name)FROMe FORemp_recIN(SELECT UPPER(last_name)FROMemployees)LOOP... mployees)LOOP...

FORemp_recINSELECTlast_name,salary*12"AN FORemp_recINSELECT last_name,salary*12"ANNSAL"FROMemployeesLOOP NSAL"FROMemployeesLOOP ...

FORemp_recIN(SELECTlast_name,salary*12"A FORemp_recIN(SELECT last_name,salary*12"ANNSAL"FROMemployees)LO NNSAL"FROMemployees)LOO O P...(*)

Noneoftheabove.

Correct

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.

True(*)

False

Correct 6. Wha What tis ist the heD DIS ISad adva vant ntag age eof ofu usi sing nga ac cur urso sor rFO FOR Rlo loop opw wit ith ha asu subq bque uery ry? ? MarkforReview (1)Points

Youcannotreferencecursorattributessuchas%NOTFOUND.(*)

Theexecutionspeedisslower.

Youcannotdeclarethecursorinthedeclarationsection.

Youcannotusethecursortojointwoormoretables.

Therearenodisadvantages.

Correct 7. Whi Which cho of fth the efo foll llow owin ing gis isa ab ben enef efit ito of fus usin ing ga acu curs rsor orF FOR ORl loo oop? p? MarkforReview (1)Points

Theexceptionhandlingisdoneautomatically..

TheOPEN,CLOSE,FETCHandEXITfromtheloop TheOPEN,CLOSE,FETCH andEXITfromthelooparedoneautomatically.( aredoneautomatically.(* * )

YoucanOPENthesamecursortwiceatthesametime.

Becausethereislesscode,theloopexecutesfaster.

%ROWCOUNTincrementsautomaticallyeachtimearowisFETCHed.