Oracle Database: Program with PL/SQL — Question 59

Which two can be used to find details of parameters for overloaded PL/SQL routines?

Answer options

• A. ALL-DEPENDENCIES
• B. ALL_PROCEDURES
• C. ALL_DESCRIBE
• D. ALL_SOURCE
• E. ALL_ARGUMENTS

Correct answer: D, E

Explanation

The correct answers are D (ALL_SOURCE) and E (ALL_ARGUMENTS) because they provide detailed information about the source code of PL/SQL routines and their parameters. The other options, while related to PL/SQL, do not specifically give parameter details for overloaded routines.