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.)
A. The procedures can be either stand-alone or packaged.
B. The procedures should be created only as packaged subprograms
C. The procedures should be created only as stand-alone subprograms
D. Each subprogram’s formal parameters should differ in both name and data type.
E. The formal parameters of each subprogram should differ in data type but can use the same names.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Agree with Eva and think that correct answers are BE.
Just adding link for convenience.
https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm
“Only local or packaged subprograms, or type methods, can be overloaded. You cannot overload standalone subprograms.”
“PL/SQL lets you overload subprogram names and type methods. You can use the same name for several different subprograms as long as their formal parameters differ in number, order, or datatype family.”
Restrictions on Overloading
Only local or packaged subprograms, or type methods, can be overloaded. You cannot overload standalone subprograms.
You cannot overload two subprograms if their formal parameters differ only in name or parameter mode. For example, you cannot overload the following two procedures: