Answer / 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.)

Answer / biswajit biswal

We can specified 28 Database triggers on a single table.

Before Row level insert
After Statement level update
Delete
insert or update
update or delete
insert or delete
insert or update or delete

2*2*7=28

What is an alias command?

0 Answers  

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

---

What is mutating error?

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

What is integrity in sql?

0 Answers  

---

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

What is pl/sql tables?

7 Answers   TCS,

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

State some properties of relational databases?

0 Answers  

---

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

---

What is sql basics?

0 Answers  

---

define sql insert statement ? : Sql dba

0 Answers  

---