Which describes BETWEEN in criteria?

Which describes BETWEEN in criteria?

• A. Exclusive range
• B. Inclusive range
• C. Wildcard match
• D. Not equal

Answer: (B)

Between defines an inclusive range: it includes both the lower and upper bounds. When you filter for values between a lower limit and an upper limit, you’ll get all values that lie within that span, including the endpoints. For example, a criterion like between 50 and 100 includes 50, 100, and everything in between. If endpoints were to be excluded, you’d use strict inequalities (greater than with the lower bound and less than the upper bound). The other options describe different concepts: an exclusive range would exclude the endpoints; wildcard match uses pattern characters to compare strings; not equal checks whether a value differs from a specific value, not a range.

Between defines an inclusive range: it includes both the lower and upper bounds. When you filter for values between a lower limit and an upper limit, you’ll get all values that lie within that span, including the endpoints. For example, a criterion like between 50 and 100 includes 50, 100, and everything in between.

If endpoints were to be excluded, you’d use strict inequalities (greater than with the lower bound and less than the upper bound). The other options describe different concepts: an exclusive range would exclude the endpoints; wildcard match uses pattern characters to compare strings; not equal checks whether a value differs from a specific value, not a range.