Unformatted text preview: package specification?
A. PROCEDURE combine;
B. PROCEDURE combine (p_no NUMBER);
Actualtests.com - The Power of Knowing 1Z0-147
C. PROCEDURE combine (p_val_1 VARCHAR2, p_val_2 NUMBER;
D. PROCEDURE concat_all
(p_num_val VARCHAR2, p_char_val NUMBER);
You use the package overloading feature when the same operation is performed using
B. This procedure conflicts with the first procedure declaration in that its parameters
differs only by name but have the same data type. You cannot use two procedures with
the same name if their parameters differ only in name or mode.
C. This procedure conflicts with the third procedure declaration in that its parameters
differs only by name but have the same data type.
D. This procdure can't be overloaded because it does not use the same name. Package
overloading allows more than one procedure or function inside the package to use the
QUESTION 69: Local procedure A calls remote procedure B. Procedure B was
compiled at 8 A.M. Procedure A was modified and recompiled
at 9 A.M. Remote procedure B was later modified and
recompiled at 11 A.M.
The dependency mode is set to TIMESTAMP.
What happens when procedure A is invoked at 1 P.M?
A. There is no affect on procedure A and it runs successfully.
B. Procedure B is invalidated and recompiles when invoked.
C. Procedure A is invalidated and recompiles for the first time it is invoked.
D. Procedure A is invalidated and recompiles for the second time it is invoked.
When the local procedure is invoked, at run time the Oracle server compares the two time
stamps of the referenced remote procedure. If the time stamps are equal (indicating that
the remote procedure has not recompiled), the Oracle server executes the local procedure.
If the time stamps are not equal (indicating that the remote procedure has recompiled),
the Oracle server invalidates the local procedure and returns a runtime error.
If the local procedure, which is now tagged as invalid, is invoked a second time, the
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09