A products TABLE exists with a PROD_ID column. Examine this PL/SQL block:
Which statement is true?
A. It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.
B. It executes successfully.
C. It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.
D. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);
E. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);
Answer: C,D
Thanks for the Post it is Very Informative But I want to Share my Experience with you that I Pass my Oracle PeopleSoft Exam Dumps at first attempt by getting Best Exam Preparation Material Form dumpshq.com They Really were Amazing and I recommend you to Get Certification Exam from Dumpshq.
ReplyDelete