Free 1Z0-149 Exam Questions - Easiest Way for Success

Prepare for the Oracle 1Z0-149 exam questions with our authentic preparation materials, including free 1Z0-149 practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the Oracle Database 19c: Program with PL/SQL 1Z0-149 exam. This dedication to student success is why we have the most satisfied 1Z0-149 certification exam candidates worldwide.

Page: 1 / 78

Total 389 Questions | Updated On: Sep 14, 2024

Add To Cart

Question 1

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 2

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with

%ROWTYPE? (Choose three.)

A : CREATE

B : DROP

C : UPDATE

D : SELECT

E : DELETE

F : ALTER

G : INSERT

Answer: A,C,D

Question 3

A : Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

B : Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

C : Rewrite the block as:

D : pdatabuf (1) := NULL; should be added after line 4.

E : Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);

Answer: C,D

Question 4

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

Question 5

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

Page: 1 / 78

Total 389 Questions | Updated On: Sep 14, 2024

Add To Cart