How many types of database triggers can be specified on a
table ? What are they ?
- 2 Answers
- 13269 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
Does sql*plus have a pl/sql engine?
How do you write an index?
What is sql*loader?
How does postgresql compare to oracle/db2/ms sql server/informix?
Which are the different character-manipulation functions in sql?
What is the difference between sql and mysql?
What are sql queries used for?
How can you know that statistics should be updated?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is the example of procedure?
What is a unique constraint?
What is the location of pre_defined_functions.
Explain the steps needed to create the scheduled job?
What is the main difference between sql and pl/sql?
Is t sql a programming language?
