Test Your SQL INNER JOIN Knowledge with This MySQL Quiz

Progress

True / False

In MySQL, an INNER JOIN returns rows when there is at least one match in both tables.

True False

An INNER JOIN returns rows that have matching values in both tables.

True / False

In MySQL, the INNER JOIN keyword can be used to combine more than two tables.

True False

You can use INNER JOIN to combine multiple tables by chaining JOIN operations.

True / False

MySQL INNER JOIN and MySQL JOIN are functionally equivalent.

True False

By default, the JOIN keyword in MySQL refers to an INNER JOIN.

True / False

In MySQL, using INNER JOIN without specifying a condition will result in a syntax error.

True False

An INNER JOIN must have an ON clause to specify the condition for the join.

True / False

In MySQL, INNER JOIN can be used with the USING keyword to specify columns with the same name in both tables.

True False

The USING clause simplifies the syntax when columns with the same name are being joined.

True / False

MySQL INNER JOIN returns NULL values when there are no matching rows in one of the tables.

True False

INNER JOIN only returns rows with matching values in both tables; rows with no matches are excluded.

True / False

In MySQL, using an INNER JOIN on tables with no common columns will result in a cross join.

True False

An INNER JOIN without a common column or ON clause results in a syntax error, not a cross join.

True / False

MySQL can optimize INNER JOIN operations using indexes on the joined columns.

True False

Indexes on joined columns improve performance by reducing the amount of data MySQL needs to process.

True / False

In MySQL, INNER JOIN operations can be nested within subqueries to filter results

True False

INNER JOIN operations can be used within subqueries to further refine and filter the dataset.

Q10

True / False

When performing an INNER JOIN in MySQL, the order of the tables in the JOIN clause does not affect the result.

True False

The order of tables in an INNER JOIN does not affect the result as it always returns rows that have matching values in both tables. The order might impact performance but not the final output.

Q11

Single Choice

Which of the following MySQL keywords is used to combine rows from two or more tables, based on a related column between them?

SELECT WHERE INNER JOINDISTINCT

The INNER JOIN keyword is used in MySQL to combine rows from two or more tables based on a related column between them.

Q12

Single Choice

What will be the result of the following SQL query if there are matching rows in both tables?

SQL Code

SELECT employees.name, departments.department_name
FROM employees
INNER JOIN departments
ON employees.department_id = departments.department_id;

All rows from both tables Only rows with matching department_id in both tables Only rows with non-matching department_idAll rows from the employees table

The INNER JOIN keyword returns rows when there is a match in both tables on the specified column.

Q13

Single Choice

Which MySQL query correctly performs an INNER JOIN between the tables orders and customers to retrieve all order details along with customer names?

SELECT orders.order_id, customers.customer_name FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id; SELECT orders.order_id, customers.customer_name FROM orders LEFT JOIN customers ON orders.customer_id = customers.customer_id; SELECT orders.order_id, customers.customer_name FROM orders RIGHT JOIN customers ON orders.customer_id = customers.customer_id;SELECT orders.order_id, customers.customer_name FROM orders FULL JOIN customers ON orders.customer_id = customers.customer_id;

The correct INNER JOIN query matches rows from the orders table with corresponding rows in the customers table based on the customer_id column.

Q14

Single Choice

What does the following SQL query return?

SQL Code

SELECT p.product_name, c.category_name
FROM products p
INNER JOIN categories c
ON p.category_id = c.category_id
WHERE c.category_name = 'Electronics';

All products and their categories Only products that belong to the 'Electronics' category Only categories that are named 'Electronics'No rows since it filters out all data

The query uses an INNER JOIN to match products with their categories and then filters the result to only include products within the 'Electronics' category.

Q15

Single Choice

Consider the tables students and courses. How can you retrieve the names of students along with the course names they are enrolled in, excluding students not enrolled in any course?

SELECT students.name, courses.course_name FROM students LEFT JOIN courses ON students.course_id = courses.course_id; SELECT students.name, courses.course_name FROM students RIGHT JOIN courses ON students.course_id = courses.course_id; SELECT students.name, courses.course_name FROM students INNER JOIN courses ON students.course_id = courses.course_id;SELECT students.name, courses.course_name FROM students FULL JOIN courses ON students.course_id = courses.course_id;

The INNER JOIN will return only those students who are enrolled in a course, thus excluding students not enrolled in any course.

Q16

Single Choice

Which SQL query will return all customers along with their orders, but only if they have placed at least one order?

SELECT customers.customer_name, orders.order_date FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id; SELECT customers.customer_name, orders.order_date FROM customers LEFT JOIN orders ON customers.customer_id = orders.customer_id; SELECT customers.customer_name, orders.order_date FROM customers RIGHT JOIN orders ON customers.customer_id = orders.customer_id;SELECT customers.customer_name, orders.order_date FROM customers FULL JOIN orders ON customers.customer_id = orders.customer_id;

The INNER JOIN ensures that only customers with at least one corresponding order are included in the result set.

Q17

Single Choice

Given the tables employees and projects, how would you write a query to retrieve the names of employees who are currently working on projects, including the project names and the start date of the project?

SQL Code

SELECT e.employee_name, p.project_name, ep.start_date
FROM employees e
INNER JOIN employee_projects ep ON e.employee_id = ep.employee_id
INNER JOIN projects p ON ep.project_id = p.project_id;

The query is incorrect because of the multiple INNER JOINs. The query returns employees currently working on projects with their project names and start dates. The query would cause a Cartesian product due to multiple INNER JOINs.The query will not execute since a WHERE clause is missing.

The query uses INNER JOIN twice to match employees with their respective projects and retrieves the necessary information.

Q18

Single Choice

How can you modify the following SQL query to include employees who might not be assigned to any project?

SQL Code

SELECT e.employee_name, p.project_name
FROM employees e
INNER JOIN projects p ON e.employee_id = p.manager_id;

Use a RIGHT JOIN instead of an INNER JOIN. Add a WHERE clause to filter out null values. Change the INNER JOIN to a LEFT JOIN.The query is already correct

Changing INNER JOIN to LEFT JOIN will include all employees, even if they are not assigned to any project.

Q19

Single Choice

Which query correctly performs an INNER JOIN on the orders, products, and customers tables to list customer names, product names, and order dates?

SQL Code

SELECT c.customer_name, p.product_name, o.order_date
FROM orders o
INNER JOIN customers c ON o.customer_id = c.customer_id
INNER JOIN products p ON o.product_id = p.product_id;

The query will result in an error due to the multiple INNER JOINs. The query will return a list of customer names, product names, and order dates. The query is incorrect; a WHERE clause is needed.The query will return only customer names and order dates

The query uses INNER JOIN to correctly relate the three tables and retrieve the desired information

Q20

Single Choice

You have two tables, students and exams. The students table contains a list of students and the exams table contains a list of exams taken by the students. Write a query to find the names of students who have taken at least one exam, along with their scores.

SQL Code

SELECT s.student_name, e.exam_score
FROM students s
INNER JOIN exams e ON s.student_id = e.student_id;

This query will return all students, regardless of whether they have taken an exam. This query will return only students who have taken at least one exam, along with their scores. The query is incorrect and will return an errorThe query will return a Cartesian product of the students and exams tables.

The INNER JOIN ensures that only students who have taken an exam are included in the result, along with their corresponding exam scores.

Q21

Multiple Choice

Which SQL query uses INNER JOIN to combine records from the 'employees' and 'departments' tables based on a common 'department_id'?

SQL Code

SELECT e.employee_id, e.name, d.department_name
FROM employees e
INNER JOIN departments d ON e.department_id = d.department_id;

SELECT e.employee_id, e.name, d.department_name FROM employees e INNER JOIN departments d ON e.department_id = d.department_id; SELECT e.employee_id, e.name, d.department_name FROM employees e JOIN departments d ON e.department_id = d.department_id; SELECT e.employee_id, d.department_name FROM employees e INNER JOIN departments d ON e.department_id = d.department_id;SELECT e.employee_id, e.name, d.department_name FROM employees e LEFT JOIN departments d ON e.department_id = d.department_id;

This query combines records from the 'employees' and 'departments' tables using an INNER JOIN on the 'department_id' column, returning only matching rows.

Q22

Multiple Choice

Identify the correct SQL query that uses INNER JOIN to list all orders with their corresponding customer names from the 'orders' and 'customers' tables.

SQL Code

SELECT o.order_id, o.order_date, c.customer_name
FROM orders o
INNER JOIN customers c ON o.customer_id = c.customer_id;

SELECT o.order_id, o.order_date, c.customer_name FROM orders o INNER JOIN customers c ON o.customer_id = c.customer_id; SELECT o.order_id, o.order_date, c.customer_name FROM orders o JOIN customers c ON o.customer_id = c.customer_id; SELECT order_id, order_date, customer_name FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;SELECT o.order_id, o.order_date, c.customer_name FROM orders o LEFT JOIN customers c ON o.customer_id = c.customer_id;

The INNER JOIN is used to combine rows from the 'orders' and 'customers' tables where there is a match on the 'customer_id' column.

Q23

Multiple Choice

Which SQL query uses INNER JOIN to retrieve a list of products along with their respective category names from the 'products' and 'categories' tables?

SQL Code

SELECT p.product_id, p.product_name, c.category_name
FROM products p
INNER JOIN categories c ON p.category_id = c.category_id;

SELECT p.product_id, p.product_name, c.category_name FROM products p INNER JOIN categories c ON p.category_id = c.category_id; SELECT p.product_id, p.product_name, c.category_name FROM products p JOIN categories c ON p.category_id = c.category_id; SELECT product_id, product_name, category_name FROM products INNER JOIN categories ON products.category_id = categories.category_id;SELECT p.product_id, p.product_name, c.category_name FROM products p LEFT JOIN categories c ON p.category_id = c.category_id;

The INNER JOIN combines the 'products' and 'categories' tables on the 'category_id' column, returning only matching rows.

Q24

Multiple Choice

Determine the correct SQL query that uses INNER JOIN to fetch all student records along with their corresponding course names from the 'students' and 'courses' tables.

SQL Code

SELECT s.student_id, s.student_name, c.course_name
FROM students s
INNER JOIN courses c ON s.course_id = c.course_id;

SELECT s.student_id, s.student_name, c.course_name FROM students s INNER JOIN courses c ON s.course_id = c.course_id; SELECT s.student_id, s.student_name, c.course_name FROM students s JOIN courses c ON s.course_id = c.course_id; SELECT student_id, student_name, course_name FROM students INNER JOIN courses ON students.course_id = courses.course_id;SELECT s.student_id, s.student_name, c.course_name FROM students s LEFT JOIN courses c ON s.course_id = c.course_id;

This query uses INNER JOIN to combine records from 'students' and 'courses' tables based on matching 'course_id' values.

Q25

Multiple Choice

Which SQL query uses INNER JOIN to display all transaction details along with their respective client names from the 'transactions' and 'clients' tables?

SQL Code

SELECT t.transaction_id, t.amount, c.client_name
FROM transactions t
INNER JOIN clients c ON t.client_id = c.client_id;

SELECT t.transaction_id, t.amount, c.client_name FROM transactions t INNER JOIN clients c ON t.client_id = c.client_id; SELECT t.transaction_id, t.amount, c.client_name FROM transactions t JOIN clients c ON t.client_id = c.client_id; SELECT transaction_id, amount, client_name FROM transactions INNER JOIN clients ON transactions.client_id = clients.client_id;SELECT t.transaction_id, t.amount, c.client_name FROM transactions t LEFT JOIN clients c ON t.client_id = c.client_id;

The INNER JOIN is used to retrieve records from the 'transactions' and 'clients' tables where the 'client_id' matches in both tables.

Q26

Multiple Choice

Which SQL query uses INNER JOIN to combine the 'orders' and 'products' tables to find the total sales amount for each product?

SQL Code

SELECT p.product_name, SUM(o.quantity * p.price) AS total_sales
FROM orders o
INNER JOIN products p ON o.product_id = p.product_id
GROUP BY p.product_name;

SELECT p.product_name, SUM(o.quantity * p.price) AS total_sales FROM orders o INNER JOIN products p ON o.product_id = p.product_id GROUP BY p.product_name; SELECT product_name, SUM(quantity * price) AS total_sales FROM orders INNER JOIN products ON orders.product_id = products.product_id GROUP BY product_name; SELECT p.product_name, SUM(o.quantity * p.price) AS total_sales FROM orders o JOIN products p ON o.product_id = p.product_id GROUP BY p.product_name;SELECT p.product_name, total_sales = SUM(o.quantity * p.price) FROM orders o INNER JOIN products p ON o.product_id = p.product_id GROUP BY p.product_name;

The INNER JOIN is used to combine records from 'orders' and 'products' based on 'product_id', followed by grouping to calculate the total sales for each product.

Q27

Multiple Choice

Identify the correct SQL query that uses INNER JOIN to fetch all employees who have placed orders, combining data from the 'employees' and 'orders' tables.

SQL Code

SELECT e.employee_id, e.name, o.order_id
FROM employees e
INNER JOIN orders o ON e.employee_id = o.employee_id;

SELECT e.employee_id, e.name, o.order_id FROM employees e INNER JOIN orders o ON e.employee_id = o.employee_id; SELECT e.employee_id, e.name, o.order_id FROM employees e JOIN orders o ON e.employee_id = o.employee_id; SELECT employee_id, name, order_id FROM employees INNER JOIN orders ON employees.employee_id = orders.employee_id;SELECT e.employee_id, e.name, o.order_id FROM employees e LEFT JOIN orders o ON e.employee_id = o.employee_id;

This query uses INNER JOIN to combine records from the 'employees' and 'orders' tables where the 'employee_id' matches, showing only employees who have placed orders.

Q28

Multiple Choice

Which SQL query uses INNER JOIN to retrieve all customer orders along with their respective shipping details from the 'orders' and 'shipping' tables?

SQL Code

SELECT o.order_id, o.order_date, s.shipping_date
FROM orders o
INNER JOIN shipping s ON o.order_id = s.order_id;

SELECT o.order_id, o.order_date, s.shipping_date FROM orders o INNER JOIN shipping s ON o.order_id = s.order_id; SELECT o.order_id, o.order_date, s.shipping_date FROM orders o JOIN shipping s ON o.order_id = s.order_id; SELECT order_id, order_date, shipping_date FROM orders INNER JOIN shipping ON orders.order_id = shipping.order_id;SELECT o.order_id, o.order_date, s.shipping_date FROM orders o LEFT JOIN shipping s ON o.order_id = s.order_id;

The INNER JOIN is used to combine records from the 'orders' and 'shipping' tables based on the common 'order_id', returning matching records.

Q29

Multiple Choice

Determine the correct SQL query that uses INNER JOIN to list all teachers along with the classes they are teaching, combining data from the 'teachers' and 'classes' tables.

SQL Code

SELECT t.teacher_id, t.name, c.class_name
FROM teachers t
INNER JOIN classes c ON t.teacher_id = c.teacher_id;

SELECT t.teacher_id, t.name, c.class_name FROM teachers t INNER JOIN classes c ON t.teacher_id = c.teacher_id; SELECT teacher_id, name, class_name FROM teachers INNER JOIN classes ON teachers.teacher_id = classes.teacher_id; SELECT t.teacher_id, t.name, c.class_name FROM teachers t JOIN classes c ON t.teacher_id = c.teacher_id;SELECT t.teacher_id, t.name, c.class_name FROM teachers t LEFT JOIN classes c ON t.teacher_id = c.teacher_id;

The INNER JOIN combines records from the 'teachers' and 'classes' tables on the 'teacher_id' column, returning only matching rows.

Q30

Multiple Choice

Which SQL query correctly uses INNER JOIN to retrieve a list of all projects and their corresponding manager names from the 'projects' and 'managers' tables?

SQL Code

SELECT p.project_name, m.manager_name
FROM projects p
INNER JOIN managers m ON p.manager_id = m.manager_id;

SELECT p.project_name, m.manager_name FROM projects p INNER JOIN managers m ON p.manager_id = m.manager_id; SELECT project_name, manager_name FROM projects INNER JOIN managers ON projects.manager_id = managers.manager_id; SELECT p.project_name, m.manager_name FROM projects p JOIN managers m ON p.manager_id = m.manager_id;SELECT p.project_name, m.manager_name FROM projects p LEFT JOIN managers m ON p.manager_id = m.manager_id;

This query uses INNER JOIN to combine records from the 'projects' and 'managers' tables based on the 'manager_id' column, returning only matching rows.

MySQL Database Quiz Questions