Test Your MySQL IS NULL Operator Knowledge with Our SQL Quiz

Progress

True / False

In MySQL, the IS NULL condition can be used to check if a column's value is NULL.

True False

The IS NULL condition is used in MySQL to check if a value in a column is NULL.

True / False

In MySQL, IS NULL is used to replace NULL values with a specified value.

True False

The IS NULL condition is used to check for NULL values, not to replace them. The IFNULL or COALESCE functions are used for replacing NULL values.

True / False

In MySQL, the expression NULL IS NULL evaluates to True.

True False

The expression NULL IS NULL checks if the value is NULL, which it is, so the result is True.

True / False

In MySQL, you can use the IS NULL condition in a WHERE clause to filter out rows with NULL values.

True False

The IS NULL condition can be used in a WHERE clause to select rows where a column's value is NULL.

True / False

In MySQL, IS NULL can be used with any data type, including text, date, and numeric.

True False

The IS NULL condition works with any data type in MySQL, including text, date, and numeric types.

True / False

In MySQL, using IS NULL in a query will significantly slow down the query performance.

True False

Using IS NULL does not significantly impact query performance as it is a simple check for the presence of NULL values.

True / False

In MySQL, you cannot use IS NULL in combination with GROUP BY and HAVING clauses.

True False

You can use IS NULL in combination with GROUP BY and HAVING clauses to group and filter aggregated results that contain NULL values.

True / False

In MySQL, the IS NULL condition can be combined with the CASE statement to perform conditional logic based on NULL values.

True False

The IS NULL condition can be used within a CASE statement to handle NULL values with conditional logic.

True / False

In MySQL, you can use an index on a column to improve the performance of queries using IS NULL.

True False

Indexes can help improve the performance of queries using IS NULL, especially if the column being checked is indexed.

Q10

True / False

In MySQL, the IS NULL condition can be used in a JOIN clause to retrieve rows with NULL values in the join condition.

True False

The IS NULL condition can be used in a JOIN clause to retrieve rows where the join condition evaluates to NULL, effectively performing an outer join to include rows with NULL values.

Q11

Single Choice

Which of the following MySQL conditions will correctly check if the name column is empty?

name = '' name = NULL name IS NULLname IS EMPTY

In MySQL, the IS NULL operator is used to check if a column's value is NULL. Using = NULL is incorrect because NULL is not a value; it represents the absence of a value

Q12

Single Choice

What does this query do?

SQL Code

Consider the following SQL query:
SELECT * FROM employees WHERE department_id IS NULL;

It selects rows where department_id is not assigned It selects rows where department_id is an empty string. It selects rows where department_id is equal to zero.It selects all rows in the employees table.

The query selects rows where the department_id is NULL, meaning the department has not been assigned to the employee.

Q13

Single Choice

Which of the following statements is correct regarding the MySQL IS NULL operator?

It is case-sensitive. It can be used to compare two NULL values. It is used to check if a column's value is NULL.It can be used interchangeably with = NULL.

The IS NULL operator specifically checks if a column's value is NULL. It cannot be used to compare two NULL values directly with = NULL.

Q14

Single Choice

Given the table orders with columns order_id, customer_id, and delivery_date, what does the following query return?

SQL Code

SELECT order_id FROM orders WHERE delivery_date IS NULL;

Orders with a delivery_date that is in the future. Orders with a delivery_date set to today's date Orders that have not been delivered yet.Orders that were canceled.

The query retrieves order_id from orders where the delivery_date is NULL, indicating that the order has not been delivered yet.

Q15

Single Choice

What is the result of the following query if the salary column contains the values NULL, 50000, and 70000?

0 1 23

The COUNT(*) function counts all rows where the salary is NULL. In this case, it will return 1 because there is one row with NULL in the salary column.

Q16

Single Choice

In MySQL, how can you select all records from the students table where the graduation_year column has no value assigned?

SELECT * FROM students WHERE graduation_year = NULL; SELECT * FROM students WHERE graduation_year IS NOT NULL; SELECT * FROM students WHERE graduation_year IS NULL;SELECT * FROM students WHERE graduation_year != NULL;

The IS NULL condition is used to find rows where graduation_year has no value assigned.

Q17

Single Choice

What will the query return if department_name is NULL?

SQL Code

Given the following SQL statement:
SELECT COALESCE(department_name, 'Unknown') FROM departments;

NULL Unknown Empty String0

The COALESCE function returns the first non-NULL value in its list. If department_name is NULL, the query will return 'Unknown'

Q18

Single Choice

Which of the following queries will correctly select products that have no price listed?

SQL Code

Consider the following products table:
product_id | product_name | price
-----------|--------------|-------
1 | Phone | 500
2 | Laptop | NULL
3 | Tablet | 300

SELECT * FROM products WHERE price = NULL; SELECT * FROM products WHERE price IS NULL; SELECT * FROM products WHERE price < 100;SELECT * FROM products WHERE price != NULL;

The correct way to check for NULL values in the price column is using the IS NULL operator.

Q19

Single Choice

How does MySQL treat NULL values when using the GROUP BY clause in the following query?

SQL Code

SELECT department_id, COUNT(*) FROM employees GROUP BY department_id;

NULL values are grouped together. NULL values are excluded from the result set. Each NULL value is treated as a unique group.NULL values cause an error in the query.

In MySQL, NULL values are grouped together when using the GROUP BY clause, meaning that all NULL values in department_id will be considered as a single group.

Q20

Single Choice

What will the following MySQL query return when run on a table inventory where some product_name entries are NULL

SQL Code

SELECT IF(product_name IS NULL, 'No Name', product_name) AS product_name FROM inventory;

All product names, with NULL replaced by 'No Name'. Only products with a name. Only products with NULL as their name.No products, as NULL cannot be replaced.

The IF function in MySQL allows conditional logic within queries. Here, it checks if product_name is NULL, and if true, it returns 'No Name'; otherwise, it returns the actual product_name.

Q21

Multiple Choice

Which query correctly retrieves records from the 'employees' table where the 'manager_id' is NULL?

SQL Code

SELECT *
FROM employees
WHERE manager_id IS NULL;

SELECT * FROM employees WHERE manager_id IS NULL; SELECT * FROM employees WHERE manager_id = NULL; SELECT * FROM employees WHERE manager_id <> NULL;SELECT * FROM employees WHERE manager_id IS NOT NULL;

The IS NULL operator is used to filter rows where the 'manager_id' column has a NULL value.

Q22

Multiple Choice

Identify the correct SQL query that retrieves records from the 'orders' table where the 'shipped_date' is NULL.

SQL Code

SELECT *
FROM orders
WHERE shipped_date IS NULL;

SELECT * FROM orders WHERE shipped_date IS NULL; SELECT * FROM orders WHERE shipped_date = NULL; SELECT * FROM orders WHERE shipped_date <> NULL;SELECT * FROM orders WHERE shipped_date IS NOT NULL;

The IS NULL operator filters rows where the 'shipped_date' column has a NULL value.

Q23

Multiple Choice

Which query correctly selects records from the 'products' table where the 'discount' column is NULL?

SQL Code

SELECT *
FROM products
WHERE discount IS NULL;

SELECT * FROM products WHERE discount IS NULL; SELECT * FROM products WHERE discount = NULL; SELECT * FROM products WHERE discount <> NULL;SELECT * FROM products WHERE discount IS NOT NULL;

The IS NULL operator is used to filter rows where the 'discount' column has a NULL value.

Q24

Multiple Choice

Determine the correct SQL query that retrieves records from the 'customers' table where the 'phone_number' is NULL.

SQL Code

SELECT *
FROM customers
WHERE phone_number IS NULL;

SELECT * FROM customers WHERE phone_number IS NULL; SELECT * FROM customers WHERE phone_number = NULL; SELECT * FROM customers WHERE phone_number <> NULL;SELECT * FROM customers WHERE phone_number IS NOT NULL;

The IS NULL operator filters rows where the 'phone_number' column has a NULL value.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where the 'last_restocked' date is NULL?

SQL Code

SELECT *
FROM inventory
WHERE last_restocked IS NULL;

SELECT * FROM inventory WHERE last_restocked IS NULL; SELECT * FROM inventory WHERE last_restocked = NULL; SELECT * FROM inventory WHERE last_restocked <> NULL;SELECT * FROM inventory WHERE last_restocked IS NOT NULL;

The IS NULL operator is used to filter rows where the 'last_restocked' date is NULL.

Q26

Multiple Choice

Which query correctly retrieves records from the 'employees' table where the 'termination_date' is NULL?

SQL Code

SELECT *
FROM employees
WHERE termination_date IS NULL;

SELECT * FROM employees WHERE termination_date IS NULL; SELECT * FROM employees WHERE termination_date = NULL; SELECT * FROM employees WHERE termination_date <> NULL;SELECT * FROM employees WHERE termination_date IS NOT NULL;

The IS NULL operator filters rows where the 'termination_date' column has a NULL value.

Q27

Multiple Choice

Determine the correct SQL query that selects records from the 'payments' table where the 'transaction_id' is NULL.

SQL Code

SELECT *
FROM payments
WHERE transaction_id IS NULL;

SELECT * FROM payments WHERE transaction_id IS NULL; SELECT * FROM payments WHERE transaction_id = NULL; SELECT * FROM payments WHERE transaction_id <> NULL;SELECT * FROM payments WHERE transaction_id IS NOT NULL;

The IS NULL operator is used to filter rows where the 'transaction_id' column has a NULL value.

Q28

Multiple Choice

Which SQL query retrieves records from the 'clients' table where the 'email' field is NULL?

SQL Code

SELECT *
FROM clients
WHERE email IS NULL;

SELECT * FROM clients WHERE email IS NULL; SELECT * FROM clients WHERE email = NULL; SELECT * FROM clients WHERE email <> NULL;SELECT * FROM clients WHERE email IS NOT NULL;

The IS NULL operator filters rows where the 'email' field has a NULL value.

Q29

Multiple Choice

Identify the correct query that retrieves records from the 'contracts' table where the 'end_date' is NULL.

SQL Code

SELECT *
FROM contracts
WHERE end_date IS NULL;

SELECT * FROM contracts WHERE end_date IS NULL; SELECT * FROM contracts WHERE end_date = NULL; SELECT * FROM contracts WHERE end_date <> NULL;SELECT * FROM contracts WHERE end_date IS NOT NULL;

The IS NULL operator is used to filter rows where the 'end_date' column has a NULL value.

Q30

Multiple Choice

Which SQL query correctly retrieves records from the 'students' table where the 'graduation_date' is NULL?

SQL Code

SELECT *
FROM students
WHERE graduation_date IS NULL;

SELECT * FROM students WHERE graduation_date IS NULL; SELECT * FROM students WHERE graduation_date = NULL; SELECT * FROM students WHERE graduation_date <> NULL;SELECT * FROM students WHERE graduation_date IS NOT NULL;

The IS NULL operator is used to filter rows where the 'graduation_date' column has a NULL value.

MySQL Database Quiz Questions