Test Your MySQL Comparison Operators Knowledge with This Quiz

Progress

True / False

In MySQL, the equality comparison operator is represented by ==.

True False

In MySQL, the equality comparison operator is represented by =.

True / False

In MySQL, the operator <> can be used to check for inequality.

True False

In MySQL, <> and != both are used to check for inequality.

True / False

In MySQL, the < operator checks if the value on the left is greater than the value on the right.

True False

The < operator checks if the value on the left is less than the value on the right.

True / False

In MySQL, the comparison operators >= and <= can be used to check for greater than or equal to and less than or equal to, respectively.

True False

In MySQL, >= checks for greater than or equal to, and <= checks for less than or equal to.

True / False

MySQL does not allow the use of comparison operators in the WHERE clause.

True False

MySQL allows the use of comparison operators in the WHERE clause to filter records based on conditions.

True / False

The BETWEEN operator in MySQL is used to compare a value against a range of values inclusive of the boundaries.

True False

The BETWEEN operator in MySQL includes both the start and end values in the comparison range.

True / False

MySQL's comparison operators can only be used with numeric data types.

True False

MySQL's comparison operators can be used with numeric, string, and date data types.

True / False

In MySQL, the IN operator can be used to check if a value matches any value in a list of values.

True False

The IN operator is used to compare a value against a list of values in MySQL.

True / False

In MySQL, the LIKE operator is used for exact match comparisons.

True False

The LIKE operator is used for pattern matching in MySQL, not for exact matches.

Q10

True / False

In MySQL, the = operator can be used to compare two NULL values and return TRUE if they are both NULL.

True False

In MySQL, comparing NULL values using = does not return TRUE. Instead, NULL values are compared using the IS NULL operator.

Q11

Single Choice

Which MySQL comparison operator checks if two values are not equal?

> < !=<=

The != operator is used in MySQL to check if two values are not equal.

Q12

Single Choice

What is the output of the following MySQL query?

SQL Code

SELECT * FROM employees WHERE salary > 50000;

Employees with salary equal to 50000 Employees with salary greater than 50000 Employees with salary less than 50000Employees with salary less than or equal to 50000

The > operator is used to filter records where the salary is greater than 50000.

Q13

Single Choice

Which operator would you use to check if a value is between two values in MySQL?

BETWEEN IN NOT LIKEIS NULL

The BETWEEN operator is used to filter records within a specified range in MySQL.

Q14

Single Choice

What is the result of this MySQL query?

SQL Code

SELECT * FROM products WHERE price >= 100 AND price <= 500;

Products with price less than 100 Products with price greater than 500 Products with price between 100 and 500 (inclusive)Products with price equal to 100

The >= and <= operators are used together to filter records within a specified range, inclusive of the boundary values

Q15

Single Choice

Which MySQL comparison operator would you use to find records where a column is not null?

IS NOT NULL NOT NULL IN NULL<>

The IS NOT NULL operator is used to filter records where the column value is not null

Q16

Single Choice

How would you write a query to find records where a column value is exactly equal to 10 in MySQL?

SQL Code

SELECT * FROM orders WHERE quantity = 10;

quantity = 10 quantity > 10 quantity != 10quantity < 10

The = operator is used to match records where the column value is exactly equal to 10.

Q17

Single Choice

Consider the following MySQL query. What does it retrieve?

SQL Code

SELECT * FROM employees WHERE (age < 30 OR age > 50) AND status = 'active';

Employees with age between 30 and 50, and status 'active' Employees with age less than 30 or greater than 50, and status 'active' Employees with age between 30 and 50, and status 'inactive'Employees with age less than 30 or greater than 50, and status 'inactive'

The query uses OR to filter employees whose age is either less than 30 or greater than 50, and AND to ensure the status is 'active'.

Q18

Single Choice

Which query correctly uses MySQL comparison operators to find records where a column value is not between two specified values?

SQL Code

SELECT * FROM sales WHERE amount NOT BETWEEN 100 AND 500;

Records where amount is between 100 and 500 Records where amount is not between 100 and 500 Records where amount is greater than 500Records where amount is less than 100

The NOT BETWEEN operator is used to find records where the value does not fall within the specified range.

Q19

Single Choice

Which of the following SQL statements uses a MySQL comparison operator to find records with a column value either greater than 100 or less than 10?

SQL Code

SELECT * FROM inventory WHERE quantity > 100 OR quantity < 10;

quantity = 100 quantity BETWEEN 10 AND 100 quantity BETWEEN 10 AND 100quantity >= 10 AND quantity <= 100

The query uses OR with comparison operators to filter records where the quantity is either greater than 100 or less than 10.

Q20

Single Choice

Given the following MySQL query, what does it return?

SQL Code

SELECT * FROM students WHERE grade >= 90 AND grade <= 100 OR grade < 60;

Students with grades between 90 and 100 or below 60 Students with grades between 60 and 90 Students with grades exactly 90 or below 60Students with grades greater than 100 or less than 60

The query combines AND and OR operators. It filters students whose grades are either between 90 and 100 or below 60.

Q21

Multiple Choice

Which SQL query correctly uses the '=' operator to find all employees with a specific department ID?

SQL Code

SELECT name, department_id
FROM employees
WHERE department_id = 5;

SELECT name, department_id FROM employees WHERE department_id = 5; SELECT name, department_id FROM employees WHERE department_id == 5; SELECT name, department_id FROM employees WHERE department_id <> 5;SELECT name, department_id FROM employees WHERE department_id IS 5;

The '=' operator is used to find all employees who belong to the department with ID 5.

Q22

Multiple Choice

Identify the SQL query that uses the '<>' operator to exclude a specific salary from the results.

SQL Code

SELECT name, salary
FROM employees
WHERE salary <> 50000;

SELECT name, salary FROM employees WHERE salary <> 50000; SELECT name, salary FROM employees WHERE salary != 50000; SELECT name, salary FROM employees WHERE salary < 50000;SELECT name, salary FROM employees WHERE salary =! 50000;

The '<>' operator is used to exclude rows where the salary is equal to 50,000, returning all other salary values.

Q23

Multiple Choice

Which SQL query uses the '>' operator to find all products with a price greater than 100?

SQL Code

SELECT product_name, price
FROM products
WHERE price > 100;

SELECT product_name, price FROM products WHERE price > 100; SELECT product_name, price FROM products WHERE price >= 100; SELECT product_name, price FROM products WHERE price < 100;SELECT product_name, price FROM products WHERE price > 100.00;

The '>' operator is used to find all products that have a price greater than 100.

Q24

Multiple Choice

Determine the SQL query that uses the '<=' operator to include products with a price less than or equal to 50.

SQL Code

SELECT product_name, price
FROM products
WHERE price <= 50;

SELECT product_name, price FROM products WHERE price <= 50; SELECT product_name, price FROM products WHERE price < 50; SELECT product_name, price FROM products WHERE price <= 50.00;SELECT product_name, price FROM products WHERE price =< 50;

The '<=' operator is used to find all products with a price that is less than or equal to 50.

Q25

Multiple Choice

Which SQL query correctly uses the '!=' operator to filter out employees from a specific department?

SQL Code

SELECT name, department_id
FROM employees
WHERE department_id != 3;

SELECT name, department_id FROM employees WHERE department_id != 3; SELECT name, department_id FROM employees WHERE department_id <> 3; SELECT name, department_id FROM employees WHERE department_id = 3;SELECT name, department_id FROM employees WHERE department_id NOT 3;

The '!=' operator is used to exclude all employees who belong to the department with ID 3.

Q26

Multiple Choice

Which SQL query uses the '=' operator to find orders with a specific order status?

SQL Code

SELECT order_id, status
FROM orders
WHERE status = 'Shipped';

SELECT order_id, status FROM orders WHERE status = 'Shipped'; SELECT order_id, status FROM orders WHERE status LIKE 'Shipped'; SELECT order_id, status FROM orders WHERE status <> 'Shipped';SELECT order_id, status FROM orders WHERE status != 'Shipped';

The '=' operator is used to select orders with a status of 'Shipped'.

Q27

Multiple Choice

Identify the SQL query that uses the '>' operator to find customers with an account balance greater than zero.

SQL Code

SELECT customer_name, account_balance
FROM customers
WHERE account_balance > 0;

SELECT customer_name, account_balance FROM customers WHERE account_balance > 0; SELECT customer_name, account_balance FROM customers WHERE account_balance >= 0; SELECT customer_name, account_balance FROM customers WHERE account_balance < 0;SELECT customer_name, account_balance FROM customers WHERE account_balance <> 0;

The '>' operator is used to select all customers who have a positive account balance, greater than zero.

Q28

Multiple Choice

Which SQL query uses the '<' operator to find products with a quantity in stock less than a specified value?

SQL Code

SELECT product_name, quantity_in_stock
FROM inventory
WHERE quantity_in_stock < 10;

SELECT product_name, quantity_in_stock FROM inventory WHERE quantity_in_stock < 10; SELECT product_name, quantity_in_stock FROM inventory WHERE quantity_in_stock <= 10; SELECT product_name, quantity_in_stock FROM inventory WHERE quantity_in_stock > 10;SELECT product_name, quantity_in_stock FROM inventory WHERE quantity_in_stock != 10;

The '<' operator is used to find all products where the quantity in stock is less than 10.

Q29

Multiple Choice

Determine the SQL query that uses the '<>' operator to find records where two columns do not have the same value.

SQL Code

SELECT order_id, product_id
FROM order_details
WHERE product_id <> special_offer_id;

SELECT order_id, product_id FROM order_details WHERE product_id <> special_offer_id; SELECT order_id, product_id FROM order_details WHERE product_id != special_offer_id; SELECT order_id, product_id FROM order_details WHERE product_id = special_offer_id;SELECT order_id, product_id FROM order_details WHERE product_id =! special_offer_id;

The '<>' operator is used to find all records where 'product_id' and 'special_offer_id' are not equal.

Q30

Multiple Choice

Which SQL query uses comparison operators to filter products within a specific price range?

SQL Code

SELECT product_name, price
FROM products
WHERE price >= 50 AND price <= 100;

SELECT product_name, price FROM products WHERE price >= 50 AND price <= 100; SELECT product_name, price FROM products WHERE price > 50 AND price < 100; SELECT product_name, price FROM products WHERE price BETWEEN 50 AND 100;SELECT product_name, price FROM products WHERE price > 50 OR price < 100;

The '>=' and '<=' operators are used to filter products within the price range of 50 to 100 inclusive.

MySQL Database Quiz Questions