MySQL Joins Quiz – Answertopia

Joins allow us to combine data from multiple tables based on a common column, helping retrieve meaningful results efficiently. MySQL supports INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and FULL OUTER JOIN(simulated using UNION).

The UNION and UNION ALL operators merge result sets from multiple queries, with UNION removing duplicates and UNION ALL keeping them.

This quiz will test your understanding of MySQL joins and unions.

How can you retrieve only matching records from two tables, ensuring no duplicate records appear in the final result set?

Use INNER JOIN

Use LEFT JOIN

Use UNION ALL

Use CROSS JOIN

None

What is the purpose of the ON clause in a JOIN statement?

To specify the condition for joining tables

To combine duplicate records

To sort query results

To remove NULL values

None

What does a CROSS JOIN do?

None of the above

Joins two tables and excludes NULL values

Returns all possible combinations of rows from two tables

Matches rows from both tables based on a common column

None

Which type of join can result in a Cartesian product?

CROSS JOIN

RIGHT JOIN

INNER JOIN

LEFT JOIN

None

Which type of join returns only matching rows from both tables?

LEFT JOIN

CROSS JOIN

RIGHT JOIN

INNER JOIN

None

What is the difference between UNION and UNION ALL?

UNION ALL removes duplicate rows, while UNION includes them

There is no difference

UNION only works with INNER JOIN

UNION removes duplicate rows, while UNION ALL includes them

None

Which SQL keyword is used to perform a full outer join in MySQL?

FULL JOIN

UNION of LEFT JOIN and RIGHT JOIN

CROSS JOIN

FULL OUTER JOIN

None

Which statement correctly performs an INNER JOIN between two tables named 'customers' and 'orders'?

SELECT * FROM customers INNER JOIN orders ON customers.id = orders.customer_id;

SELECT * FROM customers, orders;

SELECT * FROM customers JOIN orders;

SELECT * FROM customers CROSS JOIN orders;

None

What is a foreign key?

An automatically generated value

A primary key of another table used to establish a relationship

A unique identifier for a table

A column that allows duplicate values

None

10.

Which SQL operator is used to combine the results of multiple SELECT queries?

MERGE

GROUP BY

UNION

JOIN

None

11.

What happens if you perform a RIGHT JOIN and there are no matching records in the left table?

No rows are returned

Only matching rows are shown

The query fails

The rows from the right table are displayed with NULL values for the left table columns

None

12.

What is the primary purpose of using joins in MySQL?

To delete duplicate records

To create new tables

To improve indexing performance

To combine rows from two or more tables based on related columns

None

13.

How can you combine two result sets that have the same structure but remove duplicate rows?

Use UNION ALL

Use CROSS JOIN

Use INNER JOIN

Use UNION

None

14.

Which join includes all records from the right table and only matching records from the left table?

CROSS JOIN

LEFT JOIN

INNER JOIN

RIGHT JOIN

None

15.

Which MySQL function is useful in joins to handle NULL values?

COALESCE()

IFNULL()

ISNULL()

All of the above

None

16.

What does the USING clause do in a JOIN?

Removes duplicate rows

Combines multiple columns into a single key

Specifies a common column between two tables without prefixing table names

Creates a new index on the table

None

17.

What will a LEFT JOIN return if there are no matching records in the right table?

No results

All rows from the left table with NULL values for non-matching rows

Only matching rows

All rows from the right table

None

Enter your email address below if you would like to receive a copy of your quiz results.