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: Jun 16, 2026

Add To Cart

Question 1

Select incorrect variable declarations

A : foo_number varchar2(10);

B : foo_text number(10);

C : foo_char char(1) := 'Y';

D : foo_time date;

E : foo_text varchar2(10) := 'hello world';

Answer: A

Question 2

Examine this PL/SQL function:

What happens when the function is created with PLSQL_WARNINGS set to ENABLE: ALL?

A : There are no compilation warnings or errors.

B : It fails compilation.

C : An information compilation warning is generated.

D : A performance compilation warning is generated.

E : A severe compilation warning is generated.

Answer: C

Question 3

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

A : DISABLE

B : ENABLE

C : ERROR

D : ALL

E : SEVERE

Answer: A,D

Question 4

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

Question 5

Which system events can be used to create triggers that fire both at database and schema
levels? (Choose all that apply)

A : AFTER LOGON

B : AFTER STARTUP

C : BEFORE SHUTDOWN

D : AFTER SERVERERROR

Answer: A,D

Page: 1 / 78

Total 389 Questions | Updated On: Jun 16, 2026

Add To Cart