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

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

Exam Questions: 103
Updated On: Jul 07, 2026

Question #29

Which two tasks should be created as functions instead of as procedures? (Choose two.)

A. Tasks that compute a value that must be returned to the calling environment

B. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application

C. Tasks that compute and return multiple values to the calling environment

D. Reference host or bind variables in a PL7SQL block of code

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #30

View the Exhibit to examine the PL/SQL code.

SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?

A. The execution is successful even if there is no employee with EMPLOYEE_ID 115.

B. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.

C. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.

D. The execution fails because of the misplaced else clause.

Discussion 0

Correct Answer: B Vote an answer

Question #31

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

View the Exhibit to examine the PL/SQL code.

The record for the employee with employee__id 100 in the employees table is as follows;

Identify the correct output for the code.

A. King current sysdate 1500

B. King 17-JUN-87 24000

C. King current sysdate 24000

D. King 17-JUN-87 1500

Discussion 0

Correct Answer: D Vote an answer

Question #33

View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?

A. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

B. It executes successfully and gives the desired output.

C. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

D. It does not execute because the definition of type population is indexed by VARCHAR2.

Discussion 0

Correct Answer: B Vote an answer

Question #34

View the exhibit and examine the structure of the products table.

Examine the following code

Which statement is true when the procedure DELETE_DETAILS is invoked?

A. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.

B. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

C. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

D. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

Discussion 0

Correct Answer: D Vote an answer

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

Question #35

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

A. It compiles successfully but gives an error on execution because it is not a row-level trigger.

B. It gives an error on compilation because it is not a row-level trigger.

C. It compiles and executes successfully.

D. It gives an error on compilation because the exception section Is used in the trigger.

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1Z0-144 Demo

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