Practice exercise

1. What are the possible reasons that cause the INVALID_CURSOR exception to occur?

   1. The cursor result set has not been fetched.

   2. The cursor does not have parameters.

   3. The value of the%ROWCOUNT attribute has been referenced after closing the cursor.

   4. The cursor result set has been fetched into a non matching variable.

2. Identify the guidelines to be considered when designing cursors in a PL/SQL block:

   1. Explicit cursors must be used irrespective of the number of records returned by the query.

   2. Cursor FOR loops must be used as it implicitly takes care of the OPEN, FETCH, and CLOSE stages.

   3. Cursor data must be fetched as a record.

   4. Use ROWNUM to index the records in the cursor result sets.

3. While processing DMLs as implicit cursors in the PL/SQL executable block, implicit cursor attributes can be used anywhere in the block.

   1. True

   2. False

4. From the following, identify the two correct statements about the REF CURSOR types:

   1. Ref cursors are reference pointers to cursor objects

   2. REF CURSOR types can be declared...