Data Analytics Quiz 6

What type of join returns all rows when there is a match in one of the tables?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

Which of the following is not a type of SQL join?

• INNER JOIN

• OUTER JOIN

• CROSS JOIN

• EQUAL JOIN

What is the purpose of the SQL JOIN clause?

• To filter rows in a table

• To combine rows from two or more tables based on a related column

• To update data in a table

• To sort the result set

In an INNER JOIN, what happens if there is no match between the joined tables?

• The rows are discarded

• The rows are included with NULL values for columns from the other table

• An error is thrown

• The query is canceled

Which SQL keyword is used to perform a self-join?

• INNER

• SELF

• ON

• JOIN

What is the key difference between INNER JOIN and LEFT JOIN?

• INNER JOIN returns unmatched rows, while LEFT JOIN doesn't.

• LEFT JOIN returns unmatched rows, while INNER JOIN doesn't.

• There is no difference between them.

• INNER JOIN is used for self-joins, and LEFT JOIN is not.

Which of the following JOINs returns all rows when there is a match in one of the tables, and NULL values for columns from the other table when there is no match?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

What is the purpose of the USING clause in a SQL JOIN?

• To specify the columns for joining without using the ON keyword

• To limit the number of rows returned

• To filter rows based on a condition

• To sort the result set

Which of the following JOINs returns all rows when there is a match in both tables, and excludes rows with no match?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• SELF JOIN

In a SQL query with multiple JOINs, the order of the JOIN clauses can affect the result set. What is the correct order of execution for the JOIN clauses in a query with three tables A, B, and C?

• A JOIN B JOIN C

• A JOIN C JOIN B

• B JOIN A JOIN C

• C JOIN B JOIN A