Question

The statement that alters an existing event to have the given definition is _____________

(a) ALTER EVENT

(b) ALTER DATABASE

(c) ALTER FUNCTION

(d) ALTER DATABASE

This question was posed to me by my college director while I was bunking the class.

Asked question is from SQL Statement Syntax (Non-Compound Statements) in chapter SQL Syntax of MySQL

Answer 1

Correct option is (a) ALTER EVENT

For explanation: The statement ‘ALTER EVENT’ alters an existing event to have the given definition. The ‘RENAME TO’ clause renames the event. The other clauses are described in the entry for ‘CREATE EVENT’.