Answer Posted / vijay

12 types of trigger

SATEMENT LEVEL TRIGGER
1.before insert
2.before update
3.before delete
4.after insert
5.after update
6.after delete

ROW LEVEL TRIGGER
7.before insert
8.before update
9.before delete
10.after insert
11.after update
12.after delete

What is a column in a table?

1119

---

What is schema in sql example?

1173

---

How do you update a value in sql?

1043

---

How bulk collect improves performance?

999

---

What are system versioned tables?

1024

---

What is rollback?

1110

---

What programs use sql?

1002

---

What is clustered index sql?

984

---

What is the difference between syntax error and runtime error?

1138

---

How can we make an if statement within a select statement?

1008

---

Why truncate is faster than delete?

1107

---

Can we have two clustered index on a table?

1024

---

what is the difference between truncate and delete statement? : Transact sql

1060

---

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

1038

---

How to order siblings in oracle hierarchy queries?

1041

---