Multiple choice technology databases

If char data type column contain number value (say 9) than condition 9>12 IS ?

  1. True

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

When comparing char columns, SQL uses lexicographic (string) comparison, not numeric. String comparison is character-by-character from left to right. '9' > '12' is True because '9' (ASCII 57) > '1' (ASCII 49). Only the first character matters: '9' > '1', so the entire comparison succeeds without looking at the '2'. This is why string columns should store numeric values as proper numeric types.

Keep practicing — related questions