Oracle Database: Advanced PL/SQL — Question 29

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

Answer options

• A. The actual parameters must be specified in the same order as the formal parameters are declared.
• B. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
• C. Only trailing optional parameters can be omitted in the invocation call.
• D. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
• E. Any optional parameters can be omitted in the invocation call.

Correct answer: D, E

Explanation

Option D is correct because if new required parameters are added to the formal parameter list, the subprogram calls need to be updated to include these parameters. Option E is also accurate as it states that any optional parameters can be omitted, which is true for named notations. The other options are incorrect because they misrepresent the rules governing parameter order and omission in named notation calls.