Welcome to your Different Joins In SQL

1. How many types of joins are there?

a. 3

b. 4

2. Which Join will fetch matched and unmatched records between the two tables?

a. Self Join

b. Full Outer Join

3. How many types of Outer Joins do we have?

a. 2

b. 3

4. Self Join tables to itself?

a. Yes

b. No

5. Which Join do we use to fetch data from the Left Table?

a. Left Outer Join

b. Right Outer Join

6. Which Join do we use to fetch data from the Right Table?

a. Left Outer Join

b. Right Outer Join

7. What is CC?

a. Common Column

b. Combination Column

8. Which Join in SQL is used for getting each record crossed with each other?

a. Cross Join

b. Inner Join

9. Inner Join null value exist?

a. Yes

b. No

10. Which Join return matched values and unmatched values from either or both tables?

a. Outer join

b. Inner Join

Different Joins In SQL