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: Sep 15, 2026

Add To Cart

Question 1

Which is true about counter variables in a FOR loop?

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 2

Which of the following is true about PL/SQL nested tables?

A : Nested tables are like one-dimensional arrays with arbitrary number of elements.

B : Unlike arrays a nested table doesn’t have declared number of elements. The size of a nested table can increase dynamically.

C : Initially a nested array has consecutive subscripts or dense, but it can become sparse when elements are deleted from it.

D : All of the above.

Answer: D

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

In which parameter mode Formal parameter acts like an initialized variable?

A : IN

B : OUT

C : IN OUT

D : None of the above

Answer: C

Question 5

Which is true about EXIT and CONTINUE statements?

A : They can be used in any type of loop.

B : They must have a WHEN condition.

C : They have the same effect on the execution of a loop.

D : They must use labels.

Answer: A

Page: 1 / 78

Total 389 Questions | Updated On: Sep 15, 2026

Add To Cart