Question 1

Examine this PL/SQL function:What happens when the function is created with PLSQL_WARNINGS set to ENABLE: ALL?

Options :

A : There are no compilation warnings or errors.

B : It fails compilation.

C : An information compilation warning is generated.

D : A performance compilation warning is generated.

E : A severe compilation warning is generated.

Answer: C

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 of the following is true about database transactions?

Options :

A : The SQL statements that constitute a transaction can collectively be either committed, i.e., made permanent to the database or rolled back (undone) from the database

B : A transaction has a beginning and an end.

C : None of the above.

D : Both A and B.

Answer: D

Question 4

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 5

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

Free 1Z0-149 Mock Exam – Practice Online Confidently

Buying Options: