The MySQL statement to store a stored procedure in the database is ________.
A)CREATE PROCEDURE
B)ALTER PROCEDURE
C)DROP PROCEDURE
D)CLOSE PROCEDURE

Question

Quizplus · Accepted Answer

The correct MySQL statement to store a stored procedure in the database is "CREATE PROCEDURE". This is used to create a new stored procedure with its parameters, code and other specifications. "ALTER PROCEDURE" is used to modify the existing stored procedure, "DROP PROCEDURE" is used to delete the stored procedure from the database and "CLOSE PROCEDURE" is not a valid MySQL statement.

The MySQL Statement to Store a Stored Procedure in the Database