ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

34 / 68

Question 34:

See the Exhibit: 
image
Here is the structure of the EMPLOYEES table that exists in your schema: 
image
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