Bhushan Dhumane

BASIC of MYSQL/SQL  : - How to test database procedures and triggers? Ans: The process of testing database procedures and triggers requires the knowledge of input parameters, output parameters, and EXEC statement. EXEC statement is helpful in running the procedure and observing the behavior of the tables. The EXEC command by itself can be used to execute a stored procedure:  example: EXEC master.dbo.xp_msver What is the database trigger, how to verify the trigger is fired or not and can you invoke trigger on demand? Ans: Database trigger: A trigger is basically a stored procedure used to maintain the integrity of the data present in the database, executes automatically to response to a certain event of a table/view in a database. To verify, the trigger is fired or not; use the query of common audit log will display the trigger of the data table. Triggers can’t be invoked on demand, it invoked when table displays an action (insert, delete & update) defined on that particul...