Google News
logo
Database Testing - Interview Questions
What is the database trigger, how to verify the trigger is fired or not and can you invoke the trigger on demand?
Database trigger : A trigger is basically a stored procedure used to maintain the integrity of the data present in the database. It executes automatically to respond to a certain event of a table/view in a database.
 
To verify the trigger is fired or not; use the query of the common audit log will display the trigger of the data table.

Triggers can’t be invoked on-demand, it is invoked when a table displays an action (INSERT, DELETE & UPDATE) defined on that particular table.
Advertisement