Multiple choice

A declared cursor variable is not responsible for _______ in Oracle P/L SQL.

  1. REF CURSOR type stores the RECORD type of cursor variables.

  2. The compiler does not allow the weak type of cursor variables for queries.

  3. Strong REF CURSOR types are less error-prone than weak types but less flexible.

  4. The compiler allows only the weak types cursor variables for queries.

  5. The compiler provides the specification of all the variables.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The PL/SQL compiler does not allow to use the strongly typed cursor variables for queries that return rows that are not of the return type.

Keep practicing — related questions