Choose all the correct options

Question

examine the following pl/sql code:gwhich statement is true about the execution of the code if the query in the pl/sql block returnsno rows?

Accepted Answer

The program abruptly terminates and an exception is raised.

Answer

The program executes successfully and the output is No ROWS_FOUND.

Answer

The program executes successfully and the query fetches a null value in the V_LNAME variable.

Answer

Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raised.

Examine the following PL/SQL code: