Vidyalelo
MySQL · Q1000

MySQL

Programming · MySQL · question 1000

Q1000

For which of the following are triggers not supported?

A.
delete
B.
update
C.
insert
D.
views
Answer

Answer: Option D

Solution

Answer: Option D
Solution:
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.