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

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

A. ALL-DEPENDENCIES

B. ALL_DESCRIBE

C. ALL_SOURCE

D. ALL_PROCEDURES

E. ALL_ARGUMENTS

Discussion 0

Correct Answer: C,E Vote an answer

Question #11

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2 and DEPARTMENT_ID of data type NUMBER.
There are six employees in DEPARTMENT_ID, 20. Examine this code:

What will be the outcome on execution?

A. The number of employees will be displayed as six for the first output message and zero for the second output message.

B. The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.

C. The number of employees will be displayed as six for both output messages.

D. The execution of this code will fail with an invalid cursor error and not display either output message.

Discussion 0

Correct Answer: B Vote an answer

Question #12

Examine the structure of the EMP table:
Name Null? Type
------------------ -------------- ---------------------
EMPNO NOT NULL NUMBER (4)
ENAME VARCHAR2 (10)
SAL NUMBER (7, 2)
Examine this code:

Which code should be inserted to display the collection contents?

A. FOR indx IN 1_list.FIRST . . 1_list.LAST LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));END LOOP;

B. 1_indx := 1_list.FIRST;WHILE (1_indx IS NOT NULL) LOOPDBMS_OUTPUT.PUT_LINE (1_indx ||
' ' || 1_list (1_indx));1_indx := 1_emp.NEXT (1_indx);END LOOP;

C. FOR indx IN -1 .. 1_list.LIMIT LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx) );END LOOP;

D. FOR indx IN 1_list. COUNT .. -1 LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));END LOOP;

Discussion 0

Correct Answer: C Vote an answer

Question #13

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

A. The function must be created with invoker's rights or in an anonymous block.

B. The function must be declared as a pipelined table function.

C. The IN parameters must not include BLOB, CLOB, collection or record data types.

D. The function must have an OUT or an IN OUT parameter.

Discussion 0

Correct Answer: C Vote an answer

Question #14

A products TABLE exists with a PROD_ID column.
Examine this PL/SQL block:

Which statement is true?

A. It executes successfully.

B. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);

C. It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.

D. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);

E. It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.

Discussion 0

Correct Answer: B,C Vote an answer

Question #15

Examine this code:

Examine this query:
SELECT ename, d.dname, job, sal, comm FROM emp e, dept d WHERE d.deptno = e.deptno; Which statement is correct regarding the execution of this SQL query?

A. The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.

B. The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
"xxxxx".

C. The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.

D. The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.

Discussion 0

Correct Answer: D Vote an answer

Question #16

Which two statements are true about conversion from DBMS_SQL to native dynamic SQL? (Choose two.)

A. The DBMS_SQL.TO_REFCURSOR function converts a SQL cursor number to a weakly typed cursor variable only after it has been opened, parsed, and executed via DBMS_SQL.

B. The DBMS_SQL.TO_REFCURSOR function allows a query result to be returned implicitly from a non PL/SQL environment to a stored PL/SQL program.

C. The DBMS_SQL.TO_REFCURSOR function should be used when the number of bind variables is known at compile time, but not the number of items to be selected.

D. The DBMS_SQL.IS_OPEN function is used to verify that a SQL cursor number is open after it has been converted to a REF CURSOR.

E. DBMS_SQL operations can access the cursor only as the SQL cursor number, not as a REF CURSOR variable.

Discussion 0

Correct Answer: C,E Vote an answer

Question #17

This result cache is enabled for the database instance.
Examine this code for a PL/SQL function:

Which two actions would ensure that the same result will be consistently returned for any session when the same input value is passed to the function?

A. Add a parameter, fmt, and change the RETURN statement to:RETURN TO_CHAR (date_hired, fmt);

B. Set the RESULT_CACHE_MODE parameter to FORCE.

C. Set the RESULT_CACHE_MAX_RESULT parameter to 0.

D. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.

E. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #18

With SERVEROUTPUT enabled, you successfully create the package YEARLY_LIST:

Examine this code:

You want to display the contents of CREATE_LIST.
Which two lines need to be corrected in the PL/SQL block? (Choose two.)

A. Line 6

B. Line 2

C. Line 3

D. Line 5

E. Line 7

Discussion 0

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