What are the types of triggers ?
Answer Posted / nitin
There is
1)DML trigger: with before/after,for each row/for statement,and for 3 types of DML operation.
2)Instead of trigger.
3)Database level trigger: Triggers on DDL statement.
4)System level trigger.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql database free?
When is the explicit cursor used ?
What are the different types of constraints?
Is a secondary key the same as a foreign key?
Can we have two clustered index on a table?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is difference sql and mysql?
What is group by in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
What are functions in sql?
Explain the difference between triggers and constraints?
What are the different sql languages?
What does <> sql mean?