Examveda

Triggers are not supported for . . . . . . . .

A. delete

B. update

C. insert

D. views

Answer: Option D

Solution (By Examveda Team)

Triggers are like special instructions that automatically run when certain events happen in your database. These events are usually related to changes in data like inserting, updating, or deleting rows in a table.

Now, the question is asking about something that triggers don't work with.

Let's break down the options:
Option A: delete - Triggers can be used with DELETE statements. They can execute actions before or after a row is deleted.
Option B: update - Triggers can be used with UPDATE statements. They can execute actions before or after a row is updated.
Option C: insert - Triggers can be used with INSERT statements. They can execute actions before or after a row is inserted.
Option D: views - This is the correct answer! Triggers cannot be directly applied to views. Views are virtual tables based on other tables, and they don't have their own data storage.
Therefore, the correct answer is Option D: views.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous