Test Your Microsoft SQL Server Equal To Operator ('=') Knowledge with This Quiz

Progress

True / False

The `=` operator can be used to compare two values for equality in SQL queries.

True False

The `=` operator is used in SQL to compare two values for equality. It returns true if the values are equal and false otherwise.

True / False

Using `=` with NULL values in SQL always returns true.

True False

`=` does not work with NULL values as expected. NULL comparisons require `IS NULL` or `IS NOT NULL`. Using `=` with NULL results in unknown.

True / False

The `=` operator can be used in `JOIN` conditions to match rows from two tables.

True False

The `=` operator is commonly used in `JOIN` conditions to match rows based on the equality of columns from different tables.

True / False

You can use the `=` operator to compare string values in SQL.

True False

The `=` operator can compare string values in SQL to check for exact matches.

True / False

The `=` operator can be used with aggregate functions to filter results.

True False

The `=` operator can be used with aggregate functions such as `COUNT()`, `SUM()`, etc., but it is used in the `HAVING` clause rather than `WHERE` for aggregated results.

True / False

The `=` operator in SQL can be used to compare dates and times.

True False

The `=` operator can compare date and time values in SQL to check if they are exactly equal.

True / False

The `=` operator can be used in a `CASE` statement to perform conditional logic.

True False

The `=` operator is used in `CASE` statements to compare values and determine which condition to satisfy.

True / False

You can use the `=` operator to filter results in a `GROUP BY` clause.

True False

The `=` operator is used to filter results before grouping. To filter results after grouping, use `HAVING` with `=`.

True / False

The `=` operator can be used in a subquery to match values with the outer query.

True False

The `=` operator is often used in subqueries to match values from the inner query with those in the outer query.

Q10

True / False

Using `=` with integer values can result in performance issues if indexes are not properly used.

True False

Using `=` with integer values generally performs well, but performance issues can arise if indexes are not used effectively.

Q11

True / False

The `=` operator can be used to compare decimal values accurately in SQL.

True False

The `=` operator can compare decimal values accurately, though care must be taken with floating-point precision.

Q12

True / False

In SQL, `=` can be used to compare values in different data types directly.

True False

`=` cannot directly compare different data types. Implicit conversions may occur, but it’s best to ensure the types are compatible.

Q13

True / False

The `=` operator in SQL can be used within a `WHERE` clause to filter rows based on equality.

True False

The `=` operator is commonly used within a `WHERE` clause to filter rows where column values match a specified value.

Q14

True / False

The `=` operator can be used to match values in a `JOIN` condition.

True False

The `=` operator is frequently used in `JOIN` conditions to match rows from different tables based on equal column values.

Q15

True / False

You can use `=` to compare columns with functions that return boolean values.

True False

`=` can be used to compare columns with the results of functions that return boolean values, such as `CASE` statements.

Q16

Single Choice

You can use `=` in a `WHERE` clause to check if a column value equals a constant.

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE Department = 'Sales';

SELECT EmployeeID, EmployeeName FROM Employees WHERE Department = 'Sales'; SELECT EmployeeID, EmployeeName FROM Employees WHERE Department != 'Sales'; SELECT EmployeeID, EmployeeName FROM Employees WHERE Department LIKE 'Sales';SELECT EmployeeID, EmployeeName FROM Employees WHERE Department IS NULL;

The `=` operator in the `WHERE` clause filters rows where the `Department` column equals 'Sales'.

Q17

Single Choice

Which query will find all products where the category is 'Electronics'?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE Category = 'Electronics';

SELECT ProductID, ProductName FROM Products WHERE Category = 'Electronics'; SELECT ProductID, ProductName FROM Products WHERE Category <> 'Electronics'; SELECT ProductID, ProductName FROM Products WHERE Category LIKE 'Electronics';SELECT ProductID, ProductName FROM Products WHERE Category IS NOT NULL;

The `=` operator is used in the `WHERE` clause to filter products where the `Category` equals 'Electronics'.

Q18

Single Choice

Which query correctly retrieves customers with a specific email address?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE Email = 'customer@example.com';

SELECT CustomerID, CustomerName FROM Customers WHERE Email = 'customer@example.com'; SELECT CustomerID, CustomerName FROM Customers WHERE Email LIKE 'customer@example.com'; SELECT CustomerID, CustomerName FROM Customers WHERE Email <> 'customer@example.com';SELECT CustomerID, CustomerName FROM Customers WHERE Email IS NULL;

The `=` operator is used to match the `Email` column with the specific email address.

Q19

Single Choice

How would you find orders with a status of 'Completed'?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE Status = 'Completed';

SELECT OrderID, OrderDate FROM Orders WHERE Status = 'Completed'; SELECT OrderID, OrderDate FROM Orders WHERE Status <> 'Completed'; SELECT OrderID, OrderDate FROM Orders WHERE Status LIKE 'Completed';SELECT OrderID, OrderDate FROM Orders WHERE Status IS NOT NULL;

The `=` operator is used to match the `Status` column with 'Completed'.

Q20

Single Choice

Which query returns employees with the role 'Manager'?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE Role = 'Manager';

SELECT EmployeeID, EmployeeName FROM Employees WHERE Role = 'Manager'; SELECT EmployeeID, EmployeeName FROM Employees WHERE Role <> 'Manager'; SELECT EmployeeID, EmployeeName FROM Employees WHERE Role LIKE 'Manager';SELECT EmployeeID, EmployeeName FROM Employees WHERE Role IS NULL;

The `=` operator is used to filter employees where the `Role` column equals 'Manager'.

Q21

Single Choice

Which query retrieves orders where the payment method is 'Credit Card'?

SQL Code

SELECT OrderID, PaymentMethod
FROM Orders
WHERE PaymentMethod = 'Credit Card';

SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod = 'Credit Card'; SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod <> 'Credit Card'; SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod LIKE 'Credit Card';SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod IS NULL;

The `=` operator is used to filter orders where the `PaymentMethod` column equals 'Credit Card'.

Q22

Single Choice

Which query retrieves products with a discount of 20%?

SQL Code

SELECT ProductID, ProductName, Discount
FROM Products
WHERE Discount = 20;

SELECT ProductID, ProductName, Discount FROM Products WHERE Discount = 20; SELECT ProductID, ProductName, Discount FROM Products WHERE Discount > 20; SELECT ProductID, ProductName, Discount FROM Products WHERE Discount < 20;SELECT ProductID, ProductName, Discount FROM Products WHERE Discount IS NOT NULL;

The `=` operator is used to match the `Discount` column with a value of 20.

Q23

Single Choice

Which query retrieves employees with an employee number of 12345?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE EmployeeNumber = 12345;

SELECT EmployeeID, EmployeeName FROM Employees WHERE EmployeeNumber = 12345; SELECT EmployeeID, EmployeeName FROM Employees WHERE EmployeeNumber <> 12345; SELECT EmployeeID, EmployeeName FROM Employees WHERE EmployeeNumber LIKE 12345;SELECT EmployeeID, EmployeeName FROM Employees WHERE EmployeeNumber IS NULL;

The `=` operator is used to match the `EmployeeNumber` column with the specific value 12345.

Q24

Single Choice

How can you find all records in a table where a column equals a certain value?

SQL Code

SELECT *
FROM TableName
WHERE ColumnName = 'Value';

SELECT * FROM TableName WHERE ColumnName = 'Value'; SELECT * FROM TableName WHERE ColumnName <> 'Value'; SELECT * FROM TableName WHERE ColumnName LIKE 'Value';SELECT * FROM TableName WHERE ColumnName IS NULL;

The `=` operator is used in the `WHERE` clause to filter records where `ColumnName` equals 'Value'.

Q25

Single Choice

Which query returns all orders placed by a customer with ID 1001?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE CustomerID = 1001;

SELECT OrderID, OrderDate FROM Orders WHERE CustomerID = 1001; SELECT OrderID, OrderDate FROM Orders WHERE CustomerID <> 1001; SELECT OrderID, OrderDate FROM Orders WHERE CustomerID LIKE 1001;SELECT OrderID, OrderDate FROM Orders WHERE CustomerID IS NULL;

The `=` operator is used to filter orders where the `CustomerID` column equals 1001.

Q26

Single Choice

Which query retrieves products where the stock is exactly 50?

SQL Code

SELECT ProductID, ProductName, Stock
FROM Products
WHERE Stock = 50;

SELECT ProductID, ProductName, Stock FROM Products WHERE Stock = 50; SELECT ProductID, ProductName, Stock FROM Products WHERE Stock > 50; SELECT ProductID, ProductName, Stock FROM Products WHERE Stock < 50;SELECT ProductID, ProductName, Stock FROM Products WHERE Stock IS NOT NULL;

The `=` operator is used to match the `Stock` column with the value 50.

Q27

Single Choice

Which query will find all customers with a status of 'Active'?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE Status = 'Active';

SELECT CustomerID, CustomerName FROM Customers WHERE Status = 'Active'; SELECT CustomerID, CustomerName FROM Customers WHERE Status <> 'Active'; SELECT CustomerID, CustomerName FROM Customers WHERE Status LIKE 'Active';SELECT CustomerID, CustomerName FROM Customers WHERE Status IS NULL;

The `=` operator is used to filter customers where the `Status` column equals 'Active'.

Q28

Single Choice

Which query returns employees hired on '2023-01-01'?

SQL Code

SELECT EmployeeID, EmployeeName, HireDate
FROM Employees
WHERE HireDate = '2023-01-01';

SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE HireDate = '2023-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE HireDate <> '2023-01-01'; SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE HireDate LIKE '2023-01-01';SELECT EmployeeID, EmployeeName, HireDate FROM Employees WHERE HireDate IS NULL;

The `=` operator is used to match the `HireDate` column with '2023-01-01'.

Q29

Single Choice

How would you find all products where the price is exactly 19.99?

SQL Code

SELECT ProductID, ProductName, Price
FROM Products
WHERE Price = 19.99;

SELECT ProductID, ProductName, Price FROM Products WHERE Price = 19.99; SELECT ProductID, ProductName, Price FROM Products WHERE Price > 19.99; SELECT ProductID, ProductName, Price FROM Products WHERE Price < 19.99;SELECT ProductID, ProductName, Price FROM Products WHERE Price IS NOT NULL;

The `=` operator is used to match the `Price` column with the value 19.99.

Q30

Single Choice

Which query retrieves orders where the total amount is exactly 100?

SQL Code

SELECT OrderID, TotalAmount
FROM Orders
WHERE TotalAmount = 100;

SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount = 100; SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount > 100; SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount < 100;SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount IS NOT NULL;

The `=` operator is used to match the `TotalAmount` column with the value 100.

Q31

Multiple Choice

Which query retrieves all customers with an address in 'New York'?

SQL Code

SELECT CustomerID, CustomerName, Address
FROM Customers
WHERE Address = 'New York';

SELECT CustomerID, CustomerName, Address FROM Customers WHERE Address = 'New York'; SELECT CustomerID, CustomerName, Address FROM Customers WHERE Address LIKE 'New York'; SELECT CustomerID, CustomerName, Address FROM Customers WHERE Address <> 'New York';SELECT CustomerID, CustomerName, Address FROM Customers WHERE Address IS NULL;

The `=` operator is used to match the `Address` column with 'New York'.

Q32

Multiple Choice

Which query retrieves all orders placed on '2023-07-30'?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE OrderDate = '2023-07-30';

SELECT OrderID, OrderDate FROM Orders WHERE OrderDate = '2023-07-30'; SELECT OrderID, OrderDate FROM Orders WHERE OrderDate LIKE '2023-07-30'; SELECT OrderID, OrderDate FROM Orders WHERE OrderDate <> '2023-07-30';SELECT OrderID, OrderDate FROM Orders WHERE OrderDate IS NOT NULL;

The `=` operator is used to match the `OrderDate` column with '2023-07-30'.

Q33

Multiple Choice

Which query retrieves products with a price of 50?

SQL Code

SELECT ProductID, ProductName, Price
FROM Products
WHERE Price = 50;

SELECT ProductID, ProductName, Price FROM Products WHERE Price = 50; SELECT ProductID, ProductName, Price FROM Products WHERE Price <> 50; SELECT ProductID, ProductName, Price FROM Products WHERE Price LIKE 50;SELECT ProductID, ProductName, Price FROM Products WHERE Price IS NOT NULL;

The `=` operator is used to match the `Price` column with the value 50.

Q34

Multiple Choice

How can you retrieve employees with a salary of 60000?

SQL Code

SELECT EmployeeID, EmployeeName, Salary
FROM Employees
WHERE Salary = 60000;

SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE Salary = 60000; SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE Salary <> 60000; SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE Salary LIKE 60000;SELECT EmployeeID, EmployeeName, Salary FROM Employees WHERE Salary IS NULL;

The `=` operator is used to match the `Salary` column with the value 60000.

Q35

Multiple Choice

Which query retrieves products with a stock quantity of 100?

SQL Code

SELECT ProductID, ProductName, Stock
FROM Products
WHERE Stock = 100;

SELECT ProductID, ProductName, Stock FROM Products WHERE Stock = 100; SELECT ProductID, ProductName, Stock FROM Products WHERE Stock <> 100; SELECT ProductID, ProductName, Stock FROM Products WHERE Stock LIKE 100;SELECT ProductID, ProductName, Stock FROM Products WHERE Stock IS NULL;

The `=` operator is used to match the `Stock` column with the value 100.

Q36

Multiple Choice

Which query retrieves customers where the city is 'Chicago'?

SQL Code

SELECT CustomerID, CustomerName, City
FROM Customers
WHERE City = 'Chicago';

SELECT CustomerID, CustomerName, City FROM Customers WHERE City = 'Chicago'; SELECT CustomerID, CustomerName, City FROM Customers WHERE City <> 'Chicago'; SELECT CustomerID, CustomerName, City FROM Customers WHERE City LIKE 'Chicago';SELECT CustomerID, CustomerName, City FROM Customers WHERE City IS NOT NULL;

The `=` operator is used to match the `City` column with 'Chicago'.

Q37

Multiple Choice

How would you find employees hired on '2023-01-01'?

SQL Code

SELECT EmployeeID, EmployeeName, HireDate
FROM Employees
WHERE HireDate = '2023-01-01';

The `=` operator is used to match the `HireDate` column with '2023-01-01'.

Q38

Multiple Choice

Which query retrieves orders where the payment method is 'PayPal'?

SQL Code

SELECT OrderID, PaymentMethod
FROM Orders
WHERE PaymentMethod = 'PayPal';

SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod = 'PayPal'; SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod <> 'PayPal'; SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod LIKE 'PayPal';SELECT OrderID, PaymentMethod FROM Orders WHERE PaymentMethod IS NOT NULL;

The `=` operator is used to filter orders where the `PaymentMethod` column equals 'PayPal'.

Q39

Multiple Choice

Which query retrieves customers with a specific phone number?

SQL Code

SELECT CustomerID, CustomerName, Phone
FROM Customers
WHERE Phone = '123-456-7890';

SELECT CustomerID, CustomerName, Phone FROM Customers WHERE Phone = '123-456-7890'; SELECT CustomerID, CustomerName, Phone FROM Customers WHERE Phone <> '123-456-7890'; SELECT CustomerID, CustomerName, Phone FROM Customers WHERE Phone LIKE '123-456-7890';SELECT CustomerID, CustomerName, Phone FROM Customers WHERE Phone IS NULL;

The `=` operator is used to match the `Phone` column with the specific phone number '123-456-7890'.

Q40

Multiple Choice

Which query retrieves products with a discount of 15%?

SQL Code

SELECT ProductID, ProductName, Discount
FROM Products
WHERE Discount = 15;

SELECT ProductID, ProductName, Discount FROM Products WHERE Discount = 15; SELECT ProductID, ProductName, Discount FROM Products WHERE Discount <> 15; SELECT ProductID, ProductName, Discount FROM Products WHERE Discount LIKE 15;SELECT ProductID, ProductName, Discount FROM Products WHERE Discount IS NOT NULL;

The `=` operator is used to match the `Discount` column with the value 15.

Q41

Multiple Choice

Which query retrieves employees with the role 'Developer'?

SQL Code

SELECT EmployeeID, EmployeeName, Role
FROM Employees
WHERE Role = 'Developer';

SELECT EmployeeID, EmployeeName, Role FROM Employees WHERE Role = 'Developer'; SELECT EmployeeID, EmployeeName, Role FROM Employees WHERE Role <> 'Developer'; SELECT EmployeeID, EmployeeName, Role FROM Employees WHERE Role LIKE 'Developer';SELECT EmployeeID, EmployeeName, Role FROM Employees WHERE Role IS NULL;

The `=` operator is used to match the `Role` column with 'Developer'.

Q42

Multiple Choice

Which query retrieves all customers where the email is 'customer@example.com'?

SQL Code

SELECT CustomerID, CustomerName, Email
FROM Customers
WHERE Email = 'customer@example.com';

SELECT CustomerID, CustomerName, Email FROM Customers WHERE Email = 'customer@example.com'; SELECT CustomerID, CustomerName, Email FROM Customers WHERE Email <> 'customer@example.com'; SELECT CustomerID, CustomerName, Email FROM Customers WHERE Email LIKE 'customer@example.com';SELECT CustomerID, CustomerName, Email FROM Customers WHERE Email IS NOT NULL;

The `=` operator is used to match the `Email` column with 'customer@example.com'.

Q43

Multiple Choice

Which query retrieves orders where the total amount is 200?

SQL Code

SELECT OrderID, TotalAmount
FROM Orders
WHERE TotalAmount = 200;

SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount = 200; SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount <> 200; SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount LIKE 200;SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount IS NOT NULL;

The `=` operator is used to match the `TotalAmount` column with the value 200.

Q44

Multiple Choice

Which query retrieves products with a price of 25.99?

SQL Code

SELECT ProductID, ProductName, Price
FROM Products
WHERE Price = 25.99;

SELECT ProductID, ProductName, Price FROM Products WHERE Price = 25.99; SELECT ProductID, ProductName, Price FROM Products WHERE Price <> 25.99; SELECT ProductID, ProductName, Price FROM Products WHERE Price LIKE 25.99;SELECT ProductID, ProductName, Price FROM Products WHERE Price IS NOT NULL;

The `=` operator is used to match the `Price` column with the value 25.99.

Q45

Multiple Choice

How would you retrieve employees with a department of 'HR'?

SQL Code

SELECT EmployeeID, EmployeeName, Department
FROM Employees
WHERE Department = 'HR';

SELECT EmployeeID, EmployeeName, Department FROM Employees WHERE Department = 'HR'; SELECT EmployeeID, EmployeeName, Department FROM Employees WHERE Department <> 'HR'; SELECT EmployeeID, EmployeeName, Department FROM Employees WHERE Department LIKE 'HR';SELECT EmployeeID, EmployeeName, Department FROM Employees WHERE Department IS NOT NULL;

The `=` operator is used to match the `Department` column with 'HR'.

Microsoft SQL Server Database Quiz Questions