Explain 3 basic parts of a trigger.



Explain 3 basic parts of a trigger...

Answer / Shyam Sunder

The three basic parts of a trigger are: (1) Event: The event that triggers the execution of the trigger, such as INSERT, UPDATE, or DELETE. (2) Condition: An optional condition that must be met for the trigger to execute. (3) Body: The code executed when the trigger is fired.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what are rollup and cube in t-sql? : Transact sql

1 Answers  


What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,


Why do we need a foreign key?

1 Answers  


Can we call a function containing dml statements in a select query?

1 Answers  


How do you explain an index number?

1 Answers  


which tcp/ip port does sql server run on? : Sql dba

1 Answers  


How to run sql statements through the web interface?

1 Answers  


what is the output of this query selet * from employee where 1=2 ??

11 Answers  


Why use subqueries instead of joins?

1 Answers  


Is subquery faster than join?

1 Answers  


In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,


When sql appeared?

1 Answers  


Categories