See the Exhibit:
Examine the structure of the DEPARTMENTS table:
Examine the code in exhibit, you plan to use for creating a package to botain the details of an employee using a host variable on the client side in SQL *Plus, you plan to use the following commands:
The package executes successfully and passes the required data to the host variable
Which statement is true about the above scenario?
A. The package executes successfully and passes the required data to the host variable
B. The package specification gives an error on compilation because cursor variable types cannot be defined in the specification
C. The package specificatin gives an error on compilation because the cursor variable parameter was specified before you defined it
D. The package executes successfully but does not pass the required data to the host variable because the cursor is closed before the PRINT statement runs
|
Download Printable PDF. VALID exam to help you PASS. |
 |