Test Your MySQL Logical Operators Knowledge with This Quiz

Progress

True / False

In MySQL, the logical operator AND returns true if both operands are true.

True False

The AND operator returns true only if both conditions are true.

True / False

The OR logical operator in MySQL will return true if at least one of the operands is true.

True False

The OR operator returns true if at least one of the conditions is true.

True / False

In MySQL, the NOT logical operator negates the value of the condition it precedes.

True False

The NOT operator inverts the Boolean value of the condition it precedes.

True / False

MySQL's logical operators AND and OR have the same precedence level.

True False

In MySQL, the AND operator has a higher precedence than the OR operator.

True / False

In MySQL, the expression NULL AND TRUE will return NULL.

True False

When using logical operators with NULL in MySQL, any expression involving NULL returns NULL.

True / False

The XOR operator in MySQL is used to return true if both operands are either true or both are false.

True False

The XOR operator returns true if exactly one of the operands is true and the other is false.

True / False

In MySQL, the logical operator AND can be short-circuited.

True False

In MySQL, AND short-circuits; if the first operand is false, the second operand is not evaluated.

True / False

The precedence of logical operators in MySQL is NOT, AND, then OR.

True False

The logical operators in MySQL have the precedence order: NOT > AND > OR.

True / False

In MySQL, combining AND and OR in a single query without parentheses will always produce predictable results.

True False

Without parentheses to explicitly define precedence, combining AND and OR can lead to ambiguous results.

Q10

True / False

In MySQL, using logical operators with subqueries in the WHERE clause can improve query performance.

True False

Using logical operators with subqueries can sometimes slow down performance due to the complexity of subquery evaluation. It is often better to use joins when possible.

Q11

Single Choice

What will the following SQL query return?

SQL Code

SELECT * FROM employees WHERE status = 'active' AND department = 'Sales';

Employees who are inactive and in the Sales department Employees who are active and in the Sales department Employees who are active or in the Sales departmentAll employees in the Sales department

The AND operator returns rows where both conditions are true.

Q12

Single Choice

Which logical operator would you use to combine conditions where at least one must be true?

AND OR AND ORNULL

The OR operator returns true if at least one of the conditions is true.

Q13

Single Choice

How would you exclude records where the status is 'inactive'?

SQL Code

SELECT * FROM orders WHERE status <> 'inactive';

status = 'inactive status != 'inactive' status IS NOT 'inactivestatus IS NULL

The <> operator or != can be used to exclude rows where the status is 'inactive'.

Q14

Single Choice

What will this SQL query return?

SQL Code

SELECT * FROM products WHERE price > 100 AND (category = 'Electronics' OR category = 'Appliances');

Products with a price greater than 100 in any category Products with a price greater than 100 in either Electronics or Appliances category Products with a price less than 100 in Electronics or Appliances categoryAll products in Electronics or Appliances category

The AND operator combines with OR to specify that the price must be greater than 100 and the category must be either Electronics or Appliances.

Q15

Single Choice

Which SQL statement will select records where status is not 'completed' or priority is 'high'?

SQL Code

SELECT * FROM tasks WHERE NOT (status = 'completed' AND priority = 'high');

status = 'completed' OR priority = 'high' status != 'completed' OR priority = 'high' NOT status = 'completed' AND NOT priority = 'high'status = 'completed' AND priority != 'high'

The NOT operator negates the result of the combined condition within parentheses, which results in selecting records where either condition is true.

Q16

Single Choice

What will be the result of the following SQL query?

SQL Code

SELECT * FROM orders WHERE amount > 50 AND amount < 150 AND (status = 'shipped' OR status = 'pending');

Orders with amount between 50 and 150, and status either 'shipped' or 'pending' Orders with amount less than 50 and status either 'shipped' or 'pending' Orders with amount greater than 150 and status 'shipped' or 'pending'Orders with amount between 50 and 150, and status not 'shipped' or 'pending'

The query uses AND to combine the amount range condition and OR to filter by status

Q17

Single Choice

How would you use a logical operator to find employees who are either 'Manager' or have a salary greater than 70000, but exclude those who are 'Intern'?

SQL Code

SELECT * FROM employees WHERE (position = 'Manager' OR salary > 70000) AND position != 'Intern';

position = 'Manager' AND salary > 70000 AND position != 'Intern' position = 'Manager' OR salary > 70000) AND position = 'Intern' position = 'Manager' OR salary > 70000) AND NOT position = 'Internposition = 'Manager' OR (salary > 70000 AND position != 'Intern')

The query selects employees who are either Managers or have a salary greater than 70000, excluding those who are Interns.

Q18

Single Choice

What does this query do?

SQL Code

SELECT * FROM employees WHERE NOT (department = 'HR' AND status = 'inactive');

Selects employees who are in HR or inactive Selects employees who are not in HR or not inactive Selects employees who are neither in HR nor inactiveSelects employees who are either in HR or active

The NOT operator negates the condition, selecting records where at least one of the conditions is false.

Q19

Single Choice

Determine the correct SQL query to select orders where the order is either 'urgent' or from the 'priority' category, but exclude orders where the customer is 'anonymous':

SQL Code

SELECT * FROM orders WHERE (order_type = 'urgent' OR category = 'priority') AND customer != 'anonymous';

order_type = 'urgent' OR category = 'priority' AND customer = 'anonymous' (order_type = 'urgent' OR category = 'priority') AND customer != 'anonymous' (order_type = 'urgent' AND category = 'priority') OR customer != 'anonymous'order_type != 'urgent' AND category != 'priority' AND customer != 'anonymous'

The query filters orders that are either urgent or in the priority category, excluding those where the customer is anonymous

Q20

Single Choice

What does the following SQL query achieve?

SQL Code

SELECT * FROM products WHERE NOT (price < 50 AND (stock > 100 OR supplier = 'ABC Corp'));

Selects products where the price is at least 50 and stock is not greater than 100, or supplier is not 'ABC Corp' Selects products where the price is below 50 and the stock is greater than 100 or supplier is 'ABC Corp' Selects products where the price is at least 50 and either stock is less than or equal to 100 or supplier is not 'ABC Corp'Selects products where the price is at least 50 and stock is not greater than 100 or supplier is 'ABC Corp'

The NOT operator negates the result of the condition inside the parentheses, which includes the combined conditions for price, stock, and supplier.

Q21

Multiple Choice

Which SQL query uses the AND operator to filter employees who work in department 5 and have a salary greater than 50,000?

SQL Code

SELECT name, department_id, salary
FROM employees
WHERE department_id = 5 AND salary > 50000;

SELECT name, department_id, salary FROM employees WHERE department_id = 5 AND salary > 50000; SELECT name, department_id, salary FROM employees WHERE department_id = 5 OR salary > 50000; SELECT name, department_id, salary FROM employees WHERE department_id = 5 AND salary < 50000;SELECT name, department_id, salary FROM employees WHERE department_id = 5 AND salary = 50000;

The AND operator is used to filter rows where both conditions (department_id = 5 and salary > 50,000) must be true.

Q22

Multiple Choice

Identify the SQL query that uses the OR operator to find products that are either out of stock or priced above 100.

SQL Code

SELECT product_name, price, stock
FROM products
WHERE stock = 0 OR price > 100;

SELECT product_name, price, stock FROM products WHERE stock = 0 OR price > 100; SELECT product_name, price, stock FROM products WHERE stock > 0 OR price > 100; SELECT product_name, price, stock FROM products WHERE stock = 0 AND price > 100;SELECT product_name, price, stock FROM products WHERE stock = 0 OR price = 100;

The OR operator is used to filter rows where at least one of the conditions (stock = 0 or price > 100) must be true.

Q23

Multiple Choice

Which SQL query demonstrates the use of the NOT operator to exclude employees with a specific job title?

SQL Code

SELECT name, job_title
FROM employees
WHERE NOT job_title = 'Manager';

SELECT name, job_title FROM employees WHERE NOT job_title = 'Manager'; SELECT name, job_title FROM employees WHERE job_title = 'Manager'; SELECT name, job_title FROM employees WHERE job_title <> 'Manager';SELECT name, job_title FROM employees WHERE job_title != 'Manager';

The NOT operator negates the condition, excluding rows where the job title is 'Manager'.

Q24

Multiple Choice

Determine the SQL query that uses the AND and OR operators together to filter products that are in stock and either priced above 100 or belong to category 3.

SQL Code

SELECT product_name, price, stock
FROM products
WHERE stock > 0 AND (price > 100 OR category_id = 3);

SELECT product_name, price, stock FROM products WHERE stock > 0 AND (price > 100 OR category_id = 3); SELECT product_name, price, stock FROM products WHERE stock = 0 AND (price > 100 OR category_id = 3); SELECT product_name, price, stock FROM products WHERE stock > 0 OR (price > 100 AND category_id = 3);SELECT product_name, price, stock FROM products WHERE stock > 0 AND price > 100 AND category_id = 3;

The query combines AND and OR operators, where the AND condition ensures that products are in stock, and the OR condition allows either price or category condition to be true.

Q25

Multiple Choice

Which SQL query correctly uses the combination of AND and NOT operators to exclude employees with a salary below 50,000 and department 5?

SQL Code

SELECT name, department_id, salary
FROM employees
WHERE NOT (salary < 50000 AND department_id = 5);

SELECT name, department_id, salary FROM employees WHERE NOT (salary < 50000 AND department_id = 5); SELECT name, department_id, salary FROM employees WHERE salary >= 50000 OR department_id != 5; SELECT name, department_id, salary FROM employees WHERE salary < 50000 OR department_id = 5;SELECT name, department_id, salary FROM employees WHERE salary < 50000 AND department_id != 5;

The NOT operator negates the AND condition, excluding employees who meet both criteria (salary < 50,000 and department_id = 5).

Q26

Multiple Choice

Which SQL query uses the AND operator to select orders placed by customers from New York and with an order amount greater than 500?

SQL Code

SELECT order_id, customer_id, order_amount
FROM orders
WHERE customer_city = 'New York' AND order_amount > 500;

SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city = 'New York' AND order_amount > 500; SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city = 'New York' OR order_amount > 500; SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city = 'New York' AND order_amount < 500;SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city != 'New York' AND order_amount > 500;

The AND operator is used to filter rows where both conditions (customer_city = 'New York' and order_amount > 500) must be true.

Q27

Multiple Choice

Identify the SQL query that uses the OR and NOT operators to find customers not from California or with an account balance above 1,000.

SQL Code

SELECT customer_name, state, account_balance
FROM customers
WHERE state != 'California' OR account_balance > 1000;

SELECT customer_name, state, account_balance FROM customers WHERE state != 'California' OR account_balance > 1000; SELECT customer_name, state, account_balance FROM customers WHERE state != 'California' AND account_balance > 1000; SELECT customer_name, state, account_balance FROM customers WHERE state = 'California' OR account_balance > 1000;SELECT customer_name, state, account_balance FROM customers WHERE state != 'California' AND account_balance < 1000;

The OR operator is used to select rows where either condition (state not equal to California or account balance > 1000) is true.

Q28

Multiple Choice

Which SQL query demonstrates the correct use of AND, OR, and NOT operators together to filter a complex condition?

SQL Code

SELECT product_name, price, stock
FROM products
WHERE NOT (price < 50 OR stock = 0) AND category_id = 2;

SELECT product_name, price, stock FROM products WHERE NOT (price < 50 OR stock = 0) AND category_id = 2; SELECT product_name, price, stock FROM products WHERE price >= 50 AND stock != 0 AND category_id = 2; SELECT product_name, price, stock FROM products WHERE NOT (price > 50 AND stock = 0) AND category_id = 2;SELECT product_name, price, stock FROM products WHERE NOT (price < 50 OR stock = 0) OR category_id = 2;

The query correctly combines AND, OR, and NOT operators to filter rows where the price is not less than 50 or stock is not zero, and the category_id is 2.

Q29

Multiple Choice

Which SQL query correctly uses the combination of AND, OR, and NOT operators to exclude certain employees based on department and salary?

SQL Code

SELECT name, department_id, salary
FROM employees
WHERE department_id != 2 AND (salary > 60000 OR NOT department_id = 4);

SELECT name, department_id, salary FROM employees WHERE department_id != 2 AND (salary > 60000 OR NOT department_id = 4); SELECT name, department_id, salary FROM employees WHERE department_id = 2 OR (salary > 60000 AND department_id = 4); SELECT name, department_id, salary FROM employees WHERE department_id != 2 AND salary > 60000 AND department_id != 4;SELECT name, department_id, salary FROM employees WHERE department_id != 2 OR (salary > 60000 AND department_id != 4);

The query excludes employees from department 2 and includes those with a salary > 60,000 or those not in department 4.

Q30

Multiple Choice

Which SQL query uses logical operators to find all orders placed by customers from either New York or California with an order amount greater than 500?

SQL Code

SELECT order_id, customer_id, order_amount
FROM orders
WHERE (customer_city = 'New York' OR customer_city = 'California') AND order_amount > 500;

SELECT order_id, customer_id, order_amount FROM orders WHERE (customer_city = 'New York' OR customer_city = 'California') AND order_amount > 500; SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city = 'New York' AND customer_city = 'California' AND order_amount > 500; SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city = 'New York' OR customer_city = 'California' AND order_amount > 500;SELECT order_id, customer_id, order_amount FROM orders WHERE customer_city = 'New York' OR customer_city = 'California' OR order_amount > 500;

The query combines OR and AND operators to filter orders where the customer is from either New York or California, and the order amount is greater than 500.

MySQL Database Quiz Questions