Oracle
1Z0-144 · Question #30
View the Exhibit and examine the structure of the EMP table. You want to create two procedures using the overloading feature to search for employee details based on either the employee name or…
The correct answer is B. The procedures should be created only as packaged subprograms E. The formal parameters of each subprogram should differ in data type but can use the same. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the EMP table. You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number. Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)
Exhibit
Options
- AThe procedures can be either stand-alone or packaged.
- BThe procedures should be created only as packaged subprograms
- CThe procedures should be created only as stand-alone subprograms
- DEach subprogram's formal parameters should differ in both name and data type.
- EThe formal parameters of each subprogram should differ in data type but can use the same
How the community answered
(27 responses)- A7% (2)
- B78% (21)
- C11% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.