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

How does left join work in sql?

1040

---

Do prepared statements prevent sql injection?

998

---

How do I make my sql query run faster?

1017

---

what is denormalization. : Sql dba

1162

---

List out the acid properties and explain?

1018

---

How many types of indexes are there in sql?

1041

---

Explain the purpose of %type and %rowtype data types?

975

---

What's the procedure?

982

---

Why do we create views in sql?

1217

---

What is clustered and nonclustered index in sql?

985

---

How do you use join?

995

---

Can you join a table to itself?

1222

---

Explain how exception handling is done in advance pl/sql?

1046

---

What is implicit cursor in pl sql?

1148

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1067

---