Examveda

Which statement is used to check the status of the event scheduler at runtime?

A. SHOW STATUS OF 'event_scheduler'

B. SHOW VARIABLES OF 'event_scheduler'

C. SHOW STATUS LIKE 'event_scheduler'

D. SHOW VARIABLES LIKE 'event_scheduler'

Answer: Option D

Solution (By Examveda Team)

This question is about how to check if the event scheduler in MySQL is working. The event scheduler is a feature that lets you run tasks automatically at specific times or intervals.
To find out if it's active, you need to use a special command.
The correct answer is Option D: SHOW VARIABLES LIKE 'event_scheduler'
Let's break down why:
* SHOW VARIABLES is the command to view the current settings (variables) in MySQL.
* LIKE 'event_scheduler' filters the results to show only the variable related to the event scheduler.
The output will tell you if the event scheduler is ON or OFF.
Let me know if you'd like me to explain other MySQL concepts.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous