Which of the following events will NOT cause a trigger to be activated?
-
A select operation
-
An insert operation
-
An update operation
-
A delete operation
A
Correct answer
Explanation
In database systems, triggers are event-driven programs that automatically execute in response to specific data manipulation operations. The standard trigger events are INSERT, UPDATE, and DELETE operations which modify data. SELECT operations only read data and do not modify it, therefore they cannot activate triggers. This design ensures triggers are only fired when actual data changes occur, maintaining data integrity and preventing unnecessary trigger executions during read-only queries.