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: Mar 06, 2026

Add To Cart

Question 1

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 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

View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?

A : It executes successfully and gives the desired output.

B : It does not execute because the definition of type population is indexed by VARCHAR2.

C : It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

D : It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

Answer: C

Question 4

What can the value of the INTO clause be while fetching data in an explicit cursor?

A : PL/SQL scalar variables only

B : PL/SQL variables or records

C : Collections or records only

D : Records only

Answer: B

Question 5

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

A : Line 2

B : Line 3

C : Line 4

D : Line 5

E : Line 6

Answer: A

Page: 1 / 78

Total 389 Questions | Updated On: Mar 06, 2026

Add To Cart