Oracle 1z1-148 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-148
Exam Name/Title: Oracle Database: Advanced PL/SQL
Certification Provider: Oracle
Corresponding Certification: Oracle Database 12c

Exam Questions: 108
Updated On: Jul 11, 2026

Question #28

You are designing and developing a complex database application built using many dynamic SQL statements.
Which option could expose your code to SQL injection attacks?

A. Using bind variables instead of directly concatenating parameters into dynamic SQL statements

B. Using automated tools to generate code

C. Validating parameters before concatenating them into dynamic SQL statements

D. Having excess database privileges

E. Not validating parameters which are concatenated into dynamic SQL statements

Discussion 0

Correct Answer: E Vote an answer

Question #29

Examine this PL/SQL function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

A. A performance compilation warning is generated.

B. There are no compilation warnings or errors.

C. It fails compilation.

D. An information compilation warning is generated.

E. A severe compilation warning is generated.

Discussion 0

Correct Answer: E Vote an answer

Question #30

Which two statements are true regarding edition-based redefinition (EBR)?

A. Editions are non-schema objects.

B. You never use EBR to copy the database objects and redefine the copied objects in isolation.

C. EBR does not let you upgrade the database components of an application while in use.

D. Tables are not editionable objects.

E. There is no default edition defined in the database.

F. When you change an editioned object, all of its dependents remain valid.

Discussion 0

Correct Answer: D,F Vote an answer

Question #31

Select the correct statement regarding BEQUEATH CURRENT_USER.

A. With the BEQUEATH CURRENT_USER clause, a definer's rights function referenced in a view executes with the privileges of the view owner, not the function owner.

B. Any view calling a PL/SQL function with BEQUEATH CURRENT_USER in effect will execute with the privileges of the function owner.

C. If a view references a PL/SQL function then BEQUEATH CURRENT_USER allows the function to execute with DBA privileges, regardless of the invoking user's privileges.

D. The BEQUEATH CURRENT_USER clause allows invoker's rights functions referenced in a view to execute with the privileges of the invoking user.

Discussion 0

Correct Answer: D Vote an answer

Question #32

Which two statements are true about the DBMS_ LOB package?

A. Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.

B. DBMS_LOB.COMPARE returns the size difference of the compared LOBs.

C. DBMS_LOB.COMPARE can compare parts of two LOBs.

D. DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.

E. If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.

Discussion 0

Correct Answer: A,C Vote an answer

Question #33

Examine this function body:

Which two headers will allow this function to compile successfully and take advantage of both invoker's rights and function result caching?

A. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
VARCHAR2RESULT_CACHEAUTHID CURRENT_USERISdate_hired DATE;

B. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
VARCHAR2RESULT_CACHEAUTHID DEFINERISdate_hired DATE;

C. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (departments)AUTHID CURRENT_USERISdate_hired DATE;

D. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2AUTHID
DEFINERISdate_hired DATE;

E. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (employees)AUTHID CURRENT_USERISdate_hired DATE;

Discussion 0

Correct Answer: A,E Vote an answer

Question #34

Examine the structure of the EMP table:

Examine this code and statements:

Which statement is true?

A. The result cache gets invalidated only after the second UPDATE statement.

B. The result cache does not get invalidated at all since the RELIES_ON clause is not used.

C. The result cache gets invalidated after the ALTER FUNCTION and again after each UPDATE statement.

D. The result cache gets invalidated only after each UPDATE statement.

E. The result cache gets invalidated after the ALTER FUNCTION and again after the second UPDATE statement.

F. The result cache gets invalidated only after the ALTER FUNCTION statement.

Discussion 0

Correct Answer: B Vote an answer

Question #35

Examine the incomplete code:

Which three lines of code must be added for it to successfully compile?

A. src_cur := DBMS_SQL.TO_REFCURSOR (curid);

B. curid NUMBER;

C. curid SYS_FEFCURSOR;

D. curid := DBMS_SQL.TO_CURSOR_NUMBER (src_cur);

E. src_cur SYS_REFCURSOR;

F. src_cur= NUMBER;

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #36

Which three commands can be used to set PL/SQL conditional compilation inquiry directive MODE?

A. ALTER SESSION SET PLSQL_CCFLAGS= 'mode: NULL';

B. ALTER SESSION SET PLSQL_CCFLAGS = 'mode: FALSE';

C. ALTER SESSION SET PLSQL_CCFLAGS= 'mode: Level 1';

D. ALTER SESSION SET PLSQL_CCFLAGS= 'mode: 1'

E. ALTER SESSION SET PLSQL_CCFLAGS= 'mode: Level1';

Discussion 0

Correct Answer: A,B,D Vote an answer

Download Free Oracle 1z1-148 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-148 exam.