Multiple choice technology databases

What is the limitation on the Secondary indicies for a database?

  1. 255

  2. 1000

  3. No Limit

  4. 32
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The limit of 1000 secondary indices is a specific constraint in database systems like IMS. This restriction balances database performance with indexing capabilities. The exact limit varies by DBMS, but 1000 represents a practical maximum for maintaining acceptable performance in enterprise database environments.

Keep practicing — related questions