Question 12:
See the Exhibit:
Examine the strucutre of the EMPLOYEES and DEPARTMNETS tables. See the PL/SQL block that you execute to find the average salary for employees in the `Sales` department.
What is the outcome?
Answer options:
A. It executes successfully and gives the correct output B. It generates an error because the assocaitive array definition is not valid C. It generates an error because an assocaitive array cannot be passed to a procedure in OUT mode D. It generates an error because an associative array cannot be used with the SELECT INTO statement