Question 1

The collection method COUNT

Options :

A : Returns the last (largest) index numbers in a collection that uses integer subscripts.

B : Returns the number of elements that a collection currently contains.

C : Checks the Maximum Size of a Collection

D : None of the above.

Answer: B

Question 2

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

Options :

A : True

B : False

Answer: A

Question 3

If left out, which of the following would cause an infinite loop to occur in a simple loop?

Options :

A : LOOP

B : END LOOP

C : IF-THEN

D : EXIT

Answer: B

Question 4

Options :

A : Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

B : Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

C : Rewrite the block as:

D : pdatabuf (1) := NULL; should be added after line 4.

E : Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);

Answer: C,D

Question 5

Examine this code (all compiled into schema HR):Execute this code: SET SERVEROUTPUT ON EXEC test_pkg.do_stuff –What is the correct output?

Options :

A :

B :

C :

D :

E :

Answer: C