Which two tasks should be created as functions instead of as procedures? (Choose two.)
A.
reference host or bind variables in a PL7SQL 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 an application
Explanation:
c,d
A. Host variable can be referenced in PL/SQL block with function(:hv:=function) and with procedure(procedure(:hv)) so this is no answer.
B. This is for procedure.
C. This is for function.
D. This is advantage of user-defined functions in SQL statements.
A,C
i think that vishes bansal WROTE right
C,D
C,D
C,D
C, D
C,D
answer: C and D
A. Host variable can be referenced in PL/SQL block with function(:hv:=function) and with procedure(procedure(:hv)) so this is no answer.
B. This is for procedure.
C. This is for function.
D. This is advantage of user-defined functions in SQL statements.
cd