Multiple choice technology databases

Enum values are stored accodring to their index numbers?

  1. True

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

ENUM values are stored as strings in the database, not as their underlying index numbers. While ENUM types do have an internal numeric index (1, 2, 3...), the actual storage uses the string representation. This is why ALTER TABLE can add new ENUM values without affecting existing data; the string value is what's persisted.

Keep practicing — related questions