Free Oracle 1z0-148 Exam Dumps Questions & Answers


Exam Code/Number:	1z0-148Join the discussion
Exam Name:	Oracle Database: Advanced PL/SQL
Certification:	Oracle
Free Question Number:	108
Publish Date:	Sep 27, 2026
# of views:	6475
Rating 100%

Page: 1 / 22
Total 108 questions

Question 1

Which three statements are correct with reference to intra unit inlining?

A.Programs that make use of smaller helper subroutines are good candidates for inlining.
B.You cannot inline local subroutines.
C.Inlining will always decrease the size of a unit.
D.You cannot inline an external subroutine.
E.Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
F.Pragmas apply only to calls in the next statement following the pragma.

Question 2

Examine this code:

The anonymous block fails with:
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 5
Which two are valid options to prevent this error from occurring?

A.pdatabuf (1) := NULL; should be added after line 4.
B.Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);
C.Rewrite the block as:DECLARETYPE databuf_arr IS TABLE OF CLOB INDEX BY BINATY_INTEGER;pdatabuf databuf_arr;PROCEDURE mytemplob (x OUT CLOB) ISBEGINDBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB, SESSION);END;BEGINmytemplob (pdatabuf (1));END;/
D.Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);
E.Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

Question 3

Select a valid reason for using VARRAYS.

A.When the amount of data to be held in the collection is widely variable.
B.When you want to delete elements from the middle of the collection.
C.As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.
D.As a column in a table when you want to store no more than 10 elements in each row's collection.

Question 4

Examine these statements:

Which two corrections will allow this anonymous block to execute successfully?

A.Add wk#. EXTEND (1); before the 5th line.
B.Add i PLS_INTEGER; before the 3rd line.
C.Add wk# .NEXT; before the 7th line.
D.Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i);
E.Change line #2 to wk# tp_test# := tp_test# (tp_rec# ());

Question 5

Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?

A.The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.
B.The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.
C.This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,
D.The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.