Oracle Database: Advanced PL/SQL - 1z0-148 Exam Questions [2026]

QUESTION NO: 1
Which statement describes the plshprof command-line utility?

A. It produces raw profiler output for the most recently executed PL/SQL block. B. It stores hash values in hierarchical profiler tables in the database. C. It produces HTML output from hierarchical profiler tables in the database. D. It produces HTML output from raw profiler output. E. It executes a script to create hierarchical profiler tables in the database.

Correct Answer: D

QUESTION NO: 2

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

A. The value of v3 (31) (1) is "hello". B. The values of v3(31) (2) and v3 (33) (2) are identical. C. The values of v3 (32) (2) and v1 (2) are identical. D. The value of v3 (31) (1) and v3 (33) (3) are identical, E. The value of v3 (31) (3) is 6.

Correct Answer: C,D

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

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

Correct Answer: A,E

QUESTION NO: 4
Examine these statements:

Which two corrections will allow this anonymous block to execute successfully?

A. Change line #2 to wk# tp_test# := tp_test# (tp_rec# ()); B. Add wk# .NEXT; before the 7th line. C. Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i); D. Add wk#. EXTEND (1); before the 5th line. E. Add i PLS_INTEGER; before the 3rd line.

Correct Answer: C,D

QUESTION NO: 5
Which three statements are correct when using collections? (Choose three.)

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

Correct Answer: B,D,E

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

A. The function must be declared as a pipelined table function. B. The function must have an OUT or an IN OUT parameter. C. The IN parameters must not include BLOB, CLOB, collection or record data types. D. The function must be created with invoker's rights or in an anonymous block.

Correct Answer: C

QUESTION NO: 7
Which two statements are true about the DBMS_ LOB package?

A. DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs. B. DBMS_LOB.COMPARE returns the size difference of the compared LOBs. C. If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB. D. Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist. E. DBMS_LOB.COMPARE can compare parts of two LOBs.

Correct Answer: D,E

QUESTION NO: 8
Which data dictionary view includes information about the parameters of procedures and functions that you can call?

A. ALL_ARGUMENTS B. ALL_PROCEDURES C. ALL_OBJECTS D. ALL_PACKAGES

Correct Answer: C

QUESTION NO: 9
Examine this code executed as SYS:

Examine this code executed as SPIDER and the error message received upon execution:

What is the reason for this error?

A. Privileges granted through roles are never in effect when running definer's rights procedures. B. The EXECUTE IMMEDIATE clause is not supported with roles. C. The user SPIDER needs to be granted the CREATE TABLE privilege and the procedure needs to be granted the DYNAMIC_TABLE_ROLE. D. The procedure needs to be granted the DYNAMIC_TABLE_ROLE role.

Correct Answer: A

QUESTION NO: 10
You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead?

A. When the amount of memory allocated for the result cache is increased B. When the maximum amount of server result cache memory that can be used for a single result is set to 0. C. When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session D. When the function is executed in a session frequently with the same parameter value E. When the database administrator disables the result cache during ongoing application patching

Correct Answer: C,E

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