Free 1Z1-144 Questions for Oracle Database 11g: Program with PL/SQL 1Z1-144 Exam as PDF & Practice Test Engine

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: May 28, 2026

Question #1

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 gives an error on compilation because the exception section Is used in the trigger.

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

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

D. It compiles and executes successfully.

Discussion 0

Correct Answer: C Vote an answer

Question #2

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

A. Line 5

B. Line 2

C. Line 3

D. Line 4

E. Line 6

Discussion 0

Correct Answer: A Vote an answer

Question #3

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What would be the outcome when the code is executed?

A. It executes successfully.

B. It gives an error because the SAL variable is not visible in the increase function.

C. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.

D. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.

Discussion 0

Correct Answer: A Vote an answer

Question #4

Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?

A. There is no effect on procedure A and it runs successfully.

B. Procedure A is invalidated and recompiles when invoked the next time.

C. Procedure A is invalidated and recompiled immediately.

D. Procedure B is invalidated and recompiled again when invoked.

Discussion 0

Correct Answer: B Vote an answer

Question #5

You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information.
Which type of composite data type would you choose to fulfill the requirement?

A. Associative arrays

B. PL/SQL records

C. VARRAYS

D. Nested table

Discussion 0

Correct Answer: B Vote an answer

Question #6

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, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.

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

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

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

Discussion 0

Correct Answer: D Vote an answer

Free 1Z1-144 Questions for Oracle Database 11g: Program with PL/SQL 1Z1-144 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z1-144 Demo