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

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What is the outcome when the code is executed?

A. Both blocks compile and execute successfully when called.

B. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.

C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.

D. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.

Discussion 0

Correct Answer: A Vote an answer

Question #2

What is the correct definition of the persistent state of a packaged variable?

A. It is a public variable in a package specification whose value is always consistent across all current active sessions.

B. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.

C. It is a private variable in a package body whose value is consistent across all current active sessions.

D. It is a public variable in a package specification whose value is consistent within a user session.

Discussion 0

Correct Answer: D Vote an answer

Question #3

View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

A. It gives an error in line 8.

B. It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.

C. It gives an error in line 6.

D. It gives an error in line 5.

E. It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.

Discussion 0

Correct Answer: B Vote an answer

Question #4

Which two statements are correct about PL/SQL package components? (Choose two)

A. A package specification can exist without the package body.

B. A package must have both specification and body.

C. A package body can exist without the package specification.

D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

Discussion 0

Correct Answer: A,D Vote an answer

Question #5

View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:

Which statement is true about the above block of code?

A. It gives an error on execution because sequences cannot be used in anonymous blocks.

B. It consists of two transactions

C. It consists of a single transaction,

D. The data is automatically committed after the block execution ends,

Discussion 0

Correct Answer: B Vote an answer

Question #6

View the Exhibit to examine the PIVSQL block.

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

A. It executes and the Output is emprec.deptname: .

B. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

C. It produces an error because NULL is assigned to the emprec.empid field in the record.

D. It executes and the Output is emprec.deptname: Sales.

Discussion 0

Correct Answer: A Vote an answer

Question #7

Examine the following partial code:

Which statement is correct about the unnamed block of code at the end of a package body?

A. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.

B. It acts as a package initialization block that executes once, when the package is first invoked within the user session.

C. It generates an error because all the blocks of code in a package body must be named.

D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.

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.