Exam 1z0-149 All QuestionsBrowse all questions from this exam
Question 44

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

    Correct Answer: A, B, E

    The three correct statements about the procedure overloading feature are: Each procedure can be a nested subprogram, each procedure's formal parameters can differ in data type or name, and each procedure can be a packaged subprogram. Procedure overloading allows multiple procedures to have the same name but different parameter lists. This means they can differ in data type, mode, or number of parameters, but they don’t necessarily need to differ in parameter names (B). Procedures can indeed be nested subprograms or be part of a package, allowing for modular and organized code (A and E).

Discussion
FestoOptions: BEF

BEF is correct. You cannot overload standalone procedures

mattiamarraffa

F is wrong. If formal parameters differ only in name, then you must use named notation to specify the corresponding actual parameters. ABE is correct

2oracleexamOptions: ABE

A B E ?

mattiamarraffaOptions: BEF

B E F is correct

mattiamarraffa

Remove please. Wrong

DiplomiraniZnalacOptions: BEG

I think it's BEG?

mattiamarraffa

G is wrong. https://docs.oracle.com/en/database/oracle/oracle-database/23/lnpls/plsql-subprograms.html#GUID-BE995DE8-6E36-4728-A2D3-2F8B8438D305 ABE is correct

PeSquelOptions: ABE

reviewed documentation

McromeoOptions: ABE

ABE is correct

thranduylOptions: BEF

I know is BEF

mattiamarraffaOptions: ABE

A. Each procedure can be a nested subprogram. B. Each procedure's formal parameters can differ in data type or name. E. Each procedure can be a packaged subprogram. https://docs.oracle.com/en/database/oracle/oracle-database/23/lnpls/plsql-subprograms.html#GUID-47D5A50E-7AAF-4C80-A06A-37593EA2526A