Com the power of knowing 1z0 147 c procedure combine

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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); Answer: A Explanation: You use the package overloading feature when the same operation is performed using arguments of different types. Incorrect Answers 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 same name. 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. Answer: D Explanation: 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 Oracle server...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online