Which of the following SQL JOINs will return rows where no matching records exist in both tables?

What is the result of performing a FULL OUTER JOIN on two tables where every row in both tables has a match?

Which SQL JOIN type returns all rows from the right table, even if there is no corresponding row in the left table?

How do you handle NULL values when using an INNER JOIN in SQL?

Which of the following statements is true about a RIGHT JOIN?

In an INNER JOIN, if there are duplicate rows in both tables based on the join condition, what will the result be?

When using a LEFT JOIN, which of the following occurs when there is no matching row in the right table?

Which SQL JOIN returns rows from both tables when there is a match, but includes unmatched rows from both tables as NULL?

In SQL, which join type is used when you want to retrieve rows with no matching data from one table but still include them?

What is the primary purpose of a CROSS JOIN?