Oracle Database: Advanced PL/SQL — Question 28

Which three are true about user-defined functions? (Choose three.)

Answer options

• A. They can be used in ORDER BY and GROUP BY clauses.
• B. They can be executed as standalone commands.
• C. They must be defined with at least one parameter.
• D. They need not return any values.
• E. They can appear in the select list of a SELECT statement.
• F. Functions can call only other functions.
• G. They can be used in CONNECT BY and START WITH clauses.

Correct answer: A, E, G

Explanation

The correct answers A, E, and G reflect that user-defined functions can indeed be used in ORDER BY, GROUP BY, and appear in the select list of a SELECT statement, as well as in CONNECT BY and START WITH clauses. Options B, C, and F are incorrect because user-defined functions can be executed within SQL statements rather than standalone, they do not need to have parameters, and they can call procedures as well as other functions.