Multiple choice technology databases

CAN WE SPECIFY VARCHAR DATATYPE FOR THE PARTITIONING KEY IN INTERVAL PARTITIONING TECHNIQUE

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Interval partitioning requires the partitioning key to be a numeric or date data type. VARCHAR and other string types cannot be used because interval partitioning needs to calculate mathematical intervals (like 'INTERVAL(1) MONTH' or 'INTERVAL(100) NUM') to automatically create new partitions. String columns don't support this arithmetic.

Keep practicing — related questions