srikanth keshavena


{ City } hyderabad
< Country > india
* Profession * corporate trainer
User No # 118655
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 0
Questions / { srikanth keshavena }
Questions Answers Category Views Company eMail




Answers / { srikanth keshavena }

Question { CSC, 76482 }

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

Is This Answer Correct ?    1 Yes 0 No

Question { i2, 44584 }

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

Is This Answer Correct ?    1 Yes 0 No