Oracle 1Z1-144 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z1-144
Exam Name/Title: Oracle Database 11g: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Other Oracle Certification

Exam Questions: 103
Updated On: Sep 22, 2026

Question #1

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

A. Line 6

B. Line 2

C. Line 3

D. Line 5

E. Line 4

Discussion 0

Correct Answer: D Vote an answer

Question #2

Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS PROCEDURE search_emp (empdet NUMBER); PROCEDURE search_emp (empdet DATE); PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 PROCEDURE search_emp (empdet NUMBER); RETURN DATE END emp_pkg / The package is compiled successfully
Why would it generate an error at run tune?

A. Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types

B. Because function cannot be overload

C. Because function cannot differ only in return type.

D. Because all the functions and procedures In the package cannot have the same number of parameters with the same parameter name

Discussion 0

Correct Answer: C Vote an answer

Question #3

View the Exhibit to examine the PL/SQL code:

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

A. It produces an error.

B. The output Is x != y.

C. The output is x = y.

D. The output Is Can't tell if x and y are equal or not.

Discussion 0

Correct Answer: C Vote an answer

Question #4

You execute the following block of code:

Which statement is true about the outcome?

A. Both Output statements show different values.

B. Both output statements show exactly the same values.

C. It gives an error because the nested blocks are not labeled.

D. It gives an error because the V_CUSTOMER variable have different types in the nested blocks

Discussion 0

Correct Answer: A Vote an answer

Question #5

View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:

Which statement is true about the above trigger?

A. It gives an error on compilation because it should be a statement-level trigger.

B. It gives an error on compilation because of the commit command in the trigger code

C. It compiles and fires successfully when the credit limit is updated in the customer table.

D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.

Discussion 0

Correct Answer: D Vote an answer

Question #6

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

A. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

B. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

C. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

D. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

Discussion 0

Correct Answer: A,D Vote an answer

Question #7

Which two statements are true about the instead of triggers? (Choose two.)

A. The instead or triggers must be created to add or modify data through any view.

B. Delete operations cannot be performed using the instead of triggers.

C. The instead of triggers can be written only for views, and the before and after timing options are not valid.

D. The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.

Discussion 0

Correct Answer: A,C Vote an answer

Question #8

Which two statements are true about anonymous blocks and named subprograms?
(Choose two)

A. The declare section is optional for both anonymous blocks and subprograms.

B. The declare section is mandatory for anonymous blocks and optional for subprograms.

C. Both anonymous blocks and subprograms execute by default with invoker's rights.

D. Subprograms are by default executed with definer's rights.

Discussion 0

Correct Answer: A,D Vote an answer

Question #9

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

A. When a query returns multiple rows

B. When a column name in a where clause is unknown at compile time.

C. When the number of columns selected in a query is not known until run time

D. When privileges need to be granted to a new user to access an existing schema at run time

E. When a table needs to be created based on an existing table structure at run time

Discussion 0

Correct Answer: B,C Vote an answer

Question #10

You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:

Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)

A. AFTER LOGOFF

B. ON SCHEMA

C. ON QRXABASE

D. BEFORE LOGOFF

Discussion 0

Correct Answer: B,D Vote an answer

Download Free Oracle 1Z1-144 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z1-144 exam.