Vidyalelo
MySQL · Q1002

MySQL

Programming · MySQL · question 1002

Q1002

Which operator is used to check whether the expression is "NULL"?

A.
IS NULL
Answer
B.
NOT NULL
C.
ON
D.
None of the mentioned

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about finding out how to check if a value in MySQL is empty or missing. In other words, how do we tell if a field is NULL?

NULL means the value is empty, like a blank space.

Out of the options given:

Option A: IS NULL is the correct answer! It's used specifically to check if something is NULL.

Option B: NOT NULL is used when you want to make sure that a field *cannot* be empty.

Option C: ON is used in joins, which are a way to combine data from different tables.

Option D: None of the mentioned is wrong because IS NULL is the right answer.