Multiple choice technology databases

Which of the following is not a way to execute stored functions

  1. EXECUTE [or EXEC] database.function_name;

  2. employee_name := employer_details_func;

  3. SELECT employer_details_func FROM dual;

  4. dbms_output.put_line(employer_details_func);
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The EXECUTE command (or EXEC) is used for stored procedures, not stored functions. Functions are typically called within expressions (assignment), SELECT statements, or as parameters to other procedures like dbms_output.put_line. Option A shows procedure execution syntax, not function invocation.

Keep practicing — related questions