Which two tasks should be created as functions instead of as procedures? (Choose two.)
A.
Reference host or bind variables in a PL/SQL block of code
B.
Tasks that compute and return multiple values to the calling environment
C.
Tasks that compute a value that must be returned to the calling environment
D.
Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into
a function can return multiple values but use the type structure, still the answer is BD
https://asktom.oracle.com/pls/asktom/asktom.search?tag=oracle-function-returning-multiple-values
Hi @jcmat : Though a function can return multiple values using a type structure but structure is one entity and we still say functions return only one value in the form of structure.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Paps23
2 years, 3 months agoNaveen_2022
2 years, 6 months agoAnubhav244
4 years agojcamt
4 years, 8 months agoAnubhav244
4 years agoNayruLove
5 years, 3 months agoCosminCof
4 years, 11 months ago