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

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. It executes successfully and outputs:Fetched: 1011, JJONES, -1Fetched: 1012, SSMITH, -1

B. An exception is thrown at runtime saying EMP_TAXID is not visible.

C. It executes successfully and outputs:Fetched: 1011, JJONES, 3789Fetched: 1012, SSMITH, -1

D. It executes successfully and outputs:Fetched: 1011, JJONES,Fetched: 1012, SSMITH,

E. Compilation fails saying EMP_TAXID must be declared.

Discussion 0

Correct Answer: E Vote an answer

Question #38

Examine the test_tbl table and its contents:

Examine this code:

What is the outcome of this anonymous PL/SQL block?

A. A NO_DATA_FOUND exception is thrown.

B. ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified

C. "It was updated" is displayed.

D. Successful completion without printing "It was updated".

E. ORA-22920: row containing the LOB value is not locked

Discussion 0

Correct Answer: D Vote an answer

Question #39

Which two blocks of code execute successfully?

A. DECLARE
SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9; my_val new_one; BEGIN my_val :=0; END;

B. DECLARE
SUBTYPE new_one IS NUMBER (1, 0); my_val new_one; BEGIN my_val := -1;
END;

C. DECLARE
SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END;

D. DECLARE
SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL; my_val new_one; BEGIN my_val :=2; END;

E. DECLARE
SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string; BEGIN my_str := 'abc'; END;

Discussion 0

Correct Answer: A,B Vote an answer

Question #40

Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in its definition. (Choose three.)

A. The code in the function performs more write operations on the database when compared to the read operations.

B. The value returned by the function is deterministic for a given set of input parameters.

C. The logic in the function accesses tables or uses package variables which are modified very rarely.

D. The function involves highly computational logic with minimal or no database access.

E. The function has complex business logic depending on more than five tables to compute its return values.

F. The tables which are read in the function are very frequently updated.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #41

Which two statements are true about PL/SQL AOIs for SecureFiles?

A. When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.

B. DBMS_LOB can be used to compress SecureFiles columns.

C. An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).

D. If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.

Discussion 0

Correct Answer: A,C Vote an answer

Question #42

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

A. Nested tables should be used when the index values are non-sequential.

B. Nested tables may be used when there is no predefined upper bound for index values.

C. Varrays should be used when you need to pass the collection as a parameter.

D. Do not use nested tables when you need to delete elements.

E. Associative arrays may be used when you need to process information of unknown volume.

F. Use associative arrays when you need numeric and string indices.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #43

Examine the code:

Which two subprograms will be created successfully?

A. CREATE FUNCTION p3 RETURN pkg. tab_typ ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO pkg.x;END p3;

B. CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ ISBEGINEXECUTE IMMEDIATE
'SELECT pdt_id, pdt_name FROM TABLE (:b)'BULT COLLECT INTO pkg.x USING y;RETURN pkg.x;END p4;

C. CREATE PROCEDURE p5 (y pkg. rec_typ) ISBEGINEXECUTE IMMEDIATE 'SELECT pdt_name FROM TABLE (:b)' BULK COLLECT INTO y USING pkg.x;END p5;

D. CREATE PROCEDURE p2 (v IN OUT VARCHAR2) ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO v USING pkg.x;END p2;

E. CREATE PROCEDURE p1 (y IN OUT pkg.tab_typ) ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO y USING pkg.x;END p1;

Discussion 0

Correct Answer: B,D Vote an answer

Question #44

Which two statements are correct about the collections before v3. DELETE is executed?

A. The values of v3(31) (2) and v3 (33) (2) are identical.

B. The values of v3 (32) (2) and v1 (2) are identical.

C. The value of v3 (31) (1) and v3 (33) (3) are identical,

D. The value of v3 (31) (3) is 6.

E. The value of v3 (31) (1) is "hello".

Discussion 0

Correct Answer: B,C Vote an answer

Question #45

Examine these two columns:

Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

A. 1-b, 2-d, 3-c, 4-e, 5-a

B. 1-c, 2-b, 3-e, 4-a, 5-d

C. 1-c, 2-a, 3-b, 4-e, 5-d

D. 1-c, 2-d, 3-b, 4-e, 5-a

E. 1-e, 2-a, 3-c, 4-b, 5-d

Discussion 0

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