Examveda

Before MySQL 5.1.6 which privilege was required to create and drop triggers?

A. PRIVILEGE

B. TRIGGER

C. SUPER

D. MACRO

Answer: Option C

Solution (By Examveda Team)

This question is about MySQL privileges, which are permissions that control what you can do in a database.

Let's break down the options:
* Option A: PRIVILEGE - This is a general term for a permission in MySQL. It's not specific to creating triggers.
* Option B: TRIGGER - This sounds like it might be the right answer, but MySQL doesn't have a specific "TRIGGER" privilege.
* Option C: SUPER - This is a very powerful privilege that grants almost complete control over the database.
* Option D: MACRO - This isn't a standard MySQL privilege.
The answer: Before MySQL 5.1.6, you needed the SUPER privilege to create and drop triggers. This means you had a lot of power in the database. In short: The SUPER privilege was the boss in MySQL before version 5.1.6.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous