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: Oct 27, 2025

Add To Cart

Question 1

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 2

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 3

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

Question 4

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

A : True

B : False

Answer: A

Question 5

Which of the following is not true about the Constructors?

A : These are functions that return a new object as its value.

B : Every object has a system defined constructor method.

C : The name of the constructor is same as the object type.

D : None of the above.

Answer: D

Page: 1 / 78

Total 389 Questions | Updated On: Oct 27, 2025

Add To Cart