Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous