MySQL Filtering Quiz – Answertopia

Filtering data is a fundamental part of working with databases, and MySQL provides powerful logical operators to refine query results. This quiz will test your understanding of how to use AND, OR, IN, NOT, and subqueries within the WHERE clause to create precise and efficient queries.

Which SQL statement retrieves products that cost less than \$1000 or more than \$2000?

SELECT name FROM product WHERE price NOT BETWEEN 1000 AND 2000;

SELECT name FROM product WHERE price 2000;

SELECT name FROM product WHERE price BETWEEN 1000 AND 2000;

None

Which SQL statement retrieves all products that are either Apple desktops OR iPhones priced at $999.99?

SELECT name FROM product WHERE price = 999.99 AND (description = ‘Apple desktop’ OR description = ‘Apple iPhone’);

SELECT name FROM product WHERE (price = 999.99 AND description = ‘Apple desktop’) OR description = ‘Apple iPhone’;

SELECT name FROM product WHERE description = ‘Apple desktop’ OR (description = ‘Apple iPhone’ AND price = 999.99);

SELECT name FROM product WHERE price = 999.99 AND description = ‘Apple desktop’ OR description = ‘Apple iPhone’;

None

What happens when multiple logical operators (AND and OR) are used in the same query without parentheses?

OR operators are evaluated first, then AND operators

They are evaluated in the order they appear from left to right

MySQL randomly decides which operator to evaluate first

AND operators are evaluated first, then OR operators

None

Which logical operator ensures that all conditions in a WHERE clause must be true?

AND

NOT

None

Which SQL query retrieves products with prices \$799.99, \$999.99, or \$1999.99?

SELECT name FROM product WHERE price NOT IN (799.99, 999.99, 1999.99);

SELECT name FROM product WHERE price BETWEEN 799.99 AND 1999.99;

SELECT name FROM product WHERE price IN (799.99, 999.99, 1999.99);

SELECT name FROM product WHERE price = 799.99 OR price = 999.99 OR price = 1999.99;

None

Which SQL query retrieves products whose names are in another table's result set?

SELECT name FROM product WHERE name IN (SELECT name FROM availability WHERE discontinued = true);

SELECT name FROM product WHERE name = (SELECT name FROM availability WHERE discontinued = true);

SELECT name FROM product WHERE name = ALL (SELECT name FROM availability WHERE discontinued = true);

SELECT name FROM product WHERE name LIKE (SELECT name FROM availability WHERE discontinued = true);

None

What is the purpose of the OR operator in a MySQL WHERE clause?

To compare values numerically

To filter results based on multiple conditions, requiring at least one to be true

To exclude results from the query

To filter results based on multiple conditions, requiring all to be true

None

Which SQL statement deletes all discontinued products from the product table?

DELETE FROM product WHERE name = (SELECT name FROM availability WHERE discontinued = true);

DELETE FROM product WHERE EXISTS (SELECT name FROM availability WHERE discontinued = true);

DELETE FROM product WHERE name IN (SELECT name FROM availability WHERE discontinued = true);

DELETE FROM product WHERE name LIKE (SELECT name FROM availability WHERE discontinued = true);

None

Which operator reverses a condition in MySQL?

NOT

AND

None

10.

Which query retrieves all products that are not priced at \$799.99, \$999.99, or \$1999.99?

SELECT name FROM product WHERE price != (799.99, 999.99, 1999.99);

SELECT name FROM product WHERE NOT price IN (799.99, 999.99, 1999.99);

SELECT name FROM product WHERE price NOT IN (799.99, 999.99, 1999.99);

SELECT name FROM product WHERE price 799.99 OR price 999.99 OR price 1999.99;

None

11.

Which logical operator is used to filter results based on multiple predefined values?

AND

NOT

None

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