📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    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