Choose all the correct options

Question

see the exhibit: ghere is the structure of the employees table that exists in your schema: gyou 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?

Accepted Answer

It executes successfully and gives the required output

Answer

It gives an error because ROWNUM cannot be used in cursor definitions

Answer

It gives an error because usage of the %ROWCOUNT attribute is not valid

Answer

It executes successfully but does not give the required output because the procedure call resets the %ROWCOUNT value

See the Exhibit:

0 Discussions

Trending Exams