Which among the following data types can be used with "Range Condition"?

Solution (By Examveda Team)

This question asks about data types in MySQL that can be used with a "Range Condition". A range condition is a way to filter data based on a range of values. For example, you could find all customers with ages between 20 and 30, or all orders placed between January 1st and March 31st.
Let's look at the options:
Option A: Numeric data type
Numeric data types like INT, FLOAT, and DECIMAL represent numbers. You can definitely use range conditions with these data types, like "age BETWEEN 20 AND 30".
Option B: Temporal data type
Temporal data types like DATE, TIME, and DATETIME represent dates and times. You can also use range conditions with these data types, like "order_date BETWEEN '2023-01-01' AND '2023-03-31'".
Option C: String data type
String data types like VARCHAR and TEXT represent text. While you can use range conditions with string data types, it's usually not as common or practical. You could technically filter based on the alphabetical order of strings, but it's not as useful as filtering by numeric or temporal ranges.
Option D: Both Numeric and Temporal data type
This is the correct answer! Both numeric and temporal data types can be used with range conditions. You can filter data based on ranges of numbers and dates.