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

Show Answer 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

Show Answer 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

Show Answer 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

Show Answer Next Question

Free Oracle 1Z0-144 Exam Braindumps (page: 2)

Pass your Oracle Database 11g: Program with PL/SQL exam with these free Actual Questions and Answers

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

1Z0-144 Exam Discussions & Posts