View the Exhibit to examine the PL/SQL code.
SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?
A. The execution fails because of the misplaced else clause.
B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
c
Following error is thrown if no employee_id is found:
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 7
……
7 select job_id,salary into jobid,sal from employees
8 where employee_id=empid;
…..