Free Practice Oracle 1Z0-149 Exam Questions 2025

Stay ahead with 100% Free Oracle Database 19c: Program with PL/SQL 1Z0-149 Dumps Practice Questions

Page: 1 / 78

Total 389 Questions | Updated On: Mar 27, 2025

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

Which kind of parameters cannot have a DEFAULT value?

A : OUT

B : IN

C : CONSTANT

D : R(ead)

E : W(rite)

Answer: A

Question 3

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 4

Which of the following is true about database transactions?

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 5

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

Page: 1 / 78

Total 389 Questions | Updated On: Mar 27, 2025

Add To Cart