Q644
What will be the output of the following MySQL statement "Null AND Null"?
A.
True
B.
Null
AnswerC.
False
D.
None of the mentioned
Answer: Option B
Solution
Answer: Option B
Solution:
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.