Multiple choice

Which of the following is incorrect about Stored Procedure in P/L SQL?

  1. It is a procedure to manage one or more tasks at a time.

  2. EXECUTE [or EXEC] procedure_name; can be used to execute the procedure.

  3. procedure_name; can be used to execute the procedure.

  4. One can pass parameters to procedures in three ways.

  5. The header consists of the name of the procedure and the parameters declaration section of the procedure.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The header does not have declaration section of procedure but the body section have it.

Keep practicing — related questions