If both the upper and lower bounds are known for a range when constructing a Case expression, it is best to use the ____ keyword in identifying the range.
A) From
B) Is
C) To
D) Range

Question

Quizplus · Accepted Answer

When both upper and lower bounds are known, it is best to use the "To" keyword to indicate the range. For example: 
``` 
case expression 
when 1..10 then "Between 1 and 10" 
when 11..20 then "Between 11 and 20" 
else "Something else" 
end 
``` 
Here, the range for the first condition is from 1 to 10 and the range for the second condition is from 11 to 20.

If Both the Upper and Lower Bounds Are Known for a Range