Test Your MySQL AND and OR Operators Knowledge with Our SQL Quiz

Progress

True / False

In MySQL, the 'AND' operator is used to combine multiple conditions and returns true only if all conditions are true.

True False

The 'AND' operator requires all combined conditions to be true for the overall expression to be true.

True / False

The 'OR' operator in MySQL returns true if at least one of the combined conditions is true.

True False

The 'OR' operator returns true if any of the combined conditions are true.

True / False

In MySQL, the expression 1 AND 0 evaluates to true.

True False

The expression 1 AND 0 evaluates to false because both conditions must be true for the 'AND' operator to return true.

True / False

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

True False

The 'AND' operator has higher precedence, meaning it is evaluated before the 'OR' operator unless parentheses are used to explicitly define the order.

True / False

The query SELECT * FROM employees WHERE age > 30 AND age < 50 OR salary > 50000; will return employees who are either aged between 30 and 50 or have a salary greater than 50000.

True False

Due to operator precedence, age > 30 AND age < 50 is evaluated first, and then OR salary > 50000 is evaluated.

True / False

The query SELECT * FROM products WHERE price < 100 AND category = 'Electronics' OR stock > 50; will return all electronics priced under 100, as well as any product with stock greater than 50.

True False

The 'AND' condition is evaluated first, and then 'OR stock > 50' includes additional products with stock greater than 50.

True / False

In MySQL, you can use both 'AND' and 'OR' operators within the same WHERE clause to create complex conditions.

True False

MySQL allows the combination of 'AND' and 'OR' operators in the same WHERE clause to form complex conditional statements.

True / False

The expression (condition1 OR condition2) AND condition3 is equivalent to condition1 OR (condition2 AND condition3) in MySQL.

True False

The expressions are not equivalent due to the different order of evaluation influenced by parentheses and operator precedence

True / False

The query SELECT * FROM orders WHERE (customer_id = 1 OR customer_id = 2) AND (status = 'shipped' OR status = 'pending'); will return orders for customers 1 or 2 that are either shipped or pending.

True False

The use of parentheses groups conditions correctly, ensuring that the query returns the intended results.

Q10

True / False

In MySQL, using 'AND' and 'OR' operators within a single query can impact query performance, especially when dealing with large datasets.

True False

Combining 'AND' and 'OR' operators in queries can affect performance due to the complexity of evaluating multiple conditions, especially in large datasets. Proper indexing and query optimization techniques are necessary to mitigate performance issues.

Q11

Single Choice

What will be the result of the following MySQL query?

SQL Code

SELECT * FROM employees WHERE department = 'HR' AND salary > 50000;

Selects employees in any department with a salary greater than 50000. Selects employees in the HR department with a salary greater than 50000. Selects all employees with a salary greater than 50000.The query will throw an error.

The AND operator ensures that both conditions (department is 'HR' and salary is greater than 50000) must be true for a record to be selected.

Q12

Single Choice

What does the following SQL statement return?

SQL Code

SELECT name FROM students WHERE age < 18 OR grade = 'A';

Students who are either under 18 or have an 'A' grade. Students who are under 18 and have an 'A' grade. Only students who are under 18.Only students who have an 'A' grade.

The OR operator returns true if either of the conditions is true, so students who are either under 18 or have an 'A' grade will be selected.

Q13

Single Choice

In the following query, which rows will be selected?

SQL Code

SELECT * FROM orders WHERE order_date > '2024-01-01' AND customer_id = 1001;

All orders placed after '2024-01-01' by customer 1001. All orders placed after '2024-01-01'. All orders by customer 1001None of the above

The AND operator requires both conditions (order_date > '2024-01-01' and customer_id = 1001) to be true for the rows to be selected.

Q14

Single Choice

What does the following MySQL query return?

SQL Code

SELECT product_name FROM products WHERE stock < 50 AND (price > 100 OR category = 'Electronics');

Products with stock less than 50 and price greater than 100. Products with stock less than 50 and in the 'Electronics' category. Products with stock less than 50 and either price greater than 100 or category is 'Electronics'.Products with stock less than 50, price greater than 100, and in the 'Electronics' category.

The AND operator combines with the OR within parentheses, so products with stock less than 50 and either price > 100 or belonging to the 'Electronics' category are selected.

Q15

Single Choice

Evaluate the following query. Which of the following statements is correct?

SQL Code

SELECT id FROM users WHERE (city = 'New York' AND age > 25) OR (city = 'Los Angeles' AND age < 30);

Users from New York with age over 25 or users from Los Angeles with age less than 30. Users from New York or Los Angeles with age over 25. Users from New York with age over 25 and users from Los Angeles with age less than 30.Users from New York or Los Angeles with age less than 30.

The OR operator evaluates the conditions in each group separately, so the query returns users from New York aged over 25 or users from Los Angeles aged under 30.

Q16

Single Choice

Given the following table sales:

SQL Code

+-----------+------------+--------+--------+
| product | sale_date | region | amount |
+-----------+------------+--------+--------+
| A | 2024-07-01 | East | 1000 |
| B | 2024-07-02 | West | 2000 |
| C | 2024-07-03 | East | 1500 |
| D | 2024-07-04 | West | 3000 |
+-----------+------------+--------+--------+
What will be the result of this query?
SELECT product FROM sales WHERE region = 'East' OR amount > 2000;

A B C C A D A C DB A D

The OR operator selects rows where either the region is 'East' or the amount is greater than 2000. Products A, C, and D meet these conditions.

Q17

Single Choice

What does the following SQL statement return?

SQL Code

SELECT customer_id FROM transactions WHERE (status = 'completed' OR status = 'shipped') AND total > 500;

Customer IDs with transactions that are either completed or shipped, and total greater than 500. Customer IDs with transactions that are both completed and shipped, and total greater than 500. Customer IDs with transactions that are either completed or total greater than 500.All customer IDs with a total greater than 500.

The AND operator combines with the OR to require that the total is greater than 500 and the status is either 'completed' or 'shipped'.

Q18

Single Choice

Consider the following SQL statement. Which records will be selected?

SQL Code

SELECT order_id FROM orders WHERE (priority = 'high' AND delivery_date < '2024-08-01') OR (priority = 'low' AND delivery_date > '2024-08-05');

Orders with high priority and delivery before '2024-08-01'. Orders with low priority and delivery after '2024-08-05 Both A and B.All orders regardless of priority or delivery date.

The OR operator allows for either of the two combined conditions (priority and delivery date) to be true, so both high-priority orders delivered before '2024-08-01' and low-priority orders delivered after '2024-08-05' are selected.

Q19

Single Choice

Analyze the following SQL query. Which orders will be selected?

SQL Code

SELECT * FROM orders WHERE (total_amount > 1000 AND customer_id IN (SELECT customer_id FROM customers WHERE vip_status = 'yes')) OR (order_date BETWEEN '2024-01-01' AND '2024-06-30');

Orders with total amount over 1000 by VIP customers or orders made between '2024-01-01' and '2024-06-30'. Only orders with total amount over 1000 by VIP customers. Orders made between '2024-01-01' and '2024-06-30' by VIP customers.Only orders with total amount over 1000 by non-VIP customers.

The OR operator allows for selecting either orders with a total amount > 1000 by VIP customers or orders within the specified date range.

Q20

Single Choice

For the following query, which employees will be selected?

SQL Code

SELECT employee_id FROM employees WHERE (job_title = 'Manager' OR department = 'Finance') AND (hire_date > '2020-01-01' AND salary > 75000);

Managers or Finance employees hired after '2020-01-01' with a salary greater than 75000. Managers hired after '2020-01-01' or employees in Finance with a salary greater than 75000. Only Managers hired after '2020-01-01' with a salary greater than 75000.All employees hired after '2020-01-01' or with a salary greater than 75000.

The AND operator is used to enforce both conditions (hire date and salary) while the OR allows for either Managers or Finance employees to meet these conditions.

Q21

Multiple Choice

Which query correctly retrieves records from the 'employees' table where 'department_id' is 1 AND 'salary' is greater than 50000?

SQL Code

SELECT *
FROM employees
WHERE department_id = 1
AND salary > 50000;

SELECT * FROM employees WHERE department_id = 1 AND salary > 50000; SELECT * FROM employees WHERE department_id = 1 OR salary > 50000; SELECT * FROM employees WHERE department_id = 1 AND salary = 50000;SELECT * FROM employees WHERE department_id = 1;

The AND operator ensures that both conditions must be true for the row to be included in the result set.

Q22

Multiple Choice

Identify the correct SQL query that retrieves records from the 'orders' table where 'order_date' is '2023-01-01' OR 'status' is 'Pending'.

SQL Code

SELECT *
FROM orders
WHERE order_date = '2023-01-01'
OR status = 'Pending';

SELECT * FROM orders WHERE order_date = '2023-01-01' OR status = 'Pending'; SELECT * FROM orders WHERE order_date = '2023-01-01' AND status = 'Pending'; SELECT * FROM orders WHERE order_date = '2023-01-01';SELECT * FROM orders WHERE status = 'Pending';

The OR operator allows either condition to be true for the row to be included in the result set.

Q23

Multiple Choice

Which query correctly selects records from the 'products' table where 'price' is less than 100 AND 'stock' is greater than 10?

SQL Code

SELECT *
FROM products
WHERE price < 100
AND stock > 10;

SELECT * FROM products WHERE price < 100 AND stock > 10; SELECT * FROM products WHERE price < 100 OR stock > 10; SELECT * FROM products WHERE price = 100 AND stock = 10;SELECT * FROM products WHERE price > 100 AND stock > 10;

The AND operator is used to filter records where both conditions must be true: 'price' is less than 100 and 'stock' is greater than 10.

Q24

Multiple Choice

Determine the correct SQL query that retrieves records from the 'customers' table where 'country' is 'USA' OR 'state' is 'California'.

SQL Code

SELECT *
FROM customers
WHERE country = 'USA'
OR state = 'California';

SELECT * FROM customers WHERE country = 'USA' OR state = 'California'; SELECT * FROM customers WHERE country = 'USA' AND state = 'California'; SELECT * FROM customers WHERE country = 'USA';SELECT * FROM customers WHERE state = 'California';

The OR operator is used to filter records where either 'country' is 'USA' or 'state' is 'California'.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where 'category' is 'Electronics' AND 'quantity' is less than 50?

SQL Code

SELECT *
FROM inventory
WHERE category = 'Electronics'
AND quantity < 50;

SELECT * FROM inventory WHERE category = 'Electronics' AND quantity < 50; SELECT * FROM inventory WHERE category = 'Electronics' OR quantity < 50; SELECT * FROM inventory WHERE category = 'Electronics';SELECT * FROM inventory WHERE quantity < 50;

The AND operator is used to filter records where both 'category' is 'Electronics' and 'quantity' is less than 50.

Q26

Multiple Choice

Which query correctly retrieves records from the 'employees' table where 'job_title' is 'Manager' OR 'hire_date' is before '2020-01-01'?

SQL Code

SELECT *
FROM employees
WHERE job_title = 'Manager'
OR hire_date < '2020-01-01';

SELECT * FROM employees WHERE job_title = 'Manager' OR hire_date < '2020-01-01'; SELECT * FROM employees WHERE job_title = 'Manager' AND hire_date < '2020-01-01'; SELECT * FROM employees WHERE job_title = 'Manager';SELECT * FROM employees WHERE hire_date < '2020-01-01';

The OR operator is used to filter records where either 'job_title' is 'Manager' or 'hire_date' is before '2020-01-01'.

Q27

Multiple Choice

Determine the correct SQL query that selects records from the 'sales' table where 'region' is 'North' AND 'sales_amount' is greater than 1000.

SQL Code

SELECT *
FROM sales
WHERE region = 'North'
AND sales_amount > 1000;

SELECT * FROM sales WHERE region = 'North' AND sales_amount > 1000; SELECT * FROM sales WHERE region = 'North' OR sales_amount > 1000; SELECT * FROM sales WHERE region = 'North';SELECT * FROM sales WHERE sales_amount > 1000;

The AND operator is used to filter records where both 'region' is 'North' and 'sales_amount' is greater than 1000.

Q28

Multiple Choice

Which SQL query retrieves records from the 'projects' table where 'status' is 'Active' AND 'budget' is less than 50000?

SQL Code

SELECT *
FROM projects
WHERE status = 'Active'
AND budget < 50000;

SELECT * FROM projects WHERE status = 'Active' AND budget < 50000; SELECT * FROM projects WHERE status = 'Active' OR budget < 50000; SELECT * FROM projects WHERE status = 'Active';SELECT * FROM projects WHERE budget < 50000;

The AND operator is used to filter records where both 'status' is 'Active' and 'budget' is less than 50000.

Q29

Multiple Choice

Identify the correct query that retrieves records from the 'clients' table where 'industry' is 'Finance' OR 'revenue' is greater than 1000000.

SQL Code

SELECT *
FROM clients
WHERE industry = 'Finance'
OR revenue > 1000000;

SELECT * FROM clients WHERE industry = 'Finance' OR revenue > 1000000; SELECT * FROM clients WHERE industry = 'Finance' AND revenue > 1000000; SELECT * FROM clients WHERE industry = 'Finance';SELECT * FROM clients WHERE revenue > 1000000;

The OR operator is used to filter records where either 'industry' is 'Finance' or 'revenue' is greater than 1000000.

Q30

Multiple Choice

Which SQL query correctly retrieves records from the 'transactions' table where 'payment_method' is 'Credit Card' AND 'amount' is less than 500?

SQL Code

SELECT *
FROM transactions
WHERE payment_method = 'Credit Card'
AND amount < 500;

SELECT * FROM transactions WHERE payment_method = 'Credit Card' AND amount < 500; SELECT * FROM transactions WHERE payment_method = 'Credit Card' OR amount < 500; SELECT * FROM transactions WHERE payment_method = 'Credit Card';SELECT * FROM transactions WHERE amount < 500;

The AND operator is used to filter records where both 'payment_method' is 'Credit Card' and 'amount' is less than 500.

MySQL Database Quiz Questions