Multiple choice technology databases

Select the best answer PACKAGE foo_foo IS PROCEDURE foo ( p_foo_text IN VARCHAR2 ); PROCEDURE foo (p_foo_number IN NUMBER); END;

  1. Package specification is invalid. Too many procedures named foo.

  2. Package specification is invalid. First procedure should be called called foo_1, second procedure should be called foo_2.

  3. Package specification is valid. This is an example of overloading.

  4. Package specification is invalid. We can only have one procedure named foo in the package

  5. Package specification is valid. We can have an unlimited number of procedures name foo.

  6. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The package specification is valid because PL/SQL supports procedure overloading when the parameters differ in datatype (VARCHAR2 vs NUMBER). The compiler distinguishes between the two foo procedures by their parameter signatures, so this is legal overloading. Option A is wrong - overloading is allowed. Option B is wrong - the procedures don't need different names. Option D is wrong - multiple procedures with the same name are permitted when signatures differ. Option E is misleading - while you can have many overloaded procedures, they must have unique parameter signatures.

Keep practicing — related questions