How many types of database triggers can be specified on a
table ? What are they ?
- 2 Answers
- 13313 Views
- I also Faced
- E-Mail Answers
Answer Posted / nilesh
There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS
Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE
and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)
ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)
STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
how to dump a table to a file with 'mysqldump'? : Sql dba
how to get a list of all tables in a database? : Sql dba
Inline the values in PL/SQL, what does it mean.?
What is trigger in pl sql?
what is isam? : Sql dba
How do I order by ascending in sql?
what is sql in mysql? : Sql dba
what is column? : Sql dba
What do we need to check in database testing?
Explain the structure of pl/sql in brief.
what tools available for managing mysql server? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
How many clustered indexes can be created on a table?
What is indexes?
what is a constraint? Tell me about its various levels. : Sql dba
