What is the value of vflag when the following plsql block


Q2. What is the value of v_flag when the following PL/SQL block is executed successfully? (I chose C)

DECLARE

v_flag BOOLEAN;

v_n NUMBER;

BEGIN

SELECT COUNT(*)

INTO v_n

FROM tab1;

v_flag := SQL%FOUND;

END;

A. The value is always FALSE.

B. The value is always NULL.

C. The value is always TRUE.

D. The value is FALSE if and only if the tab1 table is empty.

E. The value is TRUE if and only if the tab1 table is empty. 

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: What is the value of vflag when the following plsql block
Reference No:- TGS0579858

Expected delivery within 24 Hours