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

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

    Correct Answer: D, E

    When using named notation in a PL/SQL subprogram, the subprogram invocations must be updated if the formal parameter list gains new required parameters. This ensures that all necessary parameters are provided during the call. Additionally, any optional parameters (not just trailing ones) can be omitted in the invocation, as named notation allows for flexibility in specifying only those parameters that are needed.

Discussion
qrmahmduovOptions: DE

It is D, E

sorincirnuOptions: DE

It`s DE

Cit89Options: DE

D & E are always right. A is only right for positional parameters, not for named ones. B is only right for positional parameters and those parameters distinguish in their types

erykjuarezOptions: DE

it is D and E https://docs.oracle.com/en/database/oracle/oracle-database/18/lnpls/plsql-subprograms.html?source=%3Aow%3Alp%3Acpo%3A%3A&source=%3Aow%3Alp%3Acpo%3A%3A&source=%3Aow%3Alp%3Acpo%3A%3A&source=%3Aow%3Alp%3Acpo%3A%3A#GUID-A5DA8CF5-1BCC-4ABE-9B68-DB593FF1D2CC Subprogram invocations must change only if the formal parameter list acquires new required parameters.

2oracleexamOptions: DE

D and E

OracleBoracleOptions: CE

no AE is correct , just read this: https://docs.oracle.com/en/database/oracle/oracle-database/18/lnpls/plsql-subprograms.html?source=%3Aow%3Alp%3Acpo%3A%3A&source=%3Aow%3Alp%3Acpo%3A%3A#GUID-A5DA8CF5-1BCC-4ABE-9B68-DB593FF1D2CC

AlCoholic69

From your link: Named Specify the actual parameters in any order, using this syntax: