Q1000
For which of the following are triggers not supported?
A.
delete
B.
update
C.
insert
D.
views
AnswerAnswer: 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.