DBMS | SQL | Question 1

The statement that is executed automatically by the system as a side effect of the modification of the database is
(A) backup
(B) assertion
(C) recovery
(D) trigger


Answer: (D)

Explanation: Triggers are the SQL codes that are automatically executed in response to certain events on a particular table.
These are used to maintain the integrity of the data.

A trigger in SQL works similar to a real-world trigger. For example, when the gun trigger is pulled a bullet is Fired.

Quiz of this Question

My Personal Notes arrow_drop_up

Save