Test Your Microsoft SQL Server Comparison Operators Knowledge with This Quiz

Progress

True / False

The '=' operator is used to compare two values for equality in SQL Server.

True False

The '=' operator checks if the values on both sides are equal.

True / False

The '!=' operator can be used to check if two values are not equal in SQL Server.

True False

In SQL Server, the '!=' operator is used to check inequality.

True / False

The '<>' operator is equivalent to the '!=' operator in SQL Server.

True False

Both '<>' and '!=' are used for inequality comparisons in SQL Server.

True / False

The '>' operator can be used to check if one value is greater than another.

True False

The '>' operator checks if the left value is greater than the right value.

True / False

The '<=' operator is used to check if one value is less than or equal to another.

True False

The '<=' operator checks if the left value is less than or equal to the right value.

True / False

Using the 'LIKE' operator, you can perform pattern matching in SQL Server.

True False

The 'LIKE' operator is used for pattern matching with wildcard characters.

True / False

The 'BETWEEN' operator includes the boundary values in SQL Server.

True False

The 'BETWEEN' operator checks if a value is within a range, inclusive of the boundary values.

True / False

The 'IN' operator can be used to check if a value matches any value in a list.

True False

The 'IN' operator checks if the left value is equal to any value in the provided list.

True / False

The '>' operator can only be used with numeric data types in SQL Server.

True False

The '>' operator can be used with numeric, date, and time data types.

Q10

True / False

The '<>' operator is not a valid SQL Server comparison operator.

True False

The '<>' operator is valid and used for inequality comparisons.

Q11

True / False

The '>' and '<' operators cannot be used to compare character strings in SQL Server.

True False

The '>' and '<' operators can be used to compare character strings based on their collation.

Q12

True / False

Using 'LIKE', the '%' wildcard matches any sequence of characters.

True False

The '%' wildcard in a 'LIKE' clause matches any sequence of characters.

Q13

True / False

The 'NOT' keyword can be combined with 'IN' to check if a value is not in a list.

True False

Combining 'NOT' with 'IN' checks if a value does not match any value in a list.

Q14

True / False

The '=' operator can be used to compare NULL values in SQL Server.

True False

NULL comparisons require 'IS NULL' or 'IS NOT NULL' as '=' cannot be used for NULL.

Q15

True / False

The 'BETWEEN' operator is exclusive of the boundary values in SQL Server.

True False

The 'BETWEEN' operator includes the boundary values in the range.

Q16

Single Choice

Which operator is used to check if one value is greater than another?

SQL Code

SELECT * FROM Employees
WHERE Salary > 50000;

> < =!=

The '>' operator checks if the left value is greater than the right value.

Q17

Single Choice

Which operator can be used to compare two values for inequality?

SQL Code

SELECT * FROM Products
WHERE Price != 100;

= != >=<=

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

Q18

Single Choice

Which operator is used for pattern matching in SQL Server?

SQL Code

SELECT * FROM Customers
WHERE Name LIKE 'A%';

IN = LIKEBETWEEN

The 'LIKE' operator is used for pattern matching with wildcard characters.

Q19

Single Choice

Which operator is used to check if a value is within a specified range?

SQL Code

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2020-01-01' AND '2020-12-31';

IN LIKE BETWEEN>

The 'BETWEEN' operator checks if a value is within a specified range, inclusive of the boundary values.

Q20

Single Choice

Which operator is used to check if a value matches any value in a list?

SQL Code

SELECT * FROM Students
WHERE Grade IN (90, 95, 100);

IN LIKE BETWEEN>

The 'IN' operator checks if a value matches any value in a list.

Q21

Single Choice

Which operator is used to compare two values for equality in SQL Server?

SQL Code

SELECT * FROM Users
WHERE UserID = 1;

!= <> =>

The '=' operator checks if the values on both sides are equal.

Q22

Single Choice

Which operator is used to check if one value is less than or equal to another?

SQL Code

SELECT * FROM Inventory
WHERE Quantity <= 100;

> <= =!=

The '<=' operator checks if the left value is less than or equal to the right value.

Q23

Single Choice

Which operator is used to check if one value is less than another?

SQL Code

SELECT * FROM Employees
WHERE Age < 30;

< > =!=

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

Q24

Single Choice

Which operator is used for inequality comparisons in SQL Server?

SQL Code

SELECT * FROM Sales
WHERE Revenue <> 1000;

= <> ><

The '<>' operator is used for inequality comparisons.

Q25

Single Choice

Which operator is used to compare NULL values in SQL Server?

SQL Code

SELECT * FROM Orders
WHERE ShippedDate IS NULL;

= != IS NULLLIKE

To compare NULL values, the 'IS NULL' or 'IS NOT NULL' operators must be used.

Q26

Single Choice

Which operator is used to check if a value does not match any value in a list?

SQL Code

SELECT * FROM Students
WHERE Grade NOT IN (70, 80, 90);

NOT IN LIKE BETWEEN>

The 'NOT IN' operator checks if a value does not match any value in a list.

Q27

Single Choice

Which operator is used to check if a value is greater than or equal to another?

SQL Code

SELECT * FROM Products
WHERE Stock >= 50;

> < >=<=

The '>=' operator checks if the left value is greater than or equal to the right value.

Q28

Single Choice

Which operator is used to compare character strings for pattern matching?

SQL Code

SELECT * FROM Employees
WHERE FirstName LIKE 'J%';

IN LIKE BETWEEN>

The 'LIKE' operator is used for pattern matching with character strings.

Q29

Single Choice

Which operator is used to check if a value is not NULL?

SQL Code

SELECT * FROM Payments
WHERE PaymentDate IS NOT NULL;

IS NULL IS NOT NULL !=LIKE

The 'IS NOT NULL' operator checks if a value is not NULL.

Q30

Single Choice

Which operator is used to check if a value is within a set of values?

SQL Code

SELECT * FROM Departments
WHERE DepartmentID IN (1, 2, 3);

IN LIKE BETWEEN>

The 'IN' operator checks if a value matches any value in a specified set.

Q31

Multiple Choice

Which operators can be used to compare numeric values in SQL Server?

SQL Code

SELECT * FROM Products
WHERE Price > 50;
SELECT * FROM Orders
WHERE Quantity >= 100;

> < >=<=

The '>', '<', '>=', and '<=' operators can be used to compare numeric values.

Q32

Multiple Choice

Which operators are used to check if values are equal or not equal in SQL Server?

SQL Code

SELECT * FROM Employees
WHERE Salary = 50000;
SELECT * FROM Products
WHERE Price != 100;

= != <>>

The '=', '!=', and '<>' operators are used to check equality and inequality.

Q33

Multiple Choice

Which operators can be used to check if a value is within a specific range?

SQL Code

SELECT * FROM Sales
WHERE Revenue BETWEEN 1000 AND 5000;
SELECT * FROM Students
WHERE Grade IN (80, 85, 90);

IN LIKE BETWEEN>

The 'BETWEEN' and 'IN' operators are used to check if a value is within a specific range or set.

Q34

Multiple Choice

Which operators are used to compare character strings for pattern matching?

SQL Code

SELECT * FROM Customers
WHERE Name LIKE 'A%';
SELECT * FROM Employees
WHERE LastName LIKE '%son';

LIKE = INBETWEEN

The 'LIKE' operator is used for pattern matching with character strings, along with wildcards like '%' and '_'.

Q35

Multiple Choice

Which operators can be used to check if a value is not NULL?

SQL Code

SELECT * FROM Orders
WHERE ShippedDate IS NOT NULL;
SELECT * FROM Employees
WHERE TerminationDate IS NULL;

IS NULL IS NOT NULL !==

The 'IS NULL' and 'IS NOT NULL' operators are used to check if a value is or is not NULL.

Q36

Multiple Choice

Which operators are used to compare date values in SQL Server?

SQL Code

SELECT * FROM Orders
WHERE OrderDate > '2023-01-01';
SELECT * FROM Events
WHERE EventDate <= '2023-12-31';

> < >=<=

The '>', '<', '>=', and '<=' operators can be used to compare date values.

Q37

Multiple Choice

Which operators can be used to check if a value is within a list?

SQL Code

SELECT * FROM Students
WHERE Grade IN (90, 95, 100);
SELECT * FROM Products
WHERE CategoryID IN (1, 2, 3);

IN LIKE BETWEEN>

The 'IN' operator checks if a value matches any value in a specified list.

Q38

Multiple Choice

Which operators can be used to compare NULL values in SQL Server?

SQL Code

SELECT * FROM Payments
WHERE PaymentDate IS NULL;
SELECT * FROM Orders
WHERE ShippedDate IS NOT NULL;

IS NULL IS NOT NULL !==

The 'IS NULL' and 'IS NOT NULL' operators are used to compare NULL values.

Q39

Multiple Choice

Which operators can be used to compare character strings in SQL Server?

SQL Code

SELECT * FROM Products
WHERE ProductName LIKE 'A%';
SELECT * FROM Employees
WHERE LastName LIKE 'S%';

LIKE = ><

The 'LIKE' operator is used for pattern matching with character strings, and comparison operators like '=', '>', and '<' can also be used.

Q40

Multiple Choice

Which operators are used to check if a value matches a specific pattern?

SQL Code

SELECT * FROM Customers
WHERE Name LIKE 'A%';
SELECT * FROM Employees
WHERE FirstName LIKE '_ohn';

LIKE IN BETWEEN=

The 'LIKE' operator with wildcards '%' and '_' is used for pattern matching.

Q41

Multiple Choice

Which operators can be used to check if a value is not in a list?

SQL Code

SELECT * FROM Students
WHERE Grade NOT IN (70, 80, 90);
SELECT * FROM Products
WHERE CategoryID NOT IN (1, 2, 3);

NOT IN LIKE BETWEEN>

The 'NOT IN' operator checks if a value does not match any value in a specified list.

Q42

Multiple Choice

Which operators are used to check if a value is greater than or equal to another?

SQL Code

SELECT * FROM Products
WHERE Stock >= 50;
SELECT * FROM Orders
WHERE Quantity >= 10;

> < >=<=

The '>=' operator checks if the left value is greater than or equal to the right value.

Q43

Multiple Choice

Which operators can be used to compare date values for equality?

SQL Code

SELECT * FROM Orders
WHERE OrderDate = '2023-01-01';
SELECT * FROM Events
WHERE EventDate = '2023-12-31';

= != ><

The '=' operator checks if the date values are equal.

Q44

Multiple Choice

Which operators are used to compare NULL values for equality?

SQL Code

SELECT * FROM Payments
WHERE PaymentDate IS NULL;
SELECT * FROM Orders
WHERE ShippedDate IS NOT NULL;

IS NULL IS NOT NULL !==

The 'IS NULL' and 'IS NOT NULL' operators are used to compare NULL values for equality.

Q45

Multiple Choice

Which operators can be used to compare values for inequality in SQL Server?

SQL Code

SELECT * FROM Employees
WHERE Salary != 50000;
SELECT * FROM Products
WHERE Price <> 100;

!= <> >IS NOT

The '!=', '<>', and 'IS NOT' operators can be used to compare values for inequality.

Microsoft SQL Server Database Quiz Questions