Joins in SQL and Python

What type of join returns all rows from the left table and matching rows from the right table, with NULLs in place where there is no match?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

Which join type returns only the rows where there is a match in both tables?

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• INNER JOIN

In SQL, which join type returns all rows when there is a match in either left or right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

What is the main difference between a LEFT JOIN and a RIGHT JOIN?

• LEFT JOIN returns unmatched rows from the right table, RIGHT JOIN returns unmatched rows from the left table

• LEFT JOIN returns unmatched rows from the left table, RIGHT JOIN returns unmatched rows from the right table

• LEFT JOIN requires matching columns, RIGHT JOIN does not

• There is no difference between LEFT JOIN and RIGHT JOIN

Which SQL clause is used to combine rows from two or more tables based on a related column between them?

• UNION

• JOIN

• MERGE

• CONCAT

Which join type will return unmatched rows from both the left and right tables, along with the matched rows?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

What will happen if you perform an INNER JOIN on two tables with no matching rows?

• All rows from both tables will be returned

• No rows will be returned

• Only unmatched rows will be returned

• A syntax error will occur

Which SQL JOIN clause is used to return only rows that have matching values in both tables?

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

• CROSS JOIN

When performing a FULL JOIN in SQL, what will be returned?

• Only the rows where there is a match in the right table

• All rows from both tables, with NULLs in place for missing matches

• Only the rows where there is a match in the left table

• None of the above

Which type of JOIN can be simulated using a UNION of LEFT and RIGHT JOIN results?

• INNER JOIN

• FULL JOIN

• CROSS JOIN

• NATURAL JOIN