Test Your MySQL IN Operator Knowledge with Our SQL Quiz

Progress

True / False

In MySQL, the "IN" keyword can be used to specify multiple values in a "WHERE" clause.

True False

The "IN" keyword allows you to specify multiple values in a "WHERE" clause. It is used to reduce the need for multiple "OR" conditions.

True / False

In MySQL, the "IN" keyword is case-sensitive by default.

True False

MySQL string comparisons are not case-sensitive by default unless the collation specifies otherwise.

True / False

The "IN" keyword in MySQL can be used with both numeric and string values.

True False

The "IN" keyword can be used with any type of data that can be listed in a comma-separated list, including both numeric and string values.

True / False

In MySQL, the "IN" keyword cannot be used with a subquery.

True False

The "IN" keyword can be used with a subquery to check if a value exists in a set of values returned by the subquery.

True / False

The "IN" keyword in MySQL can be used to filter results based on a list of values from a column in another table.

True False

You can use the "IN" keyword with a subquery to filter results based on values from another table.

True / False

In MySQL, using the "IN" keyword can be less efficient than using multiple "OR" conditions.

True False

Using the "IN" keyword is generally more efficient than using multiple "OR" conditions because it is optimized for this purpose.

True / False

In MySQL, you cannot use the "IN" keyword to compare multiple columns at once.

True False

MySQL allows the use of the "IN" keyword to compare multiple columns by using a tuple. For example, (col1, col2) IN ((val1, val2), (val3, val4)).

True / False

The "IN" keyword in MySQL can be used in the "SELECT" clause to return only specific columns.

True False

The "IN" keyword is used in the "WHERE" clause to filter rows, not in the "SELECT" clause to return specific columns.

True / False

In MySQL, you can use the "IN" keyword with a set of values derived from a join.

True False

You can use the "IN" keyword with a set of values derived from a join operation in a subquery.

Q10

True / False

In MySQL certification exams, understanding the "IN" keyword's performance implications compared to "EXISTS" and "JOIN" is crucial.

True False

Certification exams often test knowledge of query performance. The "IN" keyword can have different performance implications compared to "EXISTS" and "JOIN" based on the context, making it important to understand these differences.

Q11

Single Choice

Which of the following SQL statements correctly uses the IN operator to filter results?

SQL Code

SELECT name FROM employees WHERE department IN ('Sales', 'HR');

SELECT name FROM employees WHERE department = 'Sales' OR department = 'HR'; SELECT name FROM employees WHERE department IN ('Sales', 'HR'); SELECT name FROM employees WHERE department = 'Sales' AND department = 'HR';SELECT name FROM employees WHERE department IN 'Sales', 'HR';

The IN operator is used to specify multiple values in a WHERE clause, and the correct syntax is IN ('value1', 'value2').

Q12

Single Choice

What will be the result of the following SQL query?

SQL Code

SELECT id FROM products WHERE category IN ('Electronics', 'Furniture');

The query returns products from the 'Electronics' category only. The query returns products from the 'Furniture' category only The query returns products from both 'Electronics' and 'Furniture' categories.The query will throw an error

The IN operator checks if a value matches any value in a list, so this query returns products from both specified categories.

Q13

Single Choice

Which keyword is used in MySQL to check if a value matches any value in a list of values?

BETWEEN LIKE INDISTINCT

The IN keyword is used to compare a value to a list of literal values that have been specified.

Q14

Single Choice

What will the following SQL query return?

SQL Code

SELECT name FROM customers WHERE age IN (25, 30, 35);

Customers whose age is 25, 30, or 35 Customers whose age not is 25, 30, or 35 All customers in the databaseNone of the above

The IN operator checks if the age of customers is one of the values specified in the list (25, 30, or 35).

Q15

Single Choice

Given the following SQL code, what would be the output?

SQL Code

SELECT COUNT(*) FROM orders WHERE status IN ('Pending', 'Shipped');

The total number of orders that are either 'Pending' or 'Shipped' The total number of orders that are 'Pending' The total number of orders that are 'Shipped'All orders in the table

The IN operator filters the orders to count only those with a status of 'Pending' or 'Shipped'.

Q16

Single Choice

Which of the following SQL queries is equivalent to the given query using the IN operator?

SQL Code

SELECT id FROM employees WHERE job_title IN ('Manager', 'Developer');

SELECT id FROM employees WHERE job_title = 'Manager' AND job_title = 'Developer'; SELECT id FROM employees WHERE job_title = 'Manager' OR job_title = 'Developer'; SELECT id FROM employees WHERE job_title NOT IN ('Manager', 'Developer');SELECT id FROM employees WHERE job_title IS NULL;

The IN operator can be rewritten using the OR operator, so this query is equivalent to job_title = 'Manager' OR job_title = 'Developer'.

Q17

Single Choice

What will be the result of the following query if no values match the IN condition?

SQL Code

SELECT name FROM suppliers WHERE country IN ('Canada', 'Mexico');

The query returns all suppliers. The query returns suppliers from countries other than 'Canada' and 'Mexico'. The query returns an empty result set.The query throws an error

If no rows match the IN condition, the query will return an empty result set without any errors.

Q18

Single Choice

Consider a table students with a column grade. Which of the following queries returns students with grades not in 'A', 'B', or 'C'?

SQL Code

SELECT name FROM students WHERE grade NOT IN ('A', 'B', 'C');

The query returns students with grades 'A', 'B', or 'C'. The query returns students with grades other than 'A', 'B', or 'C'. The query returns all students.The query throws an error.

The NOT IN operator returns all rows where the value of grade is not 'A', 'B', or 'C'.

Q19

Single Choice

Which of the following SQL queries will correctly return employees whose department IDs are either 101 or 102, assuming NULL is not considered in the department IDs?

SQL Code

SELECT id FROM employees WHERE department_id IN (101, 102);

SELECT id FROM employees WHERE department_id IN (101, 102) OR department_id IS NULL; SELECT id FROM employees WHERE department_id = 101 AND department_id = 102; SELECT id FROM employees WHERE department_id IN (101, 102);SELECT id FROM employees WHERE department_id BETWEEN 101 AND 102;

The IN operator is correctly used to filter for department IDs that are either 101 or 102.

Q20

Single Choice

In the context of a certification exam, which query using the IN operator would be most efficient when dealing with a large list of values to match against a single column?

SQL Code

SELECT product_id FROM products WHERE category_id IN (SELECT category_id FROM categories WHERE category_name = 'Electronics');

Using IN with a subquery as shown Using multiple OR conditions Using a JOIN instead of INUsing a UNION instead of IN

When dealing with large datasets, using IN with a subquery is often more efficient because it allows the query optimizer to handle the set comparison more effectively than using multiple OR conditions. The use of JOIN or UNION could be an alternative approach, but IN with a subquery is generally more concise and easier to manage in many scenarios.

Q21

Multiple Choice

Which query correctly retrieves records from the 'employees' table where the 'department_id' is either 1, 2, or 3?

SQL Code

SELECT *
FROM employees
WHERE department_id IN (1, 2, 3);

SELECT * FROM employees WHERE department_id IN (1, 2, 3); SELECT * FROM employees WHERE department_id = 1 OR department_id = 2 OR department_id = 3; SELECT * FROM employees WHERE department_id = 1 AND department_id = 2 AND department_id = 3;SELECT * FROM employees WHERE department_id BETWEEN 1 AND 3;

The IN operator is used to specify multiple values for the 'department_id' column, returning rows where 'department_id' is either 1, 2, or 3.

Q22

Multiple Choice

Identify the correct SQL query that retrieves records from the 'products' table where 'category_id' is in the list (5, 10, 15).

SQL Code

SELECT *
FROM products
WHERE category_id IN (5, 10, 15);

SELECT * FROM products WHERE category_id IN (5, 10, 15); SELECT * FROM products WHERE category_id = 5 OR category_id = 10 OR category_id = 15; SELECT * FROM products WHERE category_id IN (5, 10);SELECT * FROM products WHERE category_id BETWEEN 5 AND 15;

The IN operator filters rows where the 'category_id' matches any of the values in the list (5, 10, 15).

Q23

Multiple Choice

Which query correctly selects records from the 'orders' table where the 'status' is either 'Pending', 'Shipped', or 'Delivered'?

SQL Code

SELECT *
FROM orders
WHERE status IN ('Pending', 'Shipped', 'Delivered');

SELECT * FROM orders WHERE status IN ('Pending', 'Shipped', 'Delivered'); SELECT * FROM orders WHERE status = 'Pending' OR status = 'Shipped' OR status = 'Delivered'; SELECT * FROM orders WHERE status = 'Pending' AND status = 'Shipped' AND status = 'Delivered';SELECT * FROM orders WHERE status LIKE 'Pending%' OR status LIKE 'Shipped%' OR status LIKE 'Delivered%';

The IN operator is used to filter rows where the 'status' column matches any of the specified values: 'Pending', 'Shipped', or 'Delivered'.

Q24

Multiple Choice

Determine the correct SQL query that retrieves records from the 'customers' table where 'country' is in ('USA', 'Canada', 'Mexico').

SQL Code

SELECT *
FROM customers
WHERE country IN ('USA', 'Canada', 'Mexico');

SELECT * FROM customers WHERE country IN ('USA', 'Canada', 'Mexico'); SELECT * FROM customers WHERE country = 'USA' OR country = 'Canada' OR country = 'Mexico'; SELECT * FROM customers WHERE country IN ('USA', 'Canada');SELECT * FROM customers WHERE country BETWEEN 'USA' AND 'Mexico';

The IN operator is used to filter rows where the 'country' column matches any of the specified values: 'USA', 'Canada', or 'Mexico'.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where 'item_id' is in the list (101, 102, 103)?

SQL Code

SELECT *
FROM inventory
WHERE item_id IN (101, 102, 103);

SELECT * FROM inventory WHERE item_id IN (101, 102, 103); SELECT * FROM inventory WHERE item_id = 101 OR item_id = 102 OR item_id = 103; SELECT * FROM inventory WHERE item_id IN (101, 102);SELECT * FROM inventory WHERE item_id BETWEEN 101 AND 103;

The IN operator is used to filter rows where the 'item_id' matches any of the values in the list (101, 102, 103).

Q26

Multiple Choice

Identify the correct query that retrieves records from the 'employees' table where 'job_title' is in ('Manager', 'Engineer', 'Analyst').

SQL Code

SELECT *
FROM employees
WHERE job_title IN ('Manager', 'Engineer', 'Analyst');

SELECT * FROM employees WHERE job_title IN ('Manager', 'Engineer', 'Analyst'); SELECT * FROM employees WHERE job_title = 'Manager' OR job_title = 'Engineer' OR job_title = 'Analyst'; SELECT * FROM employees WHERE job_title IN ('Manager', 'Engineer');SELECT * FROM employees WHERE job_title BETWEEN 'Manager' AND 'Analyst';

The IN operator is used to filter rows where the 'job_title' matches any of the specified values: 'Manager', 'Engineer', or 'Analyst'.

Q27

Multiple Choice

Which SQL query correctly retrieves records from the 'sales' table where 'region' is either 'North', 'South', or 'East'?

SQL Code

SELECT *
FROM sales
WHERE region IN ('North', 'South', 'East');

SELECT * FROM sales WHERE region IN ('North', 'South', 'East'); SELECT * FROM sales WHERE region = 'North' OR region = 'South' OR region = 'East'; SELECT * FROM sales WHERE region IN ('North', 'South');SELECT * FROM sales WHERE region BETWEEN 'North' AND 'East';

The IN operator is used to filter rows where the 'region' column matches any of the specified values: 'North', 'South', or 'East'.

Q28

Multiple Choice

Determine the correct SQL query that selects records from the 'projects' table where 'status_id' is in (2, 4, 6).

SQL Code

SELECT *
FROM projects
WHERE status_id IN (2, 4, 6);

SELECT * FROM projects WHERE status_id IN (2, 4, 6); SELECT * FROM projects WHERE status_id = 2 OR status_id = 4 OR status_id = 6; SELECT * FROM projects WHERE status_id IN (2, 4);SELECT * FROM projects WHERE status_id BETWEEN 2 AND 6;

The IN operator is used to filter rows where the 'status_id' matches any of the values in the list (2, 4, 6).

Q29

Multiple Choice

Which query correctly retrieves records from the 'users' table where 'role_id' is in (1, 3, 5)?

SQL Code

SELECT *
FROM users
WHERE role_id IN (1, 3, 5);

SELECT * FROM users WHERE role_id IN (1, 3, 5); SELECT * FROM users WHERE role_id = 1 OR role_id = 3 OR role_id = 5; SELECT * FROM users WHERE role_id IN (1, 3);SELECT * FROM users WHERE role_id BETWEEN 1 AND 5;

The IN operator is used to filter rows where the 'role_id' matches any of the values in the list (1, 3, 5).

Q30

Multiple Choice

Identify the correct SQL query that retrieves records from the 'transactions' table where 'payment_method' is in ('Credit Card', 'PayPal', 'Bank Transfer').

SQL Code

SELECT *
FROM transactions
WHERE payment_method IN ('Credit Card', 'PayPal', 'Bank Transfer');

SELECT * FROM transactions WHERE payment_method IN ('Credit Card', 'PayPal', 'Bank Transfer'); SELECT * FROM transactions WHERE payment_method = 'Credit Card' OR payment_method = 'PayPal' OR payment_method = 'Bank Transfer'; SELECT * FROM transactions WHERE payment_method IN ('Credit Card', 'PayPal');SELECT * FROM transactions WHERE payment_method BETWEEN 'Credit Card' AND 'Bank Transfer';

The IN operator is used to filter rows where the 'payment_method' matches any of the specified values: 'Credit Card', 'PayPal', or 'Bank Transfer'.

MySQL Database Quiz Questions