Question { Amdocs, 95875 }

What are joins..how many types of joins are there?

Answer

Basically join's are three type's those are :

1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.Full outer join
d.Self join
3.Non-equi join

Question { i2, 50343 }

which will fire first ? Trigger or Constraint

Answer

The sequence of execution as follows :
1) before statement level
2) before row level
3) constraint
4) after row level
5) after statement level