Which statement is true about the execution of the code?

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.

Download Printable PDF. VALID exam to help you PASS.

2 thoughts on “Which statement is true about the execution of the code?

  1. 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;
    …..

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.