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?
A. The program abruptly terminates and an exception is raise
B. The program executes successfully and the output is No ROWS_FOUN
C. The program executes successfully and the query fetches a null value in the V_LNAME variabl
D. Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raise
Correct Answer:A