Question 7
The STUDENTS table with column LAST_NAME of data type VARCHAR2 exists in your database schema.
Examine this PL/SQL block:
Which two actions must you perform for this PL/SQL block to execute successfully?
Replace the FOR loop with FOR name_rec IN names_varray.FIRST .. names_varray.LAST LOOP.
Replace the L_NAME_TYPE declaration with TYPE 1_name_type IS VARRAY (25) OF SYS_REFCURSOR;
Add name_rec name_cur%ROWTYPE; at the end of the DECLARE section.
Replace the NAMES_VARRAY declaration with names_varray 1_name_type := 1_name_type ();
Replace the NAMES_VARRAY declaration with names_varray 1_name_type := null;
Add names_varray.EXTEND after the FOR …LOOP statement.
Correct answer: EF