Which of the following descriptions will usually qualify as a trigger?
A) DBMS denies inserting a row with a null key and warns the user with an error message
B) On sale of an item in the supermarket, inventory is updated and management is advised to restock the item
C) On entering nonexisting department number for a new employee in the table Employee, DBMS denies inserting the new row and warns the user with an error message
D) On entering nonexisting department number for a new employee in the table Employee, DBMS inserts a null value for the department number and warns the user

Question

Quizplus · Accepted Answer

A trigger is a database mechanism that automatically executes a specified action in response to certain events on a particular table or view, such as updating inventory and advising management to restock upon the sale of an item.

Which of the Following Descriptions Will Usually Qualify as a Trigger