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

Which type of JOIN returns only the rows that have matching values in both tables being joined?

Which type of JOIN returns all the rows from the left table and the matched rows from the right table?

Which type of JOIN returns all the rows from the right table and the matched rows from the left table?

Which SQL keyword is used to combine the result sets of two or more SELECT statements into a single result set?

Which SQL keyword is used to combine the result sets of two or more SELECT statements and includes duplicate rows in the final result set?

Which SQL keyword is used to retrieve only the distinct (unique) values from a single column in a table?

Which SQL keyword is used to combine the result sets of two or more SELECT statements and returns only the rows that appear in both result sets?

Which SQL keyword is used to combine the result sets of two or more SELECT statements and returns all the rows from the first result set that are not present in the second result set?