Oracle Database: Advanced PL/SQL — Question 42

Which three are true about the procedure overloading feature? (Choose three.)

Answer options

• A. Each procedure can be a nested subprogram.
• B. Each procedure's formal parameters can differ in data type or name.
• C. Each procedure must use named notation to specify the corresponding actual parameters.
• D. Each procedure's formal parameters must differ in name.
• E. Each procedure can be a packaged subprogram.
• F. Each procedure must use positional notation to specify the corresponding actual parameters.
• G. Each procedure can be a standalone subprogram.

Correct answer: A, B, E

Explanation

The correct answers A, B, and E highlight that procedures can be nested or packaged and that their formal parameters can differ in type or name, which is essential for overloading. Options C and F incorrectly state that named or positional notation must be used, which is not a requirement for all procedures. Option D is incorrect because differing names are not a requirement for overloading.