evaluate the following pl sql block declare result boolean begin delete from..., Oracle PL/Sql 10g, Databases

Test
- Model Test
Index

Question:Evaluate the following PL/SQL block:
DECLARE
result BOOLEAN;
BEGIN
DELETE FROM EMPloyee
WHERE dept_id IN (10,40,50);
result:=SQL%ISOPEN;
COMMIT:
END;

What will be the value of RESULT if three rows are deleted?

A 0 
B 3 
C TRUE 
D NULL 
E FALSE

/50

+ AnswerE

+ Report

Descriptive on Oracle PL/Sql 10g Ebook

Total Preview: 3011

Question:Evaluate the following PL/SQL block: DECLARE result BOOLEAN; BEGIN DELETE FROM EMPloyee WHERE dept_id IN (10,40,50); result:=SQL%ISOPEN; COMMIT: END; What will be the value of RESULT if three rows are deleted?

A 0

B 3

C TRUE

D NULL

E FALSE

E