Multiple choice technology mainframe

Maximum length of columns in a table?

  1. 32

  2. 255

  3. 256

  4. Infinite
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Standard SQL allows up to 256 columns per table in a single table definition. This limit varies by database system (Oracle allows 1000, MySQL varies by storage engine), but 256 is a commonly cited baseline in SQL standards and older RDBMS implementations. 32 and 255 are too low, and no system allows truly infinite columns.

Keep practicing — related questions