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

SERVEROUTPUT is enabled.Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

Options :

A :

B :

C :

D :

Answer: D

Question 3

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

Options :

A : ALL_SOURCE

B : ALL_DEPENDENCIES

C : ALL_OBJECTS

D : ALL_PROCEDURES

E : ALL_PLSQL_OBJECT_SETTINGS

Answer: D

Question 4

What can the value of the INTO clause be while fetching data in an explicit cursor?

Options :

A : PL/SQL scalar variables only

B : PL/SQL variables or records

C : Collections or records only

D : Records only

Answer: B

Question 5

Examine the following DECLARE section of PL/SQL block:Which line in the above declaration would generate an error?

Options :

A : Line 2

B : Line 3

C : Line 4

D : Line 5

E : Line 6

Answer: A