Free 1Z0-144 Exam Questions and Answers | by Exam-Dumps.net (Page: 1)

QUESTION: 1

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

It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.
It is a public variable in a package specification whose value is consistent within a user session.
It is a private variable in a package body whose value is consistent across all current active sessions.
It is a public variable in a package specification whose value is always consistent across all current active sessions.

Answer(s): B

Reveal Solution Next Question

QUESTION: 2

View Exhibit1 and examine the structure of the employees table.

What is the outcome when the code is executed?

Both blocks compile and execute successfully when called.
Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.
The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.
The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.

Answer(s): A

Reveal Solution Next Question

View the Exhibit and examine the structure of the EMP table.

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

The procedures can be either stand-alone or packaged.
The procedures should be created only as packaged subprograms
The procedures should be created only as stand-alone subprograms
Each subprogram's formal parameters should differ in both name and data type.
The formal parameters of each subprogram should differ in data type but can use the same names.

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 4

View the exhibit to examine the PL/SQL code.

Which statement is true about the exception handlers in the PL/SQL code?

All the exceptions in the code are trapped by the exception handler.
All the "no data found" errors in the code are trapped by the exception handler.
The PL/SQL program does not execute because an exception is not declared in the declare section.
An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.

Answer(s): B

Reveal Solution Next Question

QUESTION: 5

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.)

ON SCHEMA
ON QRXABASE
AFTER LOGOFF
BEFORE LOGOFF

Answer(s): A,D

Reveal Solution Next Question

Oracle 1Z0-144 Exam (page: 1)
Oracle Database 11g: Program with PL/SQL
Updated on: 12-Aug-2025

Access free 1Z0-144 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

QUESTION: 5

Oracle 1Z0-144 Exam (page: 1) Oracle Database 11g: Program with PL/SQL Updated on: 12-Aug-2025

Access free 1Z0-144 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

QUESTION: 5

Oracle 1Z0-144 Exam (page: 1)
Oracle Database 11g: Program with PL/SQL
Updated on: 12-Aug-2025