Test Your Microsoft SQL Server AND and OR Operators Knowledge with This Quiz

Progress

True / False

The AND operator returns true if both conditions are true.

True False

The AND operator requires both conditions to be true to return true.

True / False

The OR operator returns true if at least one condition is true.

True False

The OR operator requires at least one of the conditions to be true to return true.

True / False

The AND operator can be used to combine more than two conditions.

True False

The AND operator can be used to combine multiple conditions.

True / False

The OR operator can only combine two conditions at a time.

True False

The OR operator can combine multiple conditions, not just two.

True / False

Combining conditions with AND always returns fewer rows than using OR.

True False

Combining conditions with AND is more restrictive, generally returning fewer rows than OR.

True / False

The AND operator can be used to filter rows based on multiple columns.

True False

The AND operator can be used to apply conditions on multiple columns in a query.

True / False

The OR operator can be used to check multiple columns for NULL values.

True False

The OR operator can be used to check if any of the specified columns contain NULL values.

True / False

The AND operator has higher precedence than the OR operator in SQL Server.

True False

In SQL Server, the AND operator has higher precedence than the OR operator.

True / False

Using parentheses can change the order of evaluation for AND and OR operators.

True False

Parentheses can be used to explicitly define the order of evaluation for logical operators.

Q10

True / False

Combining AND and OR operators without parentheses always results in incorrect queries.

True False

While it may result in unexpected behavior, it does not always lead to incorrect queries. Understanding operator precedence is key.

Q11

True / False

AND and OR operators can be used in a single query to filter data.

True False

AND and OR operators can be combined in a single query to apply complex filtering conditions.

Q12

True / False

The AND operator can be used to return rows where all conditions are false.

True False

The AND operator returns true only if all conditions are true, not false.

Q13

True / False

The OR operator can be used to return rows where all conditions are true.

True False

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

Q14

True / False

Combining AND and OR operators requires careful attention to query logic.

True False

Using both AND and OR in a query requires understanding how they interact to ensure correct logic.

Q15

True / False

Logical operators like AND and OR are used in the WHERE clause to filter data.

True False

AND and OR operators are typically used in the WHERE clause to apply conditions to filter rows in SQL queries.

Q16

Single Choice

Which operator would you use to return rows that meet both of two conditions?

AND OR NOTBETWEEN

The AND operator is used to return rows that meet both specified conditions.

Q17

Single Choice

Which operator would you use to return rows that meet at least one of two conditions?

AND OR NOTBETWEEN

The OR operator is used to return rows that meet at least one of the specified conditions.

Q18

Single Choice

Which query retrieves employees who either work in department 3 or have a salary above 50000?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE DepartmentID = 3
OR Salary > 50000;

SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID = 3 AND Salary > 50000; SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID = 3 OR Salary > 50000; SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID = 3 OR Salary < 50000;SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID = 3 AND Salary < 50000;

The query uses the OR operator to return employees who meet either condition.

Q19

Single Choice

Which query retrieves orders placed by customers with CustomerID 5 or who have ordered more than 10 items?

SQL Code

SELECT OrderID, CustomerID, Quantity
FROM Orders
WHERE CustomerID = 5
OR Quantity > 10;

SELECT OrderID, CustomerID, Quantity FROM Orders WHERE CustomerID = 5 AND Quantity > 10; SELECT OrderID, CustomerID, Quantity FROM Orders WHERE CustomerID = 5 OR Quantity > 10; SELECT OrderID, CustomerID, Quantity FROM Orders WHERE CustomerID = 5 OR Quantity < 10;SELECT OrderID, CustomerID, Quantity FROM Orders WHERE CustomerID = 5 AND Quantity < 10;

The query uses the OR operator to return orders that meet either condition.

Q20

Single Choice

Which query retrieves products that are either in category 2 or have a price above 20?

SQL Code

SELECT ProductID, ProductName, Price
FROM Products
WHERE CategoryID = 2
OR Price > 20;

SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 2 AND Price > 20; SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 2 OR Price > 20; SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 2 OR Price < 20;SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 2 AND Price < 20;

The query uses the OR operator to return products that meet either condition.

Q21

Single Choice

Which query retrieves customers who are either from city 'New York' or have a balance above 1000?

SQL Code

SELECT CustomerID, CustomerName, Balance
FROM Customers
WHERE City = 'New York'
OR Balance > 1000;

SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'New York' AND Balance > 1000; SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'New York' OR Balance > 1000; SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'New York' OR Balance < 1000;SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'New York' AND Balance < 1000;

The query uses the OR operator to return customers who meet either condition.

Q22

Single Choice

Which query retrieves employees who are both in department 4 and have been hired after '2020-01-01'?

SQL Code

SELECT EmployeeID, EmployeeName, HireDate
FROM Employees
WHERE DepartmentID = 4
AND HireDate > '2020-01-01';

SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 4 AND HireDate > '2020-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 4 OR HireDate > '2020-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 4 AND HireDate < '2020-01-01';SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 4 OR HireDate < '2020-01-01';

The query uses the AND operator to return employees who meet both conditions.

Q23

Single Choice

Which query retrieves orders placed by customer 3 and have a total amount greater than 500?

SQL Code

SELECT OrderID, CustomerID, TotalAmount
FROM Orders
WHERE CustomerID = 3
AND TotalAmount > 500;

SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 3 AND TotalAmount > 500; SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 3 OR TotalAmount > 500; SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 3 AND TotalAmount < 500;SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 3 OR TotalAmount < 500;

The query uses the AND operator to return orders that meet both conditions.

Q24

Single Choice

Which query retrieves products that are both in category 1 and have a stock quantity below 50?

SQL Code

SELECT ProductID, ProductName, StockQuantity
FROM Products
WHERE CategoryID = 1
AND StockQuantity < 50;

SELECT ProductID, ProductName, StockQuantity FROM Products WHERE CategoryID = 1 AND StockQuantity < 50; SELECT ProductID, ProductName, StockQuantity FROM Products WHERE CategoryID = 1 OR StockQuantity < 50; SELECT ProductID, ProductName, StockQuantity FROM Products WHERE CategoryID = 1 AND StockQuantity > 50;SELECT ProductID, ProductName, StockQuantity FROM Products WHERE CategoryID = 1 OR StockQuantity > 50;

The query uses the AND operator to return products that meet both conditions.

Q25

Single Choice

Which query retrieves customers who are from city 'Los Angeles' and have a balance above 500?

SQL Code

SELECT CustomerID, CustomerName, Balance
FROM Customers
WHERE City = 'Los Angeles'
AND Balance > 500;

SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'Los Angeles' AND Balance > 500; SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'Los Angeles' OR Balance > 500; SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'Los Angeles' AND Balance < 500;SELECT CustomerID, CustomerName, Balance FROM Customers WHERE City = 'Los Angeles' OR Balance < 500;

The query uses the AND operator to return customers who meet both conditions.

Q26

Single Choice

Which query retrieves orders that were placed in 2021 or have a total amount above 1000?

SQL Code

SELECT OrderID, OrderDate, TotalAmount
FROM Orders
WHERE YEAR(OrderDate) = 2021
OR TotalAmount > 1000;

SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 AND TotalAmount > 1000; SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 OR TotalAmount > 1000; SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 OR TotalAmount < 1000;SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 AND TotalAmount < 1000;

The query uses the OR operator to return orders that meet either condition.

Q27

Single Choice

Which query retrieves products that are either in category 3 or have a price below 10?

SQL Code

SELECT ProductID, ProductName, Price
FROM Products
WHERE CategoryID = 3
OR Price < 10;

SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 3 AND Price < 10; SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 3 OR Price < 10; SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 3 OR Price > 10;SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 3 AND Price > 10;

The query uses the OR operator to return products that meet either condition.

Q28

Single Choice

Which query retrieves employees who are either in department 2 or have been hired before '2019-01-01'?

SQL Code

SELECT EmployeeID, EmployeeName, HireDate
FROM Employees
WHERE DepartmentID = 2
OR HireDate < '2019-01-01';

SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 2 AND HireDate < '2019-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 2 OR HireDate < '2019-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 2 OR HireDate > '2019-01-01';SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 2 AND HireDate > '2019-01-01';

The query uses the OR operator to return employees who meet either condition.

Q29

Single Choice

Which query retrieves orders that were placed in the first quarter of 2021 and have a total amount below 500?

SQL Code

SELECT OrderID, OrderDate, TotalAmount
FROM Orders
WHERE YEAR(OrderDate) = 2021
AND MONTH(OrderDate) IN (1, 2, 3)
AND TotalAmount < 500;

SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 AND MONTH(OrderDate) IN (1, 2, 3) AND TotalAmount < 500; SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 AND MONTH(OrderDate) IN (1, 2, 3) OR TotalAmount < 500; SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 OR MONTH(OrderDate) IN (1, 2, 3) AND TotalAmount < 500;SELECT OrderID, OrderDate, TotalAmount FROM Orders WHERE YEAR(OrderDate) = 2021 OR MONTH(OrderDate) IN (1, 2, 3) OR TotalAmount < 500;

The query uses the AND operator to return orders that meet all specified conditions.

Q30

Single Choice

Which query retrieves products that are either in category 4 or have been discontinued?

SQL Code

SELECT ProductID, ProductName, Discontinued
FROM Products
WHERE CategoryID = 4
OR Discontinued = 1;

SELECT ProductID, ProductName, Discontinued FROM Products WHERE CategoryID = 4 AND Discontinued = 1; SELECT ProductID, ProductName, Discontinued FROM Products WHERE CategoryID = 4 OR Discontinued = 1; SELECT ProductID, ProductName, Discontinued FROM Products WHERE CategoryID = 4 OR Discontinued = 0;SELECT ProductID, ProductName, Discontinued FROM Products WHERE CategoryID = 4 AND Discontinued = 0;

The query uses the OR operator to return products that meet either condition.

Q31

Multiple Choice

Which query retrieves employees who are either in department 1 or 2 and have a salary above 3000?

SQL Code

SELECT EmployeeID, EmployeeName, Salary
FROM Employees
WHERE (DepartmentID = 1
OR DepartmentID = 2)
AND Salary > 3000;

SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE DepartmentID = 1 AND DepartmentID = 2 AND Salary > 3000; SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE DepartmentID = 1 OR DepartmentID = 2 AND Salary > 3000; SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE (DepartmentID = 1 OR DepartmentID = 2) AND Salary > 3000;SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE (DepartmentID = 1 AND DepartmentID = 2) OR Salary > 3000;

The query uses both AND and OR operators to return employees who meet the specified conditions.

Q32

Multiple Choice

Which query retrieves products that are either in category 5 or have a stock quantity below 20 and a price above 10?

SQL Code

SELECT ProductID, ProductName, StockQuantity, Price
FROM Products
WHERE (CategoryID = 5
OR StockQuantity < 20)
AND Price > 10;

SELECT ProductID, ProductName, StockQuantity, Price FROM Products WHERE CategoryID = 5 AND StockQuantity < 20 AND Price > 10; SELECT ProductID, ProductName, StockQuantity, Price FROM Products WHERE CategoryID = 5 OR StockQuantity < 20 AND Price > 10; SELECT ProductID, ProductName, StockQuantity, Price FROM Products WHERE (CategoryID = 5 OR StockQuantity < 20) AND Price > 10;SELECT ProductID, ProductName, StockQuantity, Price FROM Products WHERE (CategoryID = 5 AND StockQuantity < 20) OR Price > 10;

The query uses both AND and OR operators to return products that meet the specified conditions.

Q33

Multiple Choice

Which query retrieves customers who are either from 'Chicago' or 'Boston' and have made more than 5 purchases?

SQL Code

SELECT CustomerID, CustomerName, Purchases
FROM Customers
WHERE (City = 'Chicago'
OR City = 'Boston')
AND Purchases > 5;

SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE City = 'Chicago' AND City = 'Boston' AND Purchases > 5; SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE City = 'Chicago' OR City = 'Boston' AND Purchases > 5; SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE (City = 'Chicago' OR City = 'Boston') AND Purchases > 5;SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE (City = 'Chicago' AND City = 'Boston') OR Purchases > 5;

The query uses both AND and OR operators to return customers who meet the specified conditions.

Q34

Multiple Choice

Which query retrieves orders placed by customers with CustomerID 4 or 7 and have a total amount below 200?

SQL Code

SELECT OrderID, CustomerID, TotalAmount
FROM Orders
WHERE (CustomerID = 4
OR CustomerID = 7)
AND TotalAmount < 200;

SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 4 AND CustomerID = 7 AND TotalAmount < 200; SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 4 OR CustomerID = 7 AND TotalAmount < 200; SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE (CustomerID = 4 OR CustomerID = 7) AND TotalAmount < 200;SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE (CustomerID = 4 AND CustomerID = 7) OR TotalAmount < 200;

The query uses both AND and OR operators to return orders that meet the specified conditions.

Q35

Multiple Choice

Which query retrieves employees who have either joined in 2020 or 2021 and have a salary above 4000?

SQL Code

SELECT EmployeeID, EmployeeName, HireDate, Salary
FROM Employees
WHERE (YEAR(HireDate) = 2020
OR YEAR(HireDate) = 2021)
AND Salary > 4000;

SELECT EmployeeID, EmployeeName, HireDate, Salary FROM Employees WHERE YEAR(HireDate) = 2020 AND YEAR(HireDate) = 2021 AND Salary > 4000; SELECT EmployeeID, EmployeeName, HireDate, Salary FROM Employees WHERE YEAR(HireDate) = 2020 OR YEAR(HireDate) = 2021 AND Salary > 4000; SELECT EmployeeID, EmployeeName, HireDate, Salary FROM Employees WHERE (YEAR(HireDate) = 2020 OR YEAR(HireDate) = 2021) AND Salary > 4000;SELECT EmployeeID, EmployeeName, HireDate, Salary FROM Employees WHERE (YEAR(HireDate) = 2020 AND YEAR(HireDate) = 2021) OR Salary > 4000;

The query uses both AND and OR operators to return employees who meet the specified conditions.

Q36

Multiple Choice

Which query retrieves products that are either in category 1 or 2 and have a price between 50 and 100?

SQL Code

SELECT ProductID, ProductName, Price
FROM Products
WHERE (CategoryID = 1
OR CategoryID = 2)
AND Price BETWEEN 50 AND 100;

SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 1 AND CategoryID = 2 AND Price BETWEEN 50 AND 100; SELECT ProductID, ProductName, Price FROM Products WHERE CategoryID = 1 OR CategoryID = 2 AND Price BETWEEN 50 AND 100; SELECT ProductID, ProductName, Price FROM Products WHERE (CategoryID = 1 OR CategoryID = 2) AND Price BETWEEN 50 AND 100;SELECT ProductID, ProductName, Price FROM Products WHERE (CategoryID = 1 AND CategoryID = 2) OR Price BETWEEN 50 AND 100;

The query uses both AND and OR operators to return products that meet the specified conditions.

Q37

Multiple Choice

Which query retrieves customers who are either from 'New York' or 'Los Angeles' and have made more than 3 purchases?

SQL Code

SELECT CustomerID, CustomerName, Purchases
FROM Customers
WHERE (City = 'New York'
OR City = 'Los Angeles')
AND Purchases > 3;

SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE City = 'New York' AND City = 'Los Angeles' AND Purchases > 3; SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE City = 'New York' OR City = 'Los Angeles' AND Purchases > 3; SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE (City = 'New York' OR City = 'Los Angeles') AND Purchases > 3;SELECT CustomerID, CustomerName, Purchases FROM Customers WHERE (City = 'New York' AND City = 'Los Angeles') OR Purchases > 3;

The query uses both AND and OR operators to return customers who meet the specified conditions.

Q38

Multiple Choice

Which query retrieves orders that were placed by customers with CustomerID 8 or 10 and have a total amount above 150?

SQL Code

SELECT OrderID, CustomerID, TotalAmount
FROM Orders
WHERE (CustomerID = 8
OR CustomerID = 10)
AND TotalAmount > 150;

SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 8 AND CustomerID = 10 AND TotalAmount > 150; SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE CustomerID = 8 OR CustomerID = 10 AND TotalAmount > 150; SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE (CustomerID = 8 OR CustomerID = 10) AND TotalAmount > 150;SELECT OrderID, CustomerID, TotalAmount FROM Orders WHERE (CustomerID = 8 AND CustomerID = 10) OR TotalAmount > 150;

The query uses both AND and OR operators to return orders that meet the specified conditions.

Q39

Multiple Choice

Which query retrieves employees who are either in department 3 or 4 and have been hired after '2020-01-01'?

SQL Code

SELECT EmployeeID, EmployeeName, HireDate
FROM Employees
WHERE (DepartmentID = 3
OR DepartmentID = 4)
AND HireDate > '2020-01-01';

SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 3 AND DepartmentID = 4 AND HireDate > '2020-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE DepartmentID = 3 OR DepartmentID = 4 AND HireDate > '2020-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE (DepartmentID = 3 OR DepartmentID = 4) AND HireDate > '2020-01-01';SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE (DepartmentID = 3 AND DepartmentID = 4) OR HireDate > '2020-01-01';

The query uses both AND and OR operators to return employees who meet the specified conditions.

Q40

Multiple Choice

Which query retrieves products that are either in category 3 or 6 and have a stock quantity above 50?

SQL Code

SELECT ProductID, ProductName, StockQuantity
FROM Products
WHERE (CategoryID = 3
OR CategoryID = 6)
AND StockQuantity > 50;

SELECT ProductID, ProductName, StockQuantity FROM Products WHERE CategoryID = 3 AND CategoryID = 6 AND StockQuantity > 50; SELECT ProductID, ProductName, StockQuantity FROM Products WHERE CategoryID = 3 OR CategoryID = 6 AND StockQuantity > 50; SELECT ProductID, ProductName, StockQuantity FROM Products WHERE (CategoryID = 3 OR CategoryID = 6) AND StockQuantity > 50;SELECT ProductID, ProductName, StockQuantity FROM Products WHERE (CategoryID = 3 AND CategoryID = 6) OR StockQuantity > 50;

The query uses both AND and OR operators to return products that meet the specified conditions.

Q41

Multiple Choice

Which query retrieves customers who have either made 10 or more purchases or have a loyalty score above 80?

SQL Code

SELECT CustomerID, CustomerName, Purchases, LoyaltyScore
FROM Customers
WHERE Purchases >= 10
OR LoyaltyScore > 80;

SELECT CustomerID, CustomerName, Purchases, LoyaltyScore FROM Customers WHERE Purchases >= 10 AND LoyaltyScore > 80; SELECT CustomerID, CustomerName, Purchases, LoyaltyScore FROM Customers WHERE Purchases >= 10 OR LoyaltyScore > 80; SELECT CustomerID, CustomerName, Purchases, LoyaltyScore FROM Customers WHERE (Purchases >= 10 AND LoyaltyScore > 80);SELECT CustomerID, CustomerName, Purchases, LoyaltyScore FROM Customers WHERE (Purchases >= 10 OR LoyaltyScore > 80);

The query uses the OR operator to return customers who meet either condition.

Q42

Multiple Choice

Which query retrieves orders that have a discount above 20% or were placed in the last quarter of 2022?

SQL Code

SELECT OrderID, Discount, OrderDate
FROM Orders
WHERE Discount > 0.20
OR (YEAR(OrderDate) = 2022
AND MONTH(OrderDate) IN (10, 11, 12));

SELECT OrderID, Discount, OrderDate FROM Orders WHERE Discount > 0.20 AND YEAR(OrderDate) = 2022 AND MONTH(OrderDate) IN (10, 11, 12); SELECT OrderID, Discount, OrderDate FROM Orders WHERE Discount > 0.20 OR YEAR(OrderDate) = 2022 AND MONTH(OrderDate) IN (10, 11, 12); SELECT OrderID, Discount, OrderDate FROM Orders WHERE Discount > 0.20 OR (YEAR(OrderDate) = 2022 AND MONTH(OrderDate) IN (10, 11, 12));SELECT OrderID, Discount, OrderDate FROM Orders WHERE (Discount > 0.20 AND YEAR(OrderDate) = 2022) OR MONTH(OrderDate) IN (10, 11, 12);

The query uses both AND and OR operators to return orders that meet the specified conditions.

Q43

Multiple Choice

Which query retrieves employees who are either managers or have been with the company for more than 5 years?

SQL Code

SELECT EmployeeID, EmployeeName, Position, HireDate
FROM Employees
WHERE Position = 'Manager'
OR DATEDIFF(YEAR, HireDate, GETDATE()) > 5;

SELECT EmployeeID, EmployeeName, Position, HireDate FROM Employees WHERE Position = 'Manager' AND DATEDIFF(YEAR, HireDate, GETDATE()) > 5; SELECT EmployeeID, EmployeeName, Position, HireDate FROM Employees WHERE Position = 'Manager' OR DATEDIFF(YEAR, HireDate, GETDATE()) > 5; SELECT EmployeeID, EmployeeName, Position, HireDate FROM Employees WHERE Position = 'Manager' AND (DATEDIFF(YEAR, HireDate, GETDATE()) > 5);SELECT EmployeeID, EmployeeName, Position, HireDate FROM Employees WHERE Position = 'Manager' OR (DATEDIFF(YEAR, HireDate, GETDATE()) > 5);

The query uses the OR operator to return employees who meet either condition.

Q44

Multiple Choice

Which query retrieves products that are either discontinued or have a price less than 20?

SQL Code

SELECT ProductID, ProductName, Price, Discontinued
FROM Products
WHERE Discontinued = 1
OR Price < 20;

SELECT ProductID, ProductName, Price, Discontinued FROM Products WHERE Discontinued = 1 AND Price < 20; SELECT ProductID, ProductName, Price, Discontinued FROM Products WHERE Discontinued = 1 OR Price < 20; SELECT ProductID, ProductName, Price, Discontinued FROM Products WHERE Discontinued = 1 AND (Price < 20);SELECT ProductID, ProductName, Price, Discontinued FROM Products WHERE Discontinued = 1 OR (Price < 20);

The query uses the OR operator to return products that meet either condition.

Q45

Multiple Choice

Which query retrieves employees who are either in the Sales department or the Marketing department and have a performance rating above 4?

SQL Code

SELECT EmployeeID, EmployeeName, DepartmentID, PerformanceRating
FROM Employees
WHERE (DepartmentID = 'Sales'
OR DepartmentID = 'Marketing')
AND PerformanceRating > 4;

SELECT EmployeeID, EmployeeName, DepartmentID, PerformanceRating FROM Employees WHERE DepartmentID = 'Sales' AND DepartmentID = 'Marketing' AND PerformanceRating > 4; SELECT EmployeeID, EmployeeName, DepartmentID, PerformanceRating FROM Employees WHERE DepartmentID = 'Sales' OR DepartmentID = 'Marketing' AND PerformanceRating > 4; SELECT EmployeeID, EmployeeName, DepartmentID, PerformanceRating FROM Employees WHERE (DepartmentID = 'Sales' OR DepartmentID = 'Marketing') AND PerformanceRating > 4;SELECT EmployeeID, EmployeeName, DepartmentID, PerformanceRating FROM Employees WHERE (DepartmentID = 'Sales' AND DepartmentID = 'Marketing') OR PerformanceRating > 4;

The query uses both AND and OR operators to return employees who meet the specified conditions.

Microsoft SQL Server Database Quiz Questions