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

Progress

True / False

The IS NULL operator can be used to check if a column has a NULL value.

True False

The IS NULL operator is used to check for NULL values in a column.

True / False

The IS NULL operator can be used with the WHERE clause.

True False

The IS NULL operator is often used with the WHERE clause to filter rows with NULL values.

True / False

The IS NULL operator can be used to check if a column does not have a NULL value.

True False

To check for non-NULL values, the IS NOT NULL operator is used instead of IS NULL.

True / False

Using IS NULL in a SELECT statement will return all rows where the specified column has a NULL value.

True False

The IS NULL operator in a SELECT statement filters and returns rows with NULL values in the specified column.

True / False

The IS NULL operator can be used to compare two columns for NULL values.

True False

The IS NULL operator checks for NULL values in a single column, not for comparing two columns.

True / False

IS NULL operator can be used in the ORDER BY clause.

True False

The IS NULL operator is used in the WHERE clause, not in the ORDER BY clause.

True / False

You can use IS NULL in a JOIN condition.

True False

The IS NULL operator can be used in JOIN conditions to check for NULL values in columns involved in the JOIN.

True / False

IS NULL can be combined with AND and OR operators in SQL queries.

True False

The IS NULL operator can be combined with AND and OR operators to create more complex filtering conditions.

True / False

Using IS NULL in a GROUP BY clause is valid SQL syntax.

True False

The IS NULL operator is not used in the GROUP BY clause; it is used in the WHERE clause.

Q10

True / False

IS NULL operator can be used to update rows with NULL values.

True False

The IS NULL operator can be used in the WHERE clause of an UPDATE statement to update rows with NULL values.

Q11

True / False

The IS NULL operator can be used in a DELETE statement.

True False

The IS NULL operator can be used in the WHERE clause of a DELETE statement to delete rows with NULL values.

Q12

True / False

IS NULL operator can be used in subqueries.

True False

The IS NULL operator can be used in subqueries to filter results based on NULL values.

Q13

True / False

You can use IS NULL to check for NULL values in a UNION query.

True False

The IS NULL operator can be used in each SELECT statement of a UNION query to check for NULL values.

Q14

True / False

The IS NULL operator can only be used with numeric data types.

True False

The IS NULL operator can be used with any data type to check for NULL values.

Q15

True / False

IS NULL can be used to filter NULL values in a result set.

True False

The IS NULL operator can be used to filter and retrieve rows with NULL values in a result set.

Q16

Single Choice

Which query returns all employees who do not have a manager?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE ManagerID IS NULL;

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

The query checks for NULL values in the ManagerID column to find employees without a manager.

Q17

Single Choice

Which query retrieves orders without a shipping date?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShippingDate IS NULL;

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

The query uses the IS NULL operator to filter orders where the ShippingDate column has NULL values.

Q18

Single Choice

Which query lists all products without a supplier?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE SupplierID IS NULL;

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

The query checks for NULL values in the SupplierID column to find products without a supplier.

Q19

Single Choice

Which query returns customers with no contact number?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE ContactNumber IS NULL;

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

The query uses the IS NULL operator to filter customers where the ContactNumber column has NULL values.

Q20

Single Choice

Which query retrieves invoices without a payment date?

SQL Code

SELECT InvoiceID, InvoiceDate
FROM Invoices
WHERE PaymentDate IS NULL;

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

The query checks for NULL values in the PaymentDate column to find invoices without a payment date.

Q21

Single Choice

Which query retrieves employees with no assigned department?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE DepartmentID IS NULL;

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

The query uses the IS NULL operator to filter employees without an assigned department.

Q22

Single Choice

Which query lists orders that have not been assigned a shipping address?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShippingAddress IS NULL;

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

The query checks for NULL values in the ShippingAddress column to find orders without a shipping address.

Q23

Single Choice

Which query retrieves students without a registered email?

SQL Code

SELECT StudentID, StudentName
FROM Students
WHERE Email IS NULL;

SELECT StudentID, StudentName FROM Students WHERE Email IS NULL; SELECT StudentID, StudentName FROM Students WHERE Email IS NOT NULL; SELECT StudentID, StudentName FROM Students WHERE Email = NULL;SELECT StudentID, StudentName FROM Students WHERE Email <> NULL;

The query uses the IS NULL operator to filter students without a registered email.

Q24

Single Choice

Which query returns suppliers without a contact person?

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE ContactPerson IS NULL;

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

The query checks for NULL values in the ContactPerson column to find suppliers without a contact person.

Q25

Single Choice

Which query lists projects without a start date?

SQL Code

SELECT ProjectID, ProjectName
FROM Projects
WHERE StartDate IS NULL;

SELECT ProjectID, ProjectName FROM Projects WHERE StartDate IS NULL; SELECT ProjectID, ProjectName FROM Projects WHERE StartDate IS NOT NULL; SELECT ProjectID, ProjectName FROM Projects WHERE StartDate = NULL;SELECT ProjectID, ProjectName FROM Projects WHERE StartDate <> NULL;

The query uses the IS NULL operator to filter projects without a start date.

Q26

Single Choice

Which query retrieves records with NULL values in multiple columns?

SQL Code

SELECT OrderID, CustomerID
FROM Orders
WHERE ShippingDate IS NULL
AND PaymentDate IS NULL;

SELECT OrderID, CustomerID FROM Orders WHERE ShippingDate IS NULL AND PaymentDate IS NULL; SELECT OrderID, CustomerID FROM Orders WHERE ShippingDate IS NOT NULL AND PaymentDate IS NULL; SELECT OrderID, CustomerID FROM Orders WHERE ShippingDate IS NULL AND PaymentDate IS NOT NULL;SELECT OrderID, CustomerID FROM Orders WHERE ShippingDate IS NOT NULL AND PaymentDate IS NOT NULL;

The query checks for NULL values in both the ShippingDate and PaymentDate columns.

Q27

Single Choice

Which query returns employees without a specified role?

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE Role IS NULL;

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

The query uses the IS NULL operator to filter employees without a specified role.

Q28

Single Choice

Which query retrieves invoices with NULL values in critical columns?

SQL Code

SELECT InvoiceID, TotalAmount
FROM Invoices
WHERE TotalAmount IS NULL
OR PaymentDate IS NULL;

SELECT InvoiceID, TotalAmount FROM Invoices WHERE TotalAmount IS NULL OR PaymentDate IS NULL; SELECT InvoiceID, TotalAmount FROM Invoices WHERE TotalAmount IS NOT NULL OR PaymentDate IS NULL; SELECT InvoiceID, TotalAmount FROM Invoices WHERE TotalAmount IS NULL OR PaymentDate IS NOT NULL;SELECT InvoiceID, TotalAmount FROM Invoices WHERE TotalAmount IS NOT NULL OR PaymentDate IS NOT NULL;

The query checks for NULL values in the TotalAmount or PaymentDate columns using the IS NULL operator.

Q29

Single Choice

Which query lists customers without a postal code?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE PostalCode IS NULL;

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

The query uses the IS NULL operator to filter customers without a postal code.

Q30

Single Choice

Which query retrieves suppliers with NULL values in their address?

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE Address IS NULL;

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

The query checks for NULL values in the Address column to find suppliers with incomplete addresses.

Q31

Multiple Choice

Which of the following queries retrieves orders with NULL values in both the ShippingDate and DeliveryDate columns? (Choose all that apply)

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShippingDate IS NULL
AND DeliveryDate IS NULL;

SELECT OrderID, OrderDate FROM Orders WHERE ShippingDate IS NULL AND DeliveryDate IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShippingDate IS NOT NULL AND DeliveryDate IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShippingDate IS NULL AND DeliveryDate IS NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE ShippingDate IS NULL OR DeliveryDate IS NULL;

The query checks for NULL values in both the ShippingDate and DeliveryDate columns.

Q32

Multiple Choice

Which of the following queries lists customers who do not have a contact number? (Choose all that apply)

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE ContactNumber IS NULL;

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

The query uses the IS NULL operator to filter customers without a contact number.

Q33

Multiple Choice

Which of the following queries returns products without a specified price? (Choose all that apply)

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE Price IS NULL;

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

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

Q34

Multiple Choice

Which of the following queries retrieves employees with NULL values in the ManagerID column? (Choose all that apply)

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE ManagerID IS NULL;

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

The query uses the IS NULL operator to filter employees with NULL values in the ManagerID column.

Q35

Multiple Choice

Which of the following queries lists orders without a specified shipping method? (Choose all that apply)

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE ShippingMethod IS NULL;

SELECT OrderID, OrderDate FROM Orders WHERE ShippingMethod IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShippingMethod IS NOT NULL; SELECT OrderID, OrderDate FROM Orders WHERE ShippingMethod IS NULL OR PaymentMethod IS NULL;SELECT OrderID, OrderDate FROM Orders WHERE ShippingMethod IS NULL AND PaymentMethod IS NULL;

The query checks for NULL values in the ShippingMethod column to find orders without a specified shipping method.

Q36

Multiple Choice

Which of the following queries retrieves students without a registered address? (Choose all that apply)

SQL Code

SELECT StudentID, StudentName
FROM Students
WHERE Address IS NULL;

SELECT StudentID, StudentName FROM Students WHERE Address IS NULL; SELECT StudentID, StudentName FROM Students WHERE Address IS NOT NULL; SELECT StudentID, StudentName FROM Students WHERE Address IS NULL AND Email IS NULL;SELECT StudentID, StudentName FROM Students WHERE Address IS NULL OR Email IS NULL;

The query uses the IS NULL operator to filter students without a registered address.

Q37

Multiple Choice

Which of the following queries returns suppliers with NULL values in the ContactNumber column? (Choose all that apply)

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE ContactNumber IS NULL;

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

The query checks for NULL values in the ContactNumber column to find suppliers without a contact number.

Q38

Multiple Choice

Which of the following queries lists projects without a specified end date? (Choose all that apply)

SQL Code

SELECT ProjectID, ProjectName
FROM Projects
WHERE EndDate IS NULL;

SELECT ProjectID, ProjectName FROM Projects WHERE EndDate IS NULL; SELECT ProjectID, ProjectName FROM Projects WHERE EndDate IS NOT NULL; SELECT ProjectID, ProjectName FROM Projects WHERE EndDate IS NULL AND StartDate IS NULL;SELECT ProjectID, ProjectName FROM Projects WHERE EndDate IS NULL OR StartDate IS NULL;

The query uses the IS NULL operator to filter projects without a specified end date.

Q39

Multiple Choice

Which of the following queries retrieves orders with NULL values in critical columns? (Choose all that apply)

SQL Code

SELECT OrderID, TotalAmount
FROM Orders
WHERE TotalAmount IS NULL
OR PaymentDate IS NULL;

SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount IS NULL OR PaymentDate IS NULL; SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount IS NOT NULL OR PaymentDate IS NULL; SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount IS NULL OR PaymentDate IS NOT NULL;SELECT OrderID, TotalAmount FROM Orders WHERE TotalAmount IS NOT NULL OR PaymentDate IS NOT NULL;

The query checks for NULL values in the TotalAmount or PaymentDate columns using the IS NULL operator.

Q40

Multiple Choice

Which of the following queries lists employees without a specified department or manager? (Choose all that apply)

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE DepartmentID IS NULL
OR ManagerID IS NULL;

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

The query checks for NULL values in both the DepartmentID and ManagerID columns.

Q41

Multiple Choice

Which of the following queries retrieves customers who do not have an email address or a phone number? (Choose all that apply)

SQL Code

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

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

The query checks for NULL values in either the Email or PhoneNumber columns using the IS NULL operator.

Q42

Multiple Choice

Which of the following queries lists suppliers who do not have a contact person or contact number? (Choose all that apply)

SQL Code

SELECT SupplierID, SupplierName
FROM Suppliers
WHERE ContactPerson IS NULL
OR ContactNumber IS NULL;

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

The query uses the IS NULL operator to filter suppliers without a contact person or contact number.

Q43

Multiple Choice

Which of the following queries returns products without a specified category or price? (Choose all that apply)

SQL Code

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

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

The query checks for NULL values in both the CategoryID and Price columns using the IS NULL operator.

Q44

Multiple Choice

Which of the following queries lists orders without a specified total amount or payment date? (Choose all that apply)

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE TotalAmount IS NULL
OR PaymentDate IS NULL;

SELECT OrderID, OrderDate FROM Orders WHERE TotalAmount IS NULL OR PaymentDate IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE TotalAmount IS NOT NULL OR PaymentDate IS NULL; SELECT OrderID, OrderDate FROM Orders WHERE TotalAmount IS NULL AND PaymentDate IS NOT NULL;SELECT OrderID, OrderDate FROM Orders WHERE TotalAmount IS NOT NULL AND PaymentDate IS NOT NULL;

The query uses the IS NULL operator to filter orders without a specified total amount or payment date.

Q45

Multiple Choice

Which of the following queries retrieves employees who do not have a department or job title? (Choose all that apply)

SQL Code

SELECT EmployeeID, EmployeeName
FROM Employees
WHERE Department IS NULL
OR JobTitle IS NULL;

SELECT EmployeeID, EmployeeName FROM Employees WHERE Department IS NULL OR JobTitle IS NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE Department IS NOT NULL OR JobTitle IS NULL; SELECT EmployeeID, EmployeeName FROM Employees WHERE Department IS NULL AND JobTitle IS NOT NULL;SELECT EmployeeID, EmployeeName FROM Employees WHERE Department IS NOT NULL AND JobTitle IS NOT NULL;

The query checks for NULL values in the Department or JobTitle columns using the IS NULL operator.

Microsoft SQL Server Database Quiz Questions