Answer Posted / vamsi krishna

we can't say which is executed first among the trigger and
constraraint .
the sequence of execution is
(i) before statement level
(ii) before row level
(iii) after row level
(iv) constraint
(v) after statement level

What is the location of pre_defined_functions.

1166

---

What are joins in sql?

1044

---

What is the difference between alter trigger and drop trigger statements?

1109

---

What are all the different normalization?

1037

---

What is percent sign in sql?

1283

---

What are the 3 types of behavioral triggers?

1254

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

What are tables and fields?

1033

---

what are enums used for in mysql? : Sql dba

1170

---

What are the basic techniques of indexing?

1063

---

Why is a primary key important?

1043

---

What is forward declaration in pl sql?

1078

---

What is benefit of creating memory optimized table?

972

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1002

---

How delete all data from table in sql?

1019

---