nerdexam
Oracle

1Z0-144 · Question #99

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?

The correct answer is C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found. See the full explanation below for the reasoning.

Question

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?

Exhibit

1Z0-144 question #99 exhibit

Options

  • AThe execution fails because of the misplaced else clause.
  • BThe execution is successful even if there is no employee with EMPLOYEE_ID 115.
  • CThe execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
  • DThe execution is successful, but it displays an incorrect output if no employee with

How the community answered

(50 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    84% (42)
  • D
    10% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice