Q781
What does the expression '2 BETWEEN 2 AND 5' result in?
A.
True
AnswerB.
False
C.
-1
D.
2
Answer: Option A
Solution
Answer: Option A
Solution:
This question is about how MySQL uses the BETWEEN operator. The BETWEEN operator checks if a value falls within a specific range.
In this case, we have:
'2 BETWEEN 2 AND 5'
This expression means: "Is the value 2 between 2 and 5 (inclusive)?".
Since 2 is indeed between 2 and 5, the expression evaluates to True.
Therefore, the correct answer is Option A: True.