Question 34:
See the Exhibit:
Here is the structure of the EMPLOYEES table that exists in your schema:
You successfully create a GET_MAX procedure to find the maximum salary in the department of a specified employee. You then code a PL/SQL block to display the maximum salary in the departments of the first five employees in the EMPLOYEES table. Examine in exhibit the procedure and the block of PL/SQL code, What is the outcome of executing the block of PL/SQL code?
Answer options:
A. It executes successfully and gives the required output B. It gives an error because ROWNUM cannot be used in cursor definitions C. It gives an error because usage of the %ROWCOUNT attribute is not valid D. It executes successfully but does not give the required output because the procedure call resets the %ROWCOUNT value