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.
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)