Cursors With Parameters

Test:Quiz:CursorswithParameters 1. You Youw wan ant tto tou use see exp xpli lici cit tcu curs rsor ors sto tof fet etch cha and ndd dis ispl play aya all llt the hec cou ount ntri ries es inaspecificregion.Thereare19rowsinth inaspecificregion. Thereare19rowsintheWF_WORLD_REGIONStable. eWF_WORLD_REGIONStable.Youwant Youwant touseadifferentregioneachtimethecurso touseadifferentre gioneachtimethecursorisopened.Howmanycur risopened.Howmanycursorsshou sorsshou ldyoudeclare? MarkforReview (1)Points 19cursors,allinthesamePL/SQLblock. 19cursorsin19PL/SQLblocks(oneineachblock). 20cursors,incaseanextrarowisinsertedi 20cursors,incasean extrarowisinsertedintoWF_WORLD_REGIONSlate ntoWF_WORLD_REGIONSlater r . OnecursorwithaparameterintheWHEREclause.(*) Noneoftheabove.

Correct 2. Usi Using ngp par aram amet eter ers swi with tha ac cur urso sor, r,y you ouc can ano ope pen nan and dcl clos ose eth the ecu curs rsor ors sev ever er altimesinablock,returningadifferentact altimesinablock,r eturningadifferentactiveseteachtime.Trueo iveseteachtime.TrueorFalse? rFalse? MarkforReview (1)Points True(*) False

Correct 3. The Thefo foll llow owin ing gcur curso sor rha has sbe been end dec ecla lare red: d: CURSORemp_curs (p_dept_idemployees.department_id%TYPE, p_job_idemployees.job_id%TYPE)IS SELECT*FROMemployees WHEREdepartment_id=p_dept_id ANDjob_id=p_job_id; Whichofthefollowingwillcorrectlyopenthecursor? MarkforReview (1)Points OPENemp_curs(20);

FORemp_recINemp_curs(20)LOOP... OPENemp_curs('IT_PROG',20); FORemp_recINemp_curs(20,'IT_PROG')LOOP...(*) FORemp_recINemp_curs(p_dept_idp_job_id)LOOP...

Correct 4. Lo o k a t t h e f o l l o w i n g c o d e : DECLARE CURSORemp_curs(p_dept_idemployees.depart CURSORemp_curs(p_ dept_idemployees.department_id%TYPE)IS ment_id%TYPE)IS SELECT*FROMemployees WHEREdepartment_id=p_dept_id; v_emp_recemp_curs%ROWTYPE; v_deptidNUMBER(4):=50; BEGIN OPENemp_curs(--PointA--); .... Youwanttoopenthecursor,passingvalue50totheparameter.Whicho Youwanttoopenthecursor,passingvalue50 totheparameter.Whichofthefol fthefol lowingarecorrectatPointA? MarkforReview (1)Points 50 v_deptid 100/2 Alloftheabove.(*)

Correct 5. Wha What tis isw wro rong ngw wit ith hth the efo foll llow owin ing gcu curs rsor ord dec ecla lara rati tion on? ? SELECT*FROMdepartments WHERElocation_id=p_loc_id; MarkforReview (1)Points YoucannotreferenceacursorparameterinaWHEREclause. Theparametershouldbecodedas:(p_loc_idNUMBER)(*)

Theparametershouldbecodedas:(p_loc_idINNUMBER) Nothingiswrong,thecursordeclarationiscorrect.

Correct