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 08, 2025

Add To Cart

Question 1

Examine this code (all compiled into schema HR):

Execute this code:
SET SERVEROUTPUT ON
EXEC test_pkg.do_stuff –
What is the correct output?

A :

B :

C :

D :

E :

Answer: C

Question 2

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger:

SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

A : Only HR

B : SCOTT and HR

C : Only SCOTT

D : SCOTT, HR, and SYS

Answer: A

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

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

A : ALL_SOURCE

B : ALL_DEPENDENCIES

C : ALL_OBJECTS

D : ALL_PROCEDURES

E : ALL_PLSQL_OBJECT_SETTINGS

Answer: D

Question 5

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

A : True

B : False

Answer: B

Page: 1 / 78

Total 389 Questions | Updated On: Dec 08, 2025

Add To Cart