Which of the following is true about stored procedures?
A) Stored procedures cannot be passed parameters like a regular application function.
B) Stored procedures are stored as an embedded function in the application program.
C) Stored procedures are stored in the database.
D) Stored procedures are invoked automatically by the DBMS when specific events occur.
E) All of the above are true about stored procedures.

Question

Quizplus · Accepted Answer

Stored procedures are stored in the database, not within the application program. They can be called with parameters like a regular function, and are not invoked automatically by the DBMS.

Which of the Following Is True About Stored Procedures