Question 1

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 2

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 3

SERVEROUTPUT is enabled.

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

Options :

A :

B :

C :

D :

Answer: D

Question 4

View the Exhibit and examine the structure of the EMP table.

Examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

Options :

A : It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

B : It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

C : It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

D : It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

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

Higher Test Marks with Free Online 1Z0-149 Exam Practice