Test Your Microsoft SQL Server IS NOT NULL Operator Knowledge with This Quiz

Progress

True / False

The IS NOT NULL operator is used to test for non-empty values in a column.

True False

The IS NOT NULL operator is used in SQL to test for non-empty (non-NULL) values in a column.

True / False

The query 'SELECT * FROM Employees WHERE Department IS NOT NULL;' will return employees with a department assigned.

True False

The IS NOT NULL operator is used in the WHERE clause to filter records with non-NULL values in the specified column.

True / False

Using IS NOT NULL in a query will check for values explicitly set to zero.

True False

The IS NOT NULL operator checks for non-NULL values, not for zero values.

True / False

The IS NOT NULL operator can be used in the SELECT clause to replace non-NULL values.

True False

The IS NOT NULL operator is used in the WHERE clause to filter records, not in the SELECT clause to replace values.

True / False

The query 'SELECT * FROM Orders WHERE OrderDate IS NOT NULL;' will return orders with a non-NULL order date.

True False

The query uses the IS NOT NULL operator to filter records where the OrderDate column has non-NULL values.

True / False

The IS NOT NULL operator can be used to check for non-NULL values in any column of a table.

True False

The IS NOT NULL operator is used to check for non-NULL values in any specified column of a table.

True / False

The IS NOT NULL operator is not supported in the WHERE clause of a SQL query.

True False

The IS NOT NULL operator is commonly used in the WHERE clause of a SQL query to filter records with non-NULL values.

True / False

Using IS NOT NULL in a query will always return the same result as using '= NOT NULL'.

True False

The IS NOT NULL operator is used to check for non-NULL values, while '= NOT NULL' is invalid and does not work in SQL.

True / False

The IS NOT NULL operator can be combined with the OR operator in a WHERE clause.

True False

The IS NOT NULL operator can be used in combination with the OR operator to check for non-NULL values in multiple columns.

Q10

True / False

The IS NOT NULL operator can be used to check for non-NULL values in string columns only.

True False

The IS NOT NULL operator can be used to check for non-NULL values in any type of column, not just string columns.

Q11

True / False

The query 'SELECT * FROM Employees WHERE ManagerID IS NOT NULL;' will retrieve employees who have a manager.

True False

The query uses the IS NOT NULL operator to filter records where the ManagerID column has non-NULL values, indicating an assigned manager.

Q12

True / False

The IS NOT NULL operator can be used with aggregate functions like COUNT and SUM.

True False

The IS NOT NULL operator is typically used in the WHERE clause, but aggregate functions can use IS NOT NULL within conditional statements.

Q13

True / False

Using IS NOT NULL in a DELETE statement will delete all rows with non-NULL values in a specified column.

True False

The IS NOT NULL operator can be used in a DELETE statement to target rows with non-NULL values in a specified column for deletion.

Q14

True / False

The IS NOT NULL operator is used to update non-NULL values in a table.

True False

The IS NOT NULL operator is used to check for non-NULL values, while the UPDATE statement is used to change data in a table.

Q15

True / False

The query 'SELECT * FROM Invoices WHERE PaymentDate IS NOT NULL;' retrieves invoices with a payment date.

True False

The query uses the IS NOT NULL operator to filter records where the PaymentDate column has non-NULL values, indicating a payment date.

Q16

Single Choice

Which query retrieves employees with an email address?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE Email IS NOT NULL;

SELECT EmployeeID, EmployeeName FROM Employees WHERE Email IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE Email IS NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE Email = NOT NULL;SELECT EmployeeID, EmployeeName FROM Employees WHERE Email <> NULL;

The query uses the IS NOT NULL operator to filter employees with an email address.

Q17

Single Choice

Which query lists products with non-NULL values in the Price column?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE Price IS NOT NULL;

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

The query checks for non-NULL values in the Price column to find products with a specified price.

Q18

Single Choice

Which query retrieves orders that have been shipped?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShipDate IS NOT NULL;

SELECT OrderID, OrderDate FROM Orders WHERE ShipDate IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShipDate IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShipDate = NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE ShipDate <> NULL;

The query uses the IS NOT NULL operator to filter orders with a non-NULL ShipDate.

Q19

Single Choice

Which query lists suppliers with a non-NULL contact number?

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE ContactNumber IS NOT NULL;

SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber = NOT NULL;SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber <> NULL;

The query checks for non-NULL values in the ContactNumber column to find suppliers with a specified contact number.

Q20

Single Choice

Which query retrieves customers with a non-NULL address?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE Address IS NOT NULL;

SELECT CustomerID, CustomerName FROM Customers WHERE Address IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE Address IS NULL; SELECT CustomerID, CustomerName FROM Customers WHERE Address = NOT NULL;SELECT CustomerID, CustomerName FROM Customers WHERE Address <> NULL;

The query uses the IS NOT NULL operator to filter customers with a non-NULL address.

Q21

Single Choice

Which query retrieves employees who have a specified salary?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE Salary IS NOT NULL;

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

The query uses the IS NOT NULL operator to filter employees with a non-NULL salary.

Q22

Single Choice

Which query lists orders that have a non-NULL discount?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE Discount IS NOT NULL;

SELECT OrderID, OrderDate FROM Orders WHERE Discount IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE Discount IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE Discount = NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE Discount <> NULL;

The query checks for non-NULL values in the Discount column to find orders with a specified discount.

Q23

Single Choice

Which query retrieves customers with a non-NULL phone number?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE PhoneNumber IS NOT NULL;

SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber IS NULL; SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber = NOT NULL;SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber <> NULL;

The query uses the IS NOT NULL operator to filter customers with a non-NULL phone number.

Q24

Single Choice

Which query lists suppliers with a non-NULL email address?

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE Email IS NOT NULL;

SELECT SupplierID, SupplierName FROM Suppliers WHERE Email IS NOT NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE Email IS NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE Email = NOT NULL;SELECT SupplierID, SupplierName FROM Suppliers WHERE Email <> NULL;

The query checks for non-NULL values in the Email column to find suppliers with a specified email address.

Q25

Single Choice

Which query retrieves products with a non-NULL category?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE CategoryID IS NOT NULL;

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

The query uses the IS NOT NULL operator to filter products with a non-NULL category ID.

Q26

Single Choice

Which query retrieves invoices with a non-NULL payment status?

SQL Code

SELECT InvoiceID, InvoiceDate
FROM Invoices
WHERE PaymentStatus IS NOT NULL;

SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentStatus IS NOT NULL; SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentStatus IS NULL; SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentStatus = NOT NULL;SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentStatus <> NULL;

The query uses the IS NOT NULL operator to filter invoices with a non-NULL payment status.

Q27

Single Choice

Which query retrieves customers who have a specified credit limit?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE CreditLimit IS NOT NULL;

SELECT CustomerID, CustomerName FROM Customers WHERE CreditLimit IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE CreditLimit IS NULL; SELECT CustomerID, CustomerName FROM Customers WHERE CreditLimit = NOT NULL;SELECT CustomerID, CustomerName FROM Customers WHERE CreditLimit <> NULL;

The query checks for non-NULL values in the CreditLimit column to find customers with a specified credit limit.

Q28

Single Choice

Which query retrieves orders with a non-NULL shipping address?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShippingAddress IS NOT NULL;

SELECT OrderID, OrderDate FROM Orders WHERE ShippingAddress IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShippingAddress IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShippingAddress = NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE ShippingAddress <> NULL;

The query uses the IS NOT NULL operator to filter orders with a non-NULL shipping address.

Q29

Single Choice

Which query lists products with a non-NULL supplier?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE SupplierID IS NOT NULL;

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

The query checks for non-NULL values in the SupplierID column to find products with a specified supplier.

Q30

Single Choice

Which query retrieves employees with a non-NULL hire date?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE HireDate IS NOT NULL;

SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate IS NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate = NOT NULL;SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate <> NULL;

The query uses the IS NOT NULL operator to filter employees with a non-NULL hire date.

Q31

Multiple Choice

Which query retrieves customers with a non-NULL phone number and email address?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE PhoneNumber IS NOT NULL
AND Email IS NOT NULL;

SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber IS NOT NULL AND Email IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber IS NOT NULL OR Email IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber = NOT NULL AND Email IS NOT NULL;SELECT CustomerID, CustomerName FROM Customers WHERE PhoneNumber IS NOT NULL AND Email <> NULL;

The query checks for non-NULL values in both the PhoneNumber and Email columns to find customers with specified contact details.

Q32

Multiple Choice

Which query lists products with a non-NULL price and category?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE Price IS NOT NULL
AND CategoryID IS NOT NULL;

SELECT ProductID, ProductName FROM Products WHERE Price IS NOT NULL AND CategoryID IS NOT NULL; SELECT ProductID, ProductName FROM Products WHERE Price IS NOT NULL OR CategoryID IS NOT NULL; SELECT ProductID, ProductName FROM Products WHERE Price = NOT NULL AND CategoryID IS NOT NULL;SELECT ProductID, ProductName FROM Products WHERE Price IS NOT NULL AND CategoryID <> NULL;

The query uses the IS NOT NULL operator to filter products with non-NULL values in both the Price and CategoryID columns.

Q33

Multiple Choice

Which query retrieves employees with a non-NULL hire date and salary?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE HireDate IS NOT NULL
AND Salary IS NOT NULL;

SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate IS NOT NULL AND Salary IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate IS NOT NULL OR Salary IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate = NOT NULL AND Salary IS NOT NULL;SELECT EmployeeID, EmployeeName FROM Employees WHERE HireDate IS NOT NULL AND Salary <> NULL;

The query checks for non-NULL values in both the HireDate and Salary columns to find employees with specified details.

Q34

Multiple Choice

Which query lists orders with a non-NULL ship date and order status?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShipDate IS NOT NULL
AND OrderStatus IS NOT NULL;

SELECT OrderID, OrderDate FROM Orders WHERE ShipDate IS NOT NULL AND OrderStatus IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShipDate IS NOT NULL OR OrderStatus IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShipDate = NOT NULL AND OrderStatus IS NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE ShipDate IS NOT NULL AND OrderStatus <> NULL;

The query uses the IS NOT NULL operator to filter orders with non-NULL values in both the ShipDate and OrderStatus columns.

Q35

Multiple Choice

Which query retrieves suppliers with a non-NULL contact number and address?

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE ContactNumber IS NOT NULL
AND Address IS NOT NULL;

SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL AND Address IS NOT NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL OR Address IS NOT NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber = NOT NULL AND Address IS NOT NULL;SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL AND Address <> NULL;

The query checks for non-NULL values in both the ContactNumber and Address columns to find suppliers with specified details.

Q36

Multiple Choice

Which query retrieves invoices with a non-NULL payment date and payment status?

SQL Code

SELECT InvoiceID, InvoiceDate
FROM Invoices
WHERE PaymentDate IS NOT NULL
AND PaymentStatus IS NOT NULL;

SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentDate IS NOT NULL AND PaymentStatus IS NOT NULL; SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentDate IS NOT NULL OR PaymentStatus IS NOT NULL; SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentDate = NOT NULL AND PaymentStatus IS NOT NULL;SELECT InvoiceID, InvoiceDate FROM Invoices WHERE PaymentDate IS NOT NULL AND PaymentStatus <> NULL;

The query uses the IS NOT NULL operator to filter invoices with non-NULL values in both the PaymentDate and PaymentStatus columns.

Q37

Multiple Choice

Which query retrieves products with a non-NULL description and price?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE Description IS NOT NULL
AND Price IS NOT NULL;

SELECT ProductID, ProductName FROM Products WHERE Description IS NOT NULL AND Price IS NOT NULL; SELECT ProductID, ProductName FROM Products WHERE Description IS NOT NULL OR Price IS NOT NULL; SELECT ProductID, ProductName FROM Products WHERE Description = NOT NULL AND Price IS NOT NULL;SELECT ProductID, ProductName FROM Products WHERE Description IS NOT NULL AND Price <> NULL;

The query checks for non-NULL values in both the Description and Price columns to find products with specified details.

Q38

Multiple Choice

Which query retrieves customers with a non-NULL email and credit limit?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE Email IS NOT NULL
AND CreditLimit IS NOT NULL;

SELECT CustomerID, CustomerName FROM Customers WHERE Email IS NOT NULL AND CreditLimit IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE Email IS NOT NULL OR CreditLimit IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE Email = NOT NULL AND CreditLimit IS NOT NULL;SELECT CustomerID, CustomerName FROM Customers WHERE Email IS NOT NULL AND CreditLimit <> NULL;

The query uses the IS NOT NULL operator to filter customers with non-NULL values in both the Email and CreditLimit columns.

Q39

Multiple Choice

Which query retrieves orders with a non-NULL discount and shipping date?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE Discount IS NOT NULL
AND ShipDate IS NOT NULL;

SELECT OrderID, OrderDate FROM Orders WHERE Discount IS NOT NULL AND ShipDate IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE Discount IS NOT NULL OR ShipDate IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE Discount = NOT NULL AND ShipDate IS NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE Discount IS NOT NULL AND ShipDate <> NULL;

The query checks for non-NULL values in both the Discount and ShipDate columns to find orders with specified details.

Q40

Multiple Choice

Which query retrieves suppliers with a non-NULL contact number and email address?

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE ContactNumber IS NOT NULL
AND Email IS NOT NULL;

SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL AND Email IS NOT NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL OR Email IS NOT NULL; SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber = NOT NULL AND Email IS NOT NULL;SELECT SupplierID, SupplierName FROM Suppliers WHERE ContactNumber IS NOT NULL AND Email <> NULL;

The query uses the IS NOT NULL operator to filter suppliers with non-NULL values in both the ContactNumber and Email columns.

Q41

Multiple Choice

Which query retrieves employees with a non-NULL department and salary?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE DepartmentID IS NOT NULL
AND Salary IS NOT NULL;

SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID IS NOT NULL AND Salary IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID IS NOT NULL OR Salary IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID = NOT NULL AND Salary IS NOT NULL;SELECT EmployeeID, EmployeeName FROM Employees WHERE DepartmentID IS NOT NULL AND Salary <> NULL;

The query checks for non-NULL values in both the DepartmentID and Salary columns to find employees with specified details.

Q42

Multiple Choice

Which query retrieves customers with a non-NULL address and phone number?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE Address IS NOT NULL
AND PhoneNumber IS NOT NULL;

SELECT CustomerID, CustomerName FROM Customers WHERE Address IS NOT NULL AND PhoneNumber IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE Address IS NOT NULL OR PhoneNumber IS NOT NULL; SELECT CustomerID, CustomerName FROM Customers WHERE Address = NOT NULL AND PhoneNumber IS NOT NULL;SELECT CustomerID, CustomerName FROM Customers WHERE Address IS NOT NULL AND PhoneNumber <> NULL;

The query uses the IS NOT NULL operator to filter customers with non-NULL values in both the Address and PhoneNumber columns.

Q43

Multiple Choice

Which query lists products with a non-NULL supplier and category?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE SupplierID IS NOT NULL
AND CategoryID IS NOT NULL;

SELECT ProductID, ProductName FROM Products WHERE SupplierID IS NOT NULL AND CategoryID IS NOT NULL; SELECT ProductID, ProductName FROM Products WHERE SupplierID IS NOT NULL OR CategoryID IS NOT NULL; SELECT ProductID, ProductName FROM Products WHERE SupplierID = NOT NULL AND CategoryID IS NOT NULL;SELECT ProductID, ProductName FROM Products WHERE SupplierID IS NOT NULL AND CategoryID <> NULL;

The query checks for non-NULL values in both the SupplierID and CategoryID columns to find products with specified details.

Q44

Multiple Choice

Which query retrieves orders with a non-NULL order date and shipping address?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE OrderDate IS NOT NULL
AND ShippingAddress IS NOT NULL;

SELECT OrderID, OrderDate FROM Orders WHERE OrderDate IS NOT NULL AND ShippingAddress IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE OrderDate IS NOT NULL OR ShippingAddress IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE OrderDate = NOT NULL AND ShippingAddress IS NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE OrderDate IS NOT NULL AND ShippingAddress <> NULL;

The query uses the IS NOT NULL operator to filter orders with non-NULL values in both the OrderDate and ShippingAddress columns.

Q45

Multiple Choice

Which query retrieves employees with a non-NULL phone number and address?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE PhoneNumber IS NOT NULL
AND Address IS NOT NULL;

SELECT EmployeeID, EmployeeName FROM Employees WHERE PhoneNumber IS NOT NULL AND Address IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE PhoneNumber IS NOT NULL OR Address IS NOT NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE PhoneNumber = NOT NULL AND Address IS NOT NULL;SELECT EmployeeID, EmployeeName FROM Employees WHERE PhoneNumber IS NOT NULL AND Address <> NULL;

The query checks for non-NULL values in both the PhoneNumber and Address columns to find employees with specified details.

Microsoft SQL Server Database Quiz Questions