Question

Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?

A A function can accept `IN`/`OUT` parameters, while a procedure cannot.

B A function must always return a single value, while a procedure may or may not return values (via `OUT` parameters).

C A function can perform DML operations (`INSERT`, `UPDATE`, `DELETE`), while a procedure cannot.

D A function cannot be called directly from an SQL `SELECT` statement, while a procedure can.

E Functions are compiled every time they are executed, while procedures are compiled once.

More SQL Questions