ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

12 / 68

Question 12:

See the Exhibit: 
image
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. 
image
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