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 #46

Examine this code:

Which two corrections must be applied for this anonymous block to execute successfully?

A. Define the function as stand-alone instead of in a package body.

B. Declare the collection type inside the function.

C. Modify the function return type to return a scalar, VARCHAR2.

D. Change RETURN p_tab.LAST to RETURN p_tab.COUNT.

E. Declare the collection type at the schema level instead of the package.

F. Change the INDEX BY clause from VARCHAR2 to PLS_INTEGER.

Discussion 0

Correct Answer: C,F Vote an answer

Question #47

Identify the two correct scenarios where a function can be optimized using the function result cache feature.

A. A function which calculates the factorial of a given number without accessing any table.

B. A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.

C. A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative.

D. A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.

E. A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.

Discussion 0

Correct Answer: A,D Vote an answer

Question #48

Which PRAGMA statement may enable associated PL/SQL functions to run more efficiently when called from SQL?

A. PRAGMA UDF;

B. PRAGMA SERIALLY_REUSABLE;

C. PRAGMA AUTONOMOUS_TRANSACTION;

D. PRAGMA INLINE ('<function_name>', 'YES');

Discussion 0

Correct Answer: A Vote an answer

Question #49

Which two PL/SQL blocks give the output "this is a test message"?

A. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message ', FALSE));END;

B. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a "test" message" ', TRUE));END;

C. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE));END;

D. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a test message"
', TRUE));END;

E. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE));END;

Discussion 0

Correct Answer: A,D Vote an answer

Question #50

Examine this code:

Users of this function may set different date formats in their sessions.
Which two modifications must be made to allow the use of your session's date format when outputting the cached result of this function?

A. Change AUTHID to CURRENT_USER.

B. Change the RETURN type to DATE.

C. Set NLS_DATE_FORMAT to 'DD-MM-YY' at the instance level.

D. Set the RESULT_CACHE_MODE parameter to FORCE.

E. Use the TO_CHAR function around SYSDATE, that is, 1_date := TO_CHAR (SYSDATE).

F. Change the data type of 1_date to DATE.

Discussion 0

Correct Answer: A,B Vote an answer

Question #51

You execute this PL/SQL block:

What will be the outcome?

A. It will fail compile and execute successfully.

B. It will fail compile because of errors at lines 5 and 6.

C. It will fail compile because of error at line 7.

D. It will fail compile because of errors at lines 11 and 12.

E. It will fail compile because of errors at lines 6 and 12.

Discussion 0

Correct Answer: E Vote an answer

Question #52

Examine this function call:
cur_num := DBMS_SQL.TO_CURSOR_NUMBER (cur_val);
Which two statements are true?

A. CUR_VAL must be a weakly typed cursor variable.

B. CUR_VAL must be opened before this line is executed in the PL/SQL block.

C. The PL/SQL block can continue to use the cursor variable after this line is executed.

D. CUR_VAL must be opened after this line is executed in the PL/SQL block.

E. CUR_VAL can be either a strongly or weakly typed cursor variable.

Discussion 0

Correct Answer: B,E Vote an answer

Question #53

Which three statements are true about varrays in a database table column? (Choose three.)

A. A varray used as a column in a database table must be initialized to empty.

B. A varray is always stored in the same segment as the table in which it is defined.

C. A varray's size can be both increased and decreased from the maximum number of elements specified in the definition.

D. A varray used as a column in a database table must be initialized to null.

E. The data in a single element of a varray can only be changed through PL/SQL.

F. A varray may be stored outside the table segment in which it is defined but still in the same tablespace.

G. The data in a single element of a varray can be changed through either PL/SQL or SQL.

H. A varray's size can be increased beyond the maximum number of elements specified in the definition.

Discussion 0

Correct Answer: C,F,G Vote an answer

Question #54

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.
Examine this PL/SQL package AS

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

A. CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

B. CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

C. CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

D. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

E. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
:=0;BEGIN...RETUNRN total;END;/

Discussion 0

Correct Answer: A,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.