Oracle
1Z0-144 · Question #53
Examine the following PL/SQL code: Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?
The correct answer is A. The program abruptly terminates and an exception is raised. See the full explanation below for the reasoning.
Question
Examine the following PL/SQL code:
Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?
Exhibit
Options
- AThe program abruptly terminates and an exception is raised.
- BThe program executes successfully and the output is No ROWS_FOUND.
- CThe program executes successfully and the query fetches a null value in the V_LNAME variable.
- DProgram executes successfully, fetches a NULL value in the V_LNAME variable and an exception
How the community answered
(17 responses)- A82% (14)
- C6% (1)
- D12% (2)
Community Discussion
No community discussion yet for this question.