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:	Aug 14, 2026
# of views:	6270
Rating 100%

Page: 1 / 22
Total 108 questions

Question 1

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

A.CUR_VAL must be opened before this line is executed in the PL/SQL block.
B.CUR_VAL can be either a strongly or weakly typed cursor variable.
C.CUR_VAL must be opened after this line is executed in the PL/SQL block.
D.The PL/SQL block can continue to use the cursor variable after this line is executed.
E.CUR_VAL must be a weakly typed cursor variable.

Question 2

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 the data type of 1_date to DATE.
B.Set the RESULT_CACHE_MODE parameter to FORCE.
C.Set NLS_DATE_FORMAT to 'DD-MM-YY' at the instance level.
D.Change the RETURN type to DATE.
E.Change AUTHID to CURRENT_USER.
F.Use the TO_CHAR function around SYSDATE, that is, 1_date := TO_CHAR (SYSDATE).

Question 3

Which three statements are correct when using collections? (Choose three.)

A.Use associative arrays when you need numeric and string indices.
B.Nested tables may be used when there is no predefined upper bound for index values.
C.Nested tables should be used when the index values are non-sequential.
D.Varrays should be used when you need to pass the collection as a parameter.
E.Do not use nested tables when you need to delete elements.
F.Associative arrays may be used when you need to process information of unknown volume.

Question 4

Examine the EMPLOYEE_IDS table its data:

Examine this PL/SQL block:

What is the result of executing this PL/SQL block with SERVEROUTPUT enabled?

A.An exception is thrown at runtime saying EMP_TAXID is not visible.
B.It executes successfully and outputs:Fetched: 1011, JJONES, -1Fetched: 1012, SSMITH, -1
C.It executes successfully and outputs:Fetched: 1011, JJONES, 3789Fetched: 1012, SSMITH, -1
D.Compilation fails saying EMP_TAXID must be declared.
E.It executes successfully and outputs:Fetched: 1011, JJONES,Fetched: 1012, SSMITH,

Question 5

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

A.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: Level 1';
B.ALTER SESSION SET PLSQL_CCFLAGS = 'mode: FALSE';
C.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: Level1';
D.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: 1'
E.ALTER SESSION SET PLSQL_CCFLAGS= 'mode: NULL';