SQL Server Interview Questions: Part5

1. What are the Different types of Joins in SQL Server?
2. Describe about Inner Join in SQL Server?
3. Describer about Left Outer Join in SQL SERVER?
4. Describer about Right Outer Join in SQL SERVER?
5. Describer about Full Outer Join in SQL SERVER?
6. Describer about Cartesian Product in SQL SERVER?
7. Describer about CROSS Join in SQL SERVER?
8. Describer about SELF Join in SQL SERVER?
9. If table A have 'X' records and table B have 'Y' records, then Cartesian product will have how many records?
10. Significance of JOIN in SQL Server?