Multiple choice technology databases

Which two statements about the overloading feature of packages are true? (Choose two)

  1. Only local or packaged sub programs can be overloaded.

  2. Overloading allows different functions with the same name that differ only in their return types.

  3. Overloading allows different subprograms with the same number, type and order of the parameter.

  4. Overloading allows different subprograms with the same name and same number or type of the parameters.

  5. Overloading allows different subprograms with the same name but different in either number or type or order of parameter.
Reveal answer Fill a bubble to check yourself
A,E Correct answer
Explanation

PL/SQL package subprogram overloading allows multiple subprograms (procedures or functions) to share the same name, provided their formal parameters differ in number, data type, or order. Overloading cannot be done based solely on differing return types, and standalone subprograms cannot be overloaded.

Keep practicing — related questions