Evaluate the following PL/SQL block:
DECLARE
v_low   NUMBER:=2;
v_upp   NUMBER:=100;
v_count NUMBER:=1;
BEGIN
FOR i IN v_low..v_low LOOP
INSERT INTO test(results)
VALUES (v_count)
v_count:=v_count+1;
END LOOP;
END;
How many times will the executable statements inside the FOR LOOP execute?

Which table should be queried to check the status of a function?

The technique employed by the Oracle engine to protect table data, when several people are accessing it is called:

Which two statements out of the following regarding packages are true?

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?

In which type of trigger can the OLD and NEW qualifiers can be used?

The technique employed by the Oracle engine to protect table data, when several people are accessing it is called:

Which table should be queried to check the status of a function?

Evaluate the following PL/SQL block: DECLARE v_low NUMBER:=2; v_upp NUMBER:=100; v_count NUMBER:=1; BEGIN FOR i IN v_low..v_low LOOP INSERT INTO test(results) VALUES (v_count) v_count:=v_count+1; END LOOP; END; How many times will the executable statements inside the FOR LOOP execute?

When the procedure or function is invoked, the Oracle engine loads the compiled procedure or function in the memory area called:

Which package construct must be declared and defined within the packages body?