MySQL Events Quiz – Answertopia

This quiz will test your understanding of MySQL Events, including how to create, modify, and manage scheduled tasks using SQL commands. Answer the following questions to see how well you understand MySQL Events and their applications.

Which MySQL privilege is required to create events?

SUPER

TRIGGER

EVENT

SCHEDULE

None

Which SQL statement is used to create a MySQL event?

SCHEDULE EVENT

NEW EVENT

INSERT EVENT

CREATE EVENT

None

Which command is used to remove a scheduled event permanently?

DELETE EVENT event_name;

REMOVE EVENT event_name;

DISABLE EVENT event_name;

DROP EVENT event_name;

None

Which statement retrieves a list of all scheduled events?

LIST EVENTS;

SHOW EVENTS;

SELECT * FROM mysql.events;

DESCRIBE EVENTS;

None

What happens when the MySQL event scheduler is turned off?

Events will run once and then stop

Scheduled events will not execute

Events will execute but not update data

All events will be deleted

None

Which MySQL clause is used to specify an end time for a recurring event?

ENDS

UNTIL

LIMIT

STOP AT

None

How do MySQL events differ from triggers?

Events can only be executed manually, while triggers execute automatically

Events execute based on a time schedule, while triggers execute in response to table events

Triggers run at scheduled intervals, while events run immediately

Events only apply to a single table, while triggers apply to multiple tables

None

What is the correct syntax to enable the MySQL event scheduler?

ENABLE EVENT SCHEDULER;

START EVENT SCHEDULER;

SET GLOBAL event_scheduler = ON;

ALTER DATABASE ENABLE EVENT;

None

What is the primary purpose of MySQL events?

To enforce data integrity in MySQL tables

To execute code automatically in response to table modifications

To monitor and log database queries

To execute SQL statements at specified times or intervals

None

10.

How do you prevent an event from being automatically deleted after execution?

Store the event name in a separate table

Disable the `event_scheduler` global variable

Use `ON COMPLETION PRESERVE` in the `CREATE EVENT` statement

Use `ENABLE EVENT` after creation

None

11.

What is the default execution frequency for MySQL events?

Once per hour

Once per day

Once per week

They do not repeat unless explicitly specified

None

12.

How do you modify an existing event in MySQL?

CHANGE EVENT event_name

UPDATE EVENT event_name

ALTER EVENT event_name

MODIFY EVENT event_name

None

13.

Which command retrieves the full definition of an event?

SHOW CREATE EVENT event_name;

SHOW EVENT event_name;

DESCRIBE EVENT event_name;

SELECT * FROM information_schema.events WHERE event_name = ‘event_name’;

None

14.

Which function can be used to schedule an event relative to the current time?

NOW()

GETDATE()

CURRENT_TIME

CURRENT_TIMESTAMP

None

15.

Which global variable controls the execution of MySQL events?

mysql_event

event_handler

schedule_event

event_scheduler

None

16.

How do you create a recurring MySQL event that runs every day?

CREATE EVENT task_name RUN EVERY 1 DAY DO sql_statement;

CREATE RECURRING EVENT task_name DO sql_statement;

CREATE EVENT task_name EVERY DAY STARTS NOW() DO sql_statement;

CREATE EVENT task_name ON SCHEDULE EVERY 1 DAY DO sql_statement;

None

17.

How do you disable an event without deleting it?

ALTER EVENT event_name DISABLE;

DELETE EVENT event_name;

DROP EVENT event_name;

REMOVE EVENT event_name;

None

Enter your email address below if you would like to receive a copy of your quiz results.