Oracle
1Z0-144 · Question #111
You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL . What is the most…
The correct answer is E. a local subprogram defined within the program unit ORDERTOTAL. See the full explanation below for the reasoning.
Question
You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL . What is the most appropriate location to store the code that calculates the discount?
Options
- Aa stored procedure on the server
- Ba block of code in a PL/SQL library
- Ca standalone procedure on the client machine
- Da block of code in the body of the program unit ORDERTOTAL
- Ea local subprogram defined within the program unit ORDERTOTAL
How the community answered
(59 responses)- A8% (5)
- B3% (2)
- C2% (1)
- D15% (9)
- E71% (42)
Community Discussion
No community discussion yet for this question.