View Exhibit1 and examine the structure of the EMPLOYEES table. View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60. Which statement is true about the outcome?
It generates an error because RECORD type cannot be used with varrays.
A. It generates an error because RECORD type cannot be used with varrays.
B. It generates an error because BULK COLLECT cannot be used with varrays.
C. It executes successfully only if department ID 60 has five or less than five employees.
D. It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.
|
Download Printable PDF. VALID exam to help you PASS. |
 |