Free Oracle 1Z0-149 Exam Questions

Become Oracle Certified with updated 1Z0-149 exam questions and correct answers

Page: 1 / 78

Total 389 Questions | Updated On: Jan 27, 2026

Add To Cart

Question 1

Subprograms are named PL/SQL blocks that can be called with a set of parameters.

A : True

B : False

C : Depends upon

D : None of the above

Answer: A

Question 2

PL/SQL is a completely portable, ??? transaction processing language.

A : Low-performance

B : High-performance

C : Both 1 & 2

D : None of the above

Answer: B

Question 3

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

A : ALL_SOURCE

B : ALL_DEPENDENCIES

C : ALL_OBJECTS

D : ALL_PROCEDURES

E : ALL_PLSQL_OBJECT_SETTINGS

Answer: D

Question 4

The collection method COUNT

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 5

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

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

Page: 1 / 78

Total 389 Questions | Updated On: Jan 27, 2026

Add To Cart