To be callable from a SQL expression, a user-defined function must do what?
A.
Be stored only in the database.
B.
Have both IN and OUT parameters.
C.
Use the positional notation for parameters.
D.
Return a BOOLEAN or VARCHAR2 data type.
Explanation:
Functions called from SQL statements must use positional notation to pass values to the IN
parameters.
Incorrect Answers:
A: Functions invoked using SQL statements must be stored in the database, however if they are
stored on the client this alone will not cause the statement to fail.
B: The function must only have parameters of the IN Mode for them to be used in a SQL
Expression.
D: You cannot use PL/SQL data types, such as BOOLEAN, RECORD, or TABLE for returning
values for the function to be callable from a SQL expression.
The 1Z0-147 (v.1) is the same as the former 1Z0-147.
Some question sentences became good, but some explanations worsened.
And the 1Z0-147 (v.1) does not include the question 25 of the previous 1Z0-147.
answer C cannot be correct. You can call a custom function using named notation as well. My guess would be answer A.
Yeah I agree with fj2.
First and foremost thing is that functions must be stored in the database.
When side-effects come into picture then we can move to option C.