For which of the following are triggers not supported?
A. delete
B. update
C. insert
D. views
Answer: Option D
Solution (By Examveda Team)
This question is asking about triggers in MySQL. Triggers are like special instructions that automatically run when certain things happen in your database.They are usually used for things like:
- Keeping data consistent (making sure changes in one part of the database are reflected in other parts)
- Auditing changes (recording who changed what and when)
- Enforcing business rules (making sure data follows certain rules)
Now, the question asks which of the following don't support triggers. Here are the options:
A: delete - Triggers can definitely be used when you delete data.
B: update - Triggers can also work when data is updated.
C: insert - You can also use triggers when new data is inserted.
D: views - This is the answer! Views are virtual tables that don't actually store data. You can't create triggers on views.
So the correct answer is Option D: views.
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