Vidyalelo
MySQL · Q762

MySQL

Programming · MySQL · question 762

Q762

What does comparing a known value with NULL result into?

A.
zero
B.
a positive value
C.
a negative value
D.
null
Answer

Answer: Option D

Solution

Answer: Option D
Solution:
This question is about how MySQL handles comparing a value with NULL. Remember, NULL in databases means "unknown" or "missing" value.

When you compare a known value (like a number or text) with NULL, the result is always NULL. This is because you can't really determine if an unknown value is equal to, greater than, or less than something known.

So, the correct answer is Option D: null.