Oracle
1Z0-144 · Question #41
Which two tasks should be created as functions instead of as procedures? (Choose two.)
The correct answer is C. This is for function. D. This is advantage of user-defined functions in SQL statements. procedure(procedure(:hv)) so this is no answer.
Configuring JDBC Data Sources
Question
Which two tasks should be created as functions instead of as procedures? (Choose two.)
Options
- AHost variable can be referenced in PL/SQL block with function(:hv:=function) and with
- BThis is for procedure.
- CThis is for function.
- DThis is advantage of user-defined functions in SQL statements.
How the community answered
(34 responses)- A18% (6)
- B12% (4)
- C71% (24)
Explanation
procedure(procedure(:hv)) so this is no answer.
Topics
#functions vs procedures#user-defined functions#SQL statements#PL/SQL
Community Discussion
No community discussion yet for this question.