Answer Posted / robert son das

There are total four(4) types of triggers..

they are:
before insert----row level
before delete--row level
before update--row level

before insert----statement level
before delete--statement level
before update--statement level

after insert----row level
after delete--row level
after update--row level

after insert----statement level
after delete--statement level
after update--statement level

instead of trigger--row level
instead of trigger--statement level

what is rollback? : Sql dba

753

---

What is the non-clustered index in sql?

749

---

Define commit?

739

---

Explain sql data types?

824

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

697

---

---

What is aggregate function in sql?

729

---

How will you distinguish a global variable with a local variable in pl/sql?

837

---

How do I remove all records from a table?

759

---

What is lexical units in pl sql?

750

---

What is the use of index in sql?

758

---

Is hadoop a nosql?

742

---

How much does sql cost?

730

---

Can we call stored procedure in function?

700

---

What is dynamic sql in pl sql?

702

---

What are synonyms in sql?

724

---