nerdexam
Oracle

1Z0-144 · Question #82

View the exhibit to examine the PL/SQL code. Which statement is true about the exception handlers in the PL/SQL code?

The correct answer is B. All the "no data found" errors in the code are trapped by the exception handler. See the full explanation below for the reasoning.

Question

View the exhibit to examine the PL/SQL code. Which statement is true about the exception handlers in the PL/SQL code?

Exhibit

1Z0-144 question #82 exhibit

Options

  • AAll the exceptions in the code are trapped by the exception handler.
  • BAll the "no data found" errors in the code are trapped by the exception handler.
  • CThe PL/SQL program does not execute because an exception is not declared in the declare
  • DAn exception handler in the code traps the "no data found" error after executing the handler code

How the community answered

(43 responses)
  • A
    16% (7)
  • B
    72% (31)
  • C
    2% (1)
  • D
    9% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice