1z0-149 Exam QuestionsBrowse all questions from this exam

1z0-149 Exam - Question 44


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

Show Answer
Correct Answer: ABEF

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

8 comments
Sign in to comment
FestoOptions: BEF
Sep 2, 2023

BEF is correct. You cannot overload standalone procedures

mattiamarraffa
Nov 9, 2023

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

DiplomiraniZnalacOptions: BEG
Jul 25, 2023

I think it's BEG?

mattiamarraffa
Nov 9, 2023

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

mattiamarraffaOptions: BEF
Nov 9, 2023

B E F is correct

mattiamarraffa
Nov 9, 2023

Remove please. Wrong

2oracleexamOptions: ABE
Dec 13, 2023

A B E ?

mattiamarraffaOptions: ABE
Nov 9, 2023

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

thranduylOptions: BEF
Dec 7, 2023

I know is BEF

McromeoOptions: ABE
May 10, 2024

ABE is correct

PeSquelOptions: ABE
Jun 27, 2024

reviewed documentation