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: Apr 27, 2026

Add To Cart

Question 1

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

2021-06-04-19-34-43-bbbe9e3ac276119b5b1b2648c6325d40

You create the following trigger to ensure that customers belonging to category "A" or "B"
in the customer table can have a credit limit of more than 8000.

What is the outcome?

A : The trigger is fired, a message is displayed, and the update is successful

B : The trigger is fired and a message is displayed, but the update is rolled back.

C : The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

D : The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

Answer: A

Question 2

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 3

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

A : True

B : False

Answer: B

Question 4

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

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: Apr 27, 2026

Add To Cart