Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous