Question 1

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

Options :

A :

B :

C :

D :

Answer: D

Question 2

Which of the following is not true about labeling PL/SQL loops?

Options :

A : PL/SQL loops can be labeled.

B : The label should be enclosed by angle brackets (< and >).

C : The label name appears at the beginning of the LOOP statement.

D : The label name can also appear at the end of the LOOP statement or with an EXIT statement.

Answer: B

Question 3

Which is true about counter variables in a FOR loop?

Options :

A : It must explicitly be declared.

B : It can be modified in the body of the loop.

C : It cannot be NULL.

D : It is accessible outside the body of the loop.

Answer: C

Question 4

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 5

Which of the following is true about PL/SQL index-by tables?

Options :

A : It is a set of key-value pairs.

B : Each key is unique and is used to locate the corresponding value.

C : The key can be either an integer or a string.

D : All of the above.

Answer: D