Examveda

To create or drop events for a database, which privilege should be granted?

A. CREATE

B. DROP

C. PRIVILEGE

D. EVENT

Answer: Option D

Solution (By Examveda Team)

This question is about MySQL and how to manage events in a database.
Events in MySQL are like scheduled tasks that run automatically at specific times.
To create or delete (drop) these events, you need a specific permission or privilege.
Here's a breakdown of the options:
* Option A: CREATE: This privilege is for creating objects like tables, views, etc. It's not directly related to events.
* Option B: DROP: This privilege is for deleting objects like tables, views, etc. It's also not directly related to events.
* Option C: PRIVILEGE: This is a general term for permissions, but it's not a specific privilege for events.
* Option D: EVENT: This is the correct answer! The EVENT privilege allows you to create and drop events in your database.
Therefore, the correct answer is Option D: EVENT.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous