Everything you need for Oracle Database: Advanced PL/SQL preparation lives in one place at Fast2test: a printable PDF, two test engines, free updates for 365 days, and a demo to try first. Grab the 1z1-148 package in 2026 and turn a vague study plan into a finished one.

Oracle 1z1-148 Exam Overview:

Oracle 1z1-148 Exam Syllabus Topics:

Oracle 1z1-148 Exam — Your Questions, Answered

Oracle Database: Advanced PL/SQL Sample Questions:

Question 1

Which two can be used to find details of parameters for overloaded PL/SQL routines?

A. ALL_DESCRIBE
B. ALL_SOURCE
C. ALL_PROCEDURES
D. ALL-DEPENDENCIES
E. ALL_ARGUMENTS

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 (1), TRUE, DBMS_LOB.CALL);
C. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);
D. 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;/
E. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

Question 3

Examine this Java method in class Employee, loaded into the Oracle database:
Public static int updateSalary (String name, float salary) {...}
Which PL/SQL specification can be used to publish this method?

A. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME 'int Employee.updateSalary (java.lang.String, float)';
B. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVALIBRARY "Employee" NAME "updateSalary"PARAMETERS (p_nm java.lang. String, p_sal float, RETURN int);
C. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME "Employee.updateSalary"PARAMETERS (p_nm java.lang.String, p_sal float, RETURN int);
D. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME "Employee.updateSalary"PARAMETERS ("name" java.lang.String,
"salary" float, RETURN int);
E. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME 'Employee.updateSalary (java.lang.String, float) return int';

Question 4

Examine this code:

The anonymous block fails this error stack:

Which two changes, when separately applied, would prevent these errors from occurring?

A. Initialize v1 and v2 with appropriate constructor functions.
B. Nothing because using the function TABLE (V1) is prohibited.
C. Define v1 as employees%ROWTYPE.
D. Define v2 as employees%ROWTYPE.
E. Define v2 as pkg. rec.

Question 5

Which two statements are true about the DBMS_ LOB package?

A. DBMS_LOB.COMPARE can compare parts of two LOBs.
B. Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.
C. DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.
D. DBMS_LOB.COMPARE returns the size difference of the compared LOBs.
E. If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.

Solutions: