SQL Joins week 8

SQL join combines only two database tables.

• True

• False

Which of the following is not a type of join?

• Complete Join

• Inner Join

• Outer Join

• Cross Join

Which one of the following is a outer join?

• Center Outer Join

• Complete Outer Join

• Full Outer Join

• Whole Outer Join

- - - is created by using INNER JOIN keyword.

• OUTER JOIN

• INNER JOIN

• FULL JOIN

• CROSS JOIN

INNER JOIN returns the data row in result set if the two columns values doesn't match.

• TRUE

• FALSE

In INNER JOIN the - - - clause defines the columns and condition to be evaluated.

• ON

• WHERE

• SELECT

• FROM

The - - - keyword is create a LEFT OUTER JOIN.

• LEFT OUTER JOIN

• LEFT JOIN

• JOIN LEFT

• FULL JOIN

The OUTER JOIN returns only matched data rows.

• TRUE

• FALSE

The LEFT OUTER JOIN returns all the data rows from - - -

• LEFT SIDE TABLE

• RIGHT SIDE TABLE

• BOTH THE TABLES

• NONE OF THE TABLES

The OUTER JOIN returns matched data rows as well as unmatched data rows from the table.

• TRUE

• FALSE