This preview shows page 1. Sign up to view the full content.
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
the value and the executable section does the actual returning.
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)
E. anonymous block
F. packaged procedure or function
Answer: A, B, D, F
Procedure and function can either directly or indirectly refer to the following
objects.Tables,Views,Sequences,Procedures,Functions, Packaged procedures and
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: Actualtests.com - 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
D. An exception raised inside an exception handler immediately propagates to the
Answer: A, C, D
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
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.
- Fall '09