ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

38 / 68

Question 38:

Which two statements are true about REF CURSOR types? (Choose two.) 

Answer options:

A. REF CURSOR types cannot be defined inside a package
B. SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions
C. A REF CURSOR return type can be delcared using %TYPE or %ROWTYPE or a user-defined record
D. Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function