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: Dec 16, 2025

Add To Cart

Question 1

Which two blocks of code execute successfully?

A : DECLARE SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;my_val new_one;BEGIN my_val :=0;END;

B : DECLARE SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string;BEGIN my_str := abc;END;

C : DECLARE SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END;

D : DECLARE SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;my_val new_one;BEGIN my_val :=2;END;

E : DECLARE SUBTYPE new_one IS NUMBER (1, 0);my_val new_one; BEGIN my_val := -1

Answer: A

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

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 4

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

Question 5

If left out, which of the following would cause an infinite loop to occur in a simple loop?

A : LOOP

B : END LOOP

C : IF-THEN

D : EXIT

Answer: B

Page: 1 / 78

Total 389 Questions | Updated On: Dec 16, 2025

Add To Cart