Oracle Database 11g Advanced PLSQL

Here you have the best Oracle 1z0-146 practice exam questions

You have 117 total questions to study from
Each page has 5 questions, making a total of 24 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 21, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 117

Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)

Only local subroutines can be inlined

Inlining always reduces the execution time of a PL/SQL program unit

PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2

The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining

Correct Answer: A, C

Question 2 of 117

See the Exhibit and examine the PL/SQL code for the following table:
Exam 1z0-146: Question 2 - Image 1

Which statement is true about the compilation and execution of the function?

The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema

The compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR') is not placed in the correct order

The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema

The execution of the function produces an error because multiple objects are fetched and DBMS_METADATA.FETCH_CLOB is not called in a LOOP

Correct Answer: C

Question 3 of 117

See the Exhibit:
Exam 1z0-146: Question 3 - Image 1

Examine the PL/SQL block; While executing the PL/SQL statements generates the errors, what is the reason?

The DELETE(n) method cannot be used with varrys

The DELETE(n) method cannot be used with nested tables

The NEXT method cannot be used with an associate array with VARCHAR2 key values

The NEXT method cannot be used with a nested table from which an element has been deleted

Correct Answer: A

Question 4 of 117

You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?

The corresponding shared library is also removed from the system

PL/SQL subprograms can be used to invoke the external C procedure

The existing extproc process is terminated and a new extproc is started

The PL/SQL subprogram that depends on the external C program becomes invalid

Correct Answer: D

Question 5 of 117

See the exhibit:
Exam 1z0-146: Question 5 - Image 1

Which of the above INSERT statements are valid?

Only the first statement is valid

All the statement are valid

Only the first and fourth statements are valid

Only the first and second statements are valid

Only the first, second and third statements are valid

Correct Answer: E