Examveda

What does comparing a known value with NULL result into?

A. zero

B. a positive value

C. a negative value

D. null

Answer: Option D

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous