Be selective with your SELECTs!

The Oracle PL/SQL language makes it really easy to query data from tables in the database. Answer the following multiple choice questions to see how well you understand the nuances of using the SELECT statement inside PL/SQL programs.

A.

DECLARE
   TYPE employees_array IS TABLE OF employees%ROWTYPE
       INDEX BY PLS_INTEGER;
   l_employees employees_array;
BEGIN
   SELECT * INTO l_employees FROM employees;
END;

B.

DECLARE
   TYPE employees_array IS TABLE OF employees%ROWTYPE
       INDEX BY PLS_INTEGER;
   l_employees employees_array;
BEGIN
   SELECT * BULK COLLECT INTO l_employees FROM employees;
END;

C. 

DECLARE
   TYPE employees_array IS TABLE OF employees%ROWTYPE
      INDEX BY PLS_INTEGER;
   l_employees employees_array;
BEGIN
   SELECT * MULTISET COLLECT INTO l_employees FROM employees;
END;

D.

DECLARE
   TYPE employees_array IS TABLE OF employees%ROWTYPE
       INDEX BY PLS_INTEGER;
   l_employees employees_array;
BEGIN
   FOR l_employees IN ( SELECT * FROM employees) 
   LOOP
      DBMS_OUTPUT.PUT_LINE (l_employees (index).last_name);
   END LOOP;
END;