Test Your MySQL BETWEEN Operator Knowledge with Our SQL Quiz

Progress

True / False

The BETWEEN operator in MySQL is used to filter the result set within a certain range.

True False

The BETWEEN operator is used to select values within a given range. The values can be numbers, text, or dates

True / False

MySQL's BETWEEN operator includes the endpoints of the specified range.

True False

The BETWEEN operator in MySQL is inclusive, meaning it includes the start and end values specified in the range.

True / False

In MySQL, the BETWEEN operator can only be used with numerical data types.

True False

The BETWEEN operator in MySQL can be used with numbers, dates, and text data types.

True / False

The BETWEEN operator in MySQL can be used with the NOT keyword to exclude a range of values.

True False

Using NOT BETWEEN in MySQL will exclude the range specified, including the endpoint values.

True / False

The MySQL BETWEEN operator can be used with SQL aliases for column names.

True False

MySQL allows the use of aliases for column names in conjunction with the BETWEEN operator for better readability and usability in queries.

True / False

When using the BETWEEN operator in MySQL with dates, the format must be 'YYYY-MM-DD'.

True False

MySQL requires date values in the 'YYYY-MM-DD' format when using the BETWEEN operator for date comparisons.

True / False

In MySQL, the BETWEEN operator can be used in a WHERE clause but not in a HAVING clause.

True False

The BETWEEN operator can be used in both WHERE and HAVING clauses in MySQL.

True / False

MySQL's BETWEEN operator can compare values in different columns of the same table.

True False

The BETWEEN operator can compare values within the same row across different columns in MySQL.

True / False

In MySQL, using the BETWEEN operator with text values is case-sensitive.

True False

When using the BETWEEN operator with text values in MySQL, the comparison is case-sensitive unless the column collation is set to a case-insensitive collation.

Q10

True / False

The MySQL BETWEEN operator is optimized for performance, making it preferable for large data ranges over multiple OR conditions.

True False

The BETWEEN operator is generally optimized for performance in MySQL queries, especially when filtering large data ranges, as it is more efficient than using multiple OR conditions.

Q11

Single Choice

Which of the following MySQL queries correctly uses the BETWEEN operator to filter results within a specified range?

SQL Code

SELECT * FROM employees WHERE salary BETWEEN 30000 AND 50000;

SELECT * FROM employees WHERE salary IN (30000 AND 50000); SELECT * FROM employees WHERE salary BETWEEN 30000 TO 50000; SELECT * FROM employees WHERE salary BETWEEN 30000 AND 50000;SELECT * FROM employees WHERE salary >= 30000 AND <= 50000;

The correct syntax for using the BETWEEN operator is BETWEEN <lower_bound> AND <upper_bound>. Option C is correct, while the other options either have syntax errors or incorrect usage.

Q12

Single Choice

What does the BETWEEN operator return when the lower bound is greater than the upper bound?

An error No rows All rowsOnly the rows matching the exact bounds

The BETWEEN operator does not generate an error if the lower bound is greater than the upper bound; it simply returns no rows since no values can satisfy the condition.

Q13

Single Choice

In MySQL, what is the default behavior of the BETWEEN operator regarding inclusivity?

Excludes both bounds Includes both bounds Includes the lower bound, excludes the upper boundExcludes the lower bound, includes the upper bound

The BETWEEN operator includes both the lower and upper bounds in the range

Q14

Single Choice

Given the following MySQL query, how many rows will be returned?

SQL Code

SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

All rows from 2023 No rows All rows from January 1st and December 31st of 2023 onlyAn error due to date format

The query returns all rows where order_date falls between the beginning and end of the year 2023, inclusive of both dates.

Q15

Single Choice

Which of the following MySQL queries will correctly find products with prices between $10 and $20, inclusive?

SQL Code

SELECT product_name FROM products WHERE price BETWEEN 10 AND 20;

SELECT product_name FROM products WHERE price > 10 AND price < 20; SELECT product_name FROM products WHERE price BETWEEN 10 AND 20; SELECT product_name FROM products WHERE price >= 10 OR price <= 20;SELECT product_name FROM products WHERE price > 10 OR price < 20;

Option B correctly uses the BETWEEN operator to find products within the specified price range, inclusive of both $10 and $20.

Q16

Single Choice

What will be the result of the following MySQL query if the employee_id column has values ranging from 1 to 100?

SQL Code

SELECT * FROM employees WHERE employee_id BETWEEN 90 AND 110;

Rows with employee_id from 90 to 100 Rows with employee_id from 1 to 110 No rowsAll rows

Since the employee_id column values only range from 1 to 100, the query will return rows where employee_id is between 90 and 100. No error occurs, but no rows above 100 exist to be returned.

Q17

Single Choice

In the context of a MySQL query, how can the BETWEEN operator be used with non-numeric columns?

SQL Code

SELECT * FROM employees WHERE last_name BETWEEN 'A' AND 'M';

The query returns rows with last_name starting from 'A' to 'M', inclusive. The query returns rows with last_name starting from 'A' to 'L', inclusive. The query returns rows with last_name starting from 'A' to 'N', inclusive.The query does not support non-numeric columns with BETWEEN.

The BETWEEN operator can be used with string data types, and it will return all rows where the last_name falls alphabetically between 'A' and 'M', inclusive.

Q18

Single Choice

What is the effect of using NOT BETWEEN in a MySQL query?

SQL Code

SELECT * FROM sales WHERE quantity NOT BETWEEN 50 AND 100;

Returns rows where quantity is either less than 50 or greater than 100 Returns rows where quantity is between 50 and 100 Returns an error due to incorrect syntaxReturns all rows since NOT BETWEEN is not supported in MySQL

The NOT BETWEEN operator inverts the logic of BETWEEN, returning rows where quantity is either less than 50 or greater than 100.

Q19

Single Choice

What will be the result of the following MySQL query when applied to a table where the rating column contains NULL values?

SQL Code

SELECT * FROM movies WHERE rating BETWEEN 7 AND 9;

Rows with rating between 7 and 9, inclusive, but excludes NULL values Only NULL values Rows with rating between 7 and 9, including NULL valuesAll rows, regardless of rating value

The BETWEEN operator does not return rows where the column value is NULL; it only returns rows where the value is within the specified range.

Q20

Single Choice

Which MySQL query using the BETWEEN operator will correctly filter out products whose names are alphabetically between 'Car' and 'Hat', assuming there are no product names with those exact values?

SQL Code

SELECT product_name FROM products WHERE product_name BETWEEN 'Car' AND 'Hat';

SELECT product_name FROM products WHERE product_name BETWEEN 'Car' AND 'Hat' OR product_name = 'Car' OR product_name = 'Hat'; SELECT product_name FROM products WHERE product_name > 'Car' AND product_name < 'Hat SELECT product_name FROM products WHERE product_name BETWEEN 'Car' AND 'Hat';SELECT product_name FROM products WHERE product_name LIKE 'C%' AND product_name <= 'Hat';

The query in Option C correctly uses the BETWEEN operator to filter product names alphabetically between 'Car' and 'Hat'. The operator includes all names that fall within this range, regardless of whether 'Car' or 'Hat' are actually present.

Q21

Multiple Choice

Which query correctly retrieves records from the 'employees' table where the 'age' is between 25 and 35?

SQL Code

SELECT *
FROM employees
WHERE age BETWEEN 25 AND 35;

SELECT * FROM employees WHERE age BETWEEN 25 AND 35; SELECT * FROM employees WHERE age >= 25 AND age <= 35; SELECT * FROM employees WHERE age > 25 AND age < 35;SELECT * FROM employees WHERE age BETWEEN 26 AND 34;

The correct query uses the BETWEEN operator to filter records where the 'age' is within the range of 25 and 35, inclusive.

Q22

Multiple Choice

Identify the correct SQL query that selects records from the 'orders' table where 'order_date' is between '2023-01-01' and '2023-12-31'.

SQL Code

SELECT *
FROM orders
WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31'; SELECT * FROM orders WHERE order_date >= '2023-01-01' AND order_date <= '2023-12-31'; SELECT * FROM orders WHERE order_date > '2023-01-01' AND order_date < '2023-12-31';SELECT * FROM orders WHERE order_date BETWEEN '2023-01-02' AND '2023-12-30';

The correct query uses the BETWEEN operator to filter records where 'order_date' is within the range from '2023-01-01' to '2023-12-31'.

Q23

Multiple Choice

Determine the correct SQL query to retrieve records from the 'products' table where the 'price' is between 50 and 100.

SQL Code

SELECT *
FROM products
WHERE price BETWEEN 50 AND 100;

SELECT * FROM products WHERE price BETWEEN 50 AND 100; SELECT * FROM products WHERE price >= 50 AND price <= 100; SELECT * FROM products WHERE price > 50 AND price < 100;SELECT * FROM products WHERE price BETWEEN 51 AND 99;

The BETWEEN operator is used here to select records where the 'price' is within the range of 50 and 100, inclusive.

Q24

Multiple Choice

Which SQL query retrieves records from the 'customers' table where 'credit_limit' is between 1000 and 5000?

SQL Code

SELECT *
FROM customers
WHERE credit_limit BETWEEN 1000 AND 5000;

SELECT * FROM customers WHERE credit_limit BETWEEN 1000 AND 5000; SELECT * FROM customers WHERE credit_limit >= 1000 AND credit_limit <= 5000; SELECT * FROM customers WHERE credit_limit > 1000 AND credit_limit < 5000;SELECT * FROM customers WHERE credit_limit BETWEEN 1500 AND 4500;

The BETWEEN operator filters records where the 'credit_limit' falls within the specified range of 1000 to 5000.

Q25

Multiple Choice

Identify the correct query that selects records from the 'inventory' table where the 'quantity' is between 10 and 100.

SQL Code

SELECT *
FROM inventory
WHERE quantity BETWEEN 10 AND 100;

SELECT * FROM inventory WHERE quantity BETWEEN 10 AND 100; SELECT * FROM inventory WHERE quantity >= 10 AND quantity <= 100; SELECT * FROM inventory WHERE quantity > 10 AND quantity < 100;SELECT * FROM inventory WHERE quantity BETWEEN 11 AND 99;

The correct query uses the BETWEEN operator to filter records where 'quantity' is within the range of 10 and 100.

Q26

Multiple Choice

Which SQL query correctly selects records from the 'sales' table where 'total_amount' is between 500 and 1000?

SQL Code

SELECT *
FROM sales
WHERE total_amount BETWEEN 500 AND 1000;

SELECT * FROM sales WHERE total_amount BETWEEN 500 AND 1000; SELECT * FROM sales WHERE total_amount >= 500 AND total_amount <= 1000; SELECT * FROM sales WHERE total_amount > 500 AND total_amount < 1000;SELECT * FROM sales WHERE total_amount BETWEEN 501 AND 999;

The BETWEEN operator is used to select records where 'total_amount' is between 500 and 1000, inclusive.

Q27

Multiple Choice

Determine the correct query to retrieve records from the 'transactions' table where the 'transaction_date' is between '2024-01-01' and '2024-06-30'.

SQL Code

SELECT *
FROM transactions
WHERE transaction_date BETWEEN '2024-01-01' AND '2024-06-30';

SELECT * FROM transactions WHERE transaction_date BETWEEN '2024-01-01' AND '2024-06-30'; SELECT * FROM transactions WHERE transaction_date >= '2024-01-01' AND transaction_date <= '2024-06-30'; SELECT * FROM transactions WHERE transaction_date > '2024-01-01' AND transaction_date < '2024-06-30';SELECT * FROM transactions WHERE transaction_date BETWEEN '2024-01-02' AND '2024-06-29';

The BETWEEN operator is used here to select records where the 'transaction_date' falls within the range of '2024-01-01' to '2024-06-30'.

Q28

Multiple Choice

Which SQL query retrieves records from the 'employees' table where 'hire_date' is between '2020-01-01' and '2020-12-31'?

SQL Code

SELECT *
FROM employees
WHERE hire_date BETWEEN '2020-01-01' AND '2020-12-31';

SELECT * FROM employees WHERE hire_date BETWEEN '2020-01-01' AND '2020-12-31'; SELECT * FROM employees WHERE hire_date >= '2020-01-01' AND hire_date <= '2020-12-31'; SELECT * FROM employees WHERE hire_date > '2020-01-01' AND hire_date < '2020-12-31';SELECT * FROM employees WHERE hire_date BETWEEN '2020-01-02' AND '2020-12-30';

The BETWEEN operator is used to filter records where 'hire_date' is within the specified range of '2020-01-01' and '2020-12-31'.

Q29

Multiple Choice

Which query correctly retrieves records from the 'inventory' table where the 'restock_date' is between '2024-07-01' and '2024-12-31'?

SQL Code

SELECT *
FROM inventory
WHERE restock_date BETWEEN '2024-07-01' AND '2024-12-31';

SELECT * FROM inventory WHERE restock_date BETWEEN '2024-07-01' AND '2024-12-31'; SELECT * FROM inventory WHERE restock_date >= '2024-07-01' AND restock_date <= '2024-12-31'; SELECT * FROM inventory WHERE restock_date > '2024-07-01' AND restock_date < '2024-12-31';SELECT * FROM inventory WHERE restock_date BETWEEN '2024-07-02' AND '2024-12-30';

The correct query uses the BETWEEN operator to filter records where 'restock_date' falls between '2024-07-01' and '2024-12-31', inclusive.

Q30

Multiple Choice

Identify the correct SQL query that retrieves records from the 'projects' table where 'budget' is between 50000 and 200000.

SQL Code

SELECT *
FROM projects
WHERE budget BETWEEN 50000 AND 200000;

SELECT * FROM projects WHERE budget BETWEEN 50000 AND 200000; SELECT * FROM projects WHERE budget >= 50000 AND budget <= 200000; SELECT * FROM projects WHERE budget > 50000 AND budget < 200000;SELECT * FROM projects WHERE budget BETWEEN 60000 AND 190000;

The BETWEEN operator is used here to filter records where the 'budget' falls within the specified range of 50000 and 200000.

MySQL Database Quiz Questions