Answer Posted / sarat

There are 4 types of Triggers

# Row Triggers and Statement Triggers
# BEFORE and AFTER Triggers
# INSTEAD OF Triggers
# Triggers on System Events and User Events

A row trigger is fired each time the table is affected by
the triggering statement. A statement trigger is fired once
on behalf of the triggering statement.

BEFORE triggers run the trigger action before the triggering
statement is run. AFTER triggers run the trigger action
after the triggering statement is run.

INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE).

Can delete statement be rollbacked?

1065

---

Can we use distinct and group by together?

1146

---

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

1065

---

define sql insert statement ? : Sql dba

1108

---

what are the advantages of sql ? : Sql dba

1153

---

Do we need to rebuild index after truncate?

1151

---

What is the best sql course?

1062

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

how to escape special characters in sql statements? : Sql dba

1124

---

what is dbms? : Sql dba

1069

---

Does group by remove duplicates?

1120

---

how to start mysql server? : Sql dba

1279

---

Is primary key clustered index?

1026

---

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

1154

---

Is inner join faster than left join?

1287

---