ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which value of event_scheduler enables checking status but not changing it at runtime?

Answer & Solution
Correct Answer: Option C
This question is about the event scheduler in MySQL. The event scheduler is like a timer that runs tasks at set times.

We need to find the option that lets you check the status of the event scheduler without being able to change it while the database is running.

Here's how the options break down:

* Option A: ON - This means the event scheduler is running and can be changed.
* Option B: OFF - This means the event scheduler is stopped and cannot be changed.
* Option C: DISABLED - This is the same as OFF, the event scheduler is stopped.
* Option D: ENABLED - This is the same as ON, the event scheduler is running.

The correct answer is Option B (OFF) or Option C (DISABLED).

These options let you check the status of the event scheduler (whether it's on or off) but you can't change it while the database is running.

To actually change the status of the event scheduler, you'd need to restart the database.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.