100% Free Oracle 1Z0-149 Practice Test Questions and Answers 2026

Start Learning with the Latest and Real 100% Free Oracle 1Z0-149 Exam Questions

Page: 1 / 78

Total 389 Questions | Updated On: May 22, 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 of the following is not true about labeling PL/SQL loops?

A : PL/SQL loops can be labeled.

B : The label should be enclosed by angle brackets (< and >).

C : The label name appears at the beginning of the LOOP statement.

D : The label name can also appear at the end of the LOOP statement or with an EXIT statement.

Answer: B

Question 3

Which kind of parameters cannot have a DEFAULT value?

A : OUT

B : IN

C : CONSTANT

D : R(ead)

E : W(rite)

Answer: A

Question 4

Subprograms and anonymous blocks can be called by other applications. True or False?

A : True

B : False

Answer: B

Question 5

View the Exhibit and examine the structure of the EMP table.

Examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

A : It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

B : It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

C : It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

D : It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

Answer: B

Page: 1 / 78

Total 389 Questions | Updated On: May 22, 2026

Add To Cart