Examveda

What will be the output of the following MySQL statement "Null AND Null"?

A. True

B. Null

C. False

D. None of the mentioned

Answer: Option B

Solution (By Examveda Team)

This question tests your understanding of how MySQL handles NULL values in logical operations.

NULL in MySQL represents an unknown or missing value.

When you use AND with NULL, the result is always NULL. This is because MySQL cannot determine if a comparison with NULL is true or false, so it returns NULL.

Therefore, the correct answer is Option B: Null.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous