View Exhibit1 and examine the structure of the EMP table. View Exhibit2 and examine the PIVSQL block of code. What is the outcome?

Question

Exhibits

Options

• AIt gives an error because the return type is not valid.
• BIt gives an error because the record type is not defined within the function
• CIt gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid
• DIt executes successfully and displays the names and salaries of all employees who earn the
• EIt executes successfully but does not display the names and salaries of all employees who earn

• A
  14% (3)
• B
  5% (1)
• D
  10% (2)
• E
  71% (15)

Explanation

If there are more than one employee who earn highest salary, then it will not display all the employees. It will display only one employee.

No community discussion yet for this question.