Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 7 of 78

Simple Queries in SQL — Question 7

Back to all questions
7
Question

Question 7

Assertion. Both BETWEEN and IN operators can choose from a list of values.

Reason. The value ranges and a list of values are interpreted in the same way in SQL.

Answer

(c)

Assertion is true but Reason is false.

Explanation
Both BETWEEN and IN operators can select values from a list. The BETWEEN operator defines a range of values into which column values must fall to make the condition true. This range includes both lower and upper values. In contrast, the IN operator is used to specify a list of values. It selects values that match any value in the given list of values. Therefore, while both operators involve selecting values from a list, they operate differently in SQL, distinguishing between value ranges and specific value lists.