Which two statements are true about REF CURSOR types?

  1. REF CURSOR types cannot be defined inside a package

  2. SYS_ REFCURSOR can be used to declare cursor variables in stored procedures and functions

  3. A REF CURSOR return type can be declared using %TYPE or %ROWTYPE or a user-defined record.

  4. Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.


Correct Option: B,C

Find more quizzes: