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
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)- A2% (1)
- B4% (2)
- C84% (42)
- D10% (5)
Community Discussion
No community discussion yet for this question.
