Multiple choice technology databases

If the below block, when you execute then what will be the output? Begin Null; Exception When others then Dbms_output.put_line(‘ I am in Others Exception’); When no_data_found then Dbms_output.put_line(‘ I am in no data found Exception’); End;

  1. I am in Others Exception

  2. I am in no data found Exception

  3. Compilation Error

  4. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

PL/SQL requires exception handlers in order: WHEN OTHERS must be last. Here, WHEN no_data_found appears after WHEN OTHERS, causing compilation error. Also, Null is not a valid executable statement.