The return statement in the executable section of the

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: ETURN keyword and identifies the data type that needs to be returned to the calling block. The RETURN statement in the executable section of the function performs the actual returning of the value. The header section defines the return data type of the value and the executable section does the actual returning. Incorrect Answers A. You need a RETURN Statement in the EXECUTABLE section as well. B. You will not find a RETURN in the declaration section. D. You will not find a RETURN statement in either section.. QUESTION 80: A dependent procedure or function directly or indirectly references one or more of which four objects? (Choose four) A. view B. sequence C. privilege D. procedure E. anonymous block F. packaged procedure or function Answer: A, B, D, F Explanation: Procedure and function can either directly or indirectly refer to the following objects.Tables,Views,Sequences,Procedures,Functions, Packaged procedures and functions Incorrect Answers C. Procedures and functions can't refer to a privilege. E. An anonymous block is not a stored program unit therefore it can't be referred to. QUESTION 81: - The Power of Knowing 1Z0-147 Which three are true regarding error propagation? (Choose three) A. An exception cannot propagate across remote procedure calls. B. An exception raised inside a declaration immediately propagates to the current block. C. The use of the RAISE; statement in an exception handler reprises the current exception. D. An exception raised inside an exception handler immediately propagates to the enclosing block. Answer: A, C, D Explanation: A. Exceptions cannot propagate across remote procedure calls (RPCs). Therefore, a PL/SQL block cannot catch an exception raised by a remote subprogram. For a workaround, see "Defining Your Own Error Messages: Procedure RAISE_APPLICATION_ERROR". C. To reraise an exception you place a RAISE statement in the local exception handler. D. When an exception is raised, the control is passed to the exception-handling section. The control is never transferred back to th...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online