Multiple choice technology databases

Total no of index in the user tables

  1. 250

  2. 255

  3. 2065

  4. 1026
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In older versions of Sybase, the maximum number of indexes per user table was 250 (one clustered index plus 249 non-clustered indexes). This limit was increased in later versions. Option B (255) is close but not the standard limit for these older versions. The other values (2065, 1026) are not standard Sybase index limits. This is version-specific knowledge.

Keep practicing — related questions