Practice 1Z0-149 Exam Online

Question 1

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 2

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 3

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

A : DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

B : To execute chunks in parallel, users must have CREATE JOB system privilege

C : No specific system privileges are required to create or run parallel execution tasks

D : Only DBAs can create or run parallel execution tasks.

E : Users with CREATE TASK privilege can create or run parallel execution tasks.

Answer: B

Question 4

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 5

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

A : True

B : False

Answer: A

Name:	Oracle Database 19c: Program with PL/SQL
Exam Code:	1Z0-149
Certification:	OPN Certified Specialist
Vendor:	Oracle
Total Questions:	389
Last Updated:	Apr 25, 2024

Oracle 1Z0-149