Using Explicit Cursor Attributes

Test:Quiz:UsingExplicitCursorAttributes 1. You Youc can anr ref efer eren ence cee exp xpli lici cit tcu curs rsor ora att ttri ribu bute tes sdi dire rect ctly lyi in na aSQ SQL Lst stat atem emen en t.T t.Tru rue eor orF Fal alse se? ? Mark Markf for orR Rev evie iew w (1)Points True False(*)

Correct 2. How Howm mus ust tyo you ure refe fere renc nce eon one efi fiel eld dwh whic ich his isp par art tof ofa aP PL/ L/SQ SQL Lre reco cord rd? ? MarkforReview (1)Points field_name.record_name record_name.field_name(*) record_name(field_name) field_nameOFrecord_name Itcannotbedone.

Correct 3. Whi Which cho of fth the efo foll llow owin ing gex expl plic icit itc cur urso sor rat attr trib ibut utes ese eva valu luat ates est to oTR TRUE UEi if f themostr themostrecent ecentFETC FETCHret Hreturns urnsarow arow? ? MarkforR MarkforReview eview (1)Points %ISOPEN %NOTFOUND %FOUND(*) %ROWCOUNT

Correct 4.

Lo o k a t t h e f o l l o w i n g c o d e :

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.



DECLARE CURSORemp_cursorIS SELECTemployee_id,last_name,salary FROMemployees; v_empcursemp_cursor%ROWTYPE; WhatisthedatatypeofV_EMPCURS? MarkforReview (1)Points Scalar Record(*) Cursor Row

Correct 5. E x a m i n e th e f o l l o w i n g c o d e: DECLARE CURSORcountry_cursIS SELECTcountry_id,country_name FROMwf_countries ORDERBYcountry_name; v_countrycountry_curs%ROWTYPE; BEGIN OPENcountry_curs; LOOP FETCHcountry_cursINTOv_country; EXITWHENcountry_curs%NOTFOUND; -------LineA ENDLOOP; CLOSEcountry_curs; END; YouwanttodisplaytheidandnameofeachFETCHedcountry.Whatwould YouwanttodisplaytheidandnameofeachFE TCHedcountry.Whatwouldyoucode youcode atLineA? MarkforReview (1)Points DBMS_OUTPUT.PUT_LINE(country_id||''||country_name);



DBMS_OUTPUT.PUT_LINE(v_country.country_id||''||v_country.country_n DBMS_OUTPUT.PUT_LINE(v_country.country_id||' '||v_country.country_na a me);(*)

Correct 6. You Youha have ved dec ecl lared aredt the hef fol ollo lowi wing ngc cur urso sor: r: CURSORcountry_cursIS SELECT*FROMwf_countries ORDERBYcountry_name; Thereareover200rowsintheWF_COUNTRIEStable,butyouwanttofetc Thereareover200rowsintheWF_COUNTRIESta ble,butyouwanttofetchanddis handdis playonlythefirst25rows. HowwouldyouexitfromtheFETCHloop? MarkforReview (1)Points EXITWHENcountry_curs%FOUND(25); EXITWHENcountry_curs%ROWCOUNT>25;(*) EXITWHENROWCOUNT>25; WHENcountry_curs>25THENEXIT;ENDIF;

Correct 7. L o o k a t th e s e d e c l a r a t i o n s : DECLARE CURSORdept_loc_cursorIS SELECTdepartment_id,department_name,location_name FROMdepartmentsd,locationsl WHEREd.location_id=l.location_id; v_dept_locdept_loc_cursor%ROWTYPE; HowmanyfieldsdoesV_DEPT_LOCcontain? MarkforReview (1)Points Two,becausethecursorjoinstwotables



None

Correct

Using Explicit Cursor Attributes

Recommend Documents