📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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. Correct Answer Incorrect Answer
      B A function must always return a single value, while a procedure may or may not return values (via `OUT` parameters). Correct Answer Incorrect Answer
      C A function can perform DML operations (`INSERT`, `UPDATE`, `DELETE`), while a procedure cannot. Correct Answer Incorrect Answer
      D A function cannot be called directly from an SQL `SELECT` statement, while a procedure can. Correct Answer Incorrect Answer
      E Functions are compiled every time they are executed, while procedures are compiled once. Correct Answer Incorrect Answer

      Solution

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

      Practice Next
      More SQL Questions
      ask-question