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

What are the syntax and use of the coalesce function?

1206

---

What is parameter substitution in sql?

1029

---

Explain the significance of the & and && operators in pl sql.

1009

---

what is the difference between truncate and drop statements? : Sql dba

1126

---

How do I audit the sql sent to the server?

1010

---

What is Collation Sensitivity ? What are the various type ?

952

---

Is sql a backend language?

1096

---

What are the ways on commenting in a pl/sql code?

1135

---

How many types of relationship are there?

1031

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

What is sql constant?

1036

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1042

---

What are sql indexes?

1001

---

Why use subqueries instead of joins?

1081

---

What are different types of tables in sql?

998

---