View the exhibit to examine the PL/SQL code.
Which statement is true about the exception handlers in the PL/SQL code?
A. All the exceptions in the code are trapped by the exception handler.
B. All the "no data found" errors in the code are trapped by the exception handler.
C. The PL/SQL program does not execute because an exception is not declared in the declare section.
D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.
Correct answer: B.
Not A. To trap all the exceptions, ‘WHEN OTHERS’ should have been used
Not C. NO_DATA_FOUND is a predefined exception
Not D. After an exception handler runs, the current block stops executing and the enclosing block resumes with the next statement. If there is no enclosing block, control returns to the host environment.
References:
https://docs.oracle.com/cd/B10501_01/appdev.920/a96624/07_errs.htm