Which of the following statements is True?
A) After IN OUT parameters are included in functions, the function can no longer be used in SQL statements.
B) After OUT parameters are included in functions, the function can no longer be used in SQL statements.
C) After INOUT parameters are included in functions, the function can no longer be used in SQL statements.
D) After IN parameters are included in functions, the function can no longer be used in SQL statements.

Question

Quizplus · Accepted Answer

Functions in SQL can return a value and can be used in SQL statements if they only take IN parameters. When a function has OUT or INOUT parameters, it cannot be used in SQL statements because these parameters imply that the function is expected to modify the parameter, which is not allowed in the context of a SQL statement where a deterministic return value is expected.

Which of the Following Statements Is True