Execution on a time activated basis according to a schedule is done by . . . . . . . .
A. Stored program
B. Events
C. Triggers
D. Stored procedures
Answer: Option B
Solution (By Examveda Team)
This question is asking about how you can make MySQL run a specific task on a regular schedule (like every day or every hour).Let's break down the options:
Option A: Stored program
A stored program is like a little piece of code that you can save in your database and run whenever you need it. It can be used for different things, but it doesn't automatically run on a schedule.
Option B: Events
This is the correct answer! An event is a special type of stored program in MySQL that lets you schedule tasks to run at specific times or intervals. This is exactly what we're looking for.
Option C: Triggers
A trigger is a special type of code that runs automatically when something happens in your database (like when a new row is added). It's not designed for scheduled tasks.
Option D: Stored procedures
Similar to stored programs, stored procedures are code you can save and run whenever you need. They don't automatically run on a schedule.
So, the answer is Option B: Events! They are the perfect way to schedule tasks in MySQL.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion