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.
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