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

Can we rollback truncate?

1083

---

how to start mysql server? : Sql dba

1279

---

Is primary key clustered index?

1028

---

Is primary key always clustered index?

1101

---

what are all the common sql function? : Sql dba

1141

---

What is the current version of postgresql?

1188

---

what is bcp? When does it used? : Sql dba

1065

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

how many tables will create when we create table, what are they? : Sql dba

1156

---

what is collation? : Sql dba

1242

---

what are the advantages of sql ? : Sql dba

1154

---

Can we use distinct and group by together?

1147

---

Does group by remove duplicates?

1120

---

What is the best sql course?

1064

---

Is inner join faster than left join?

1287

---