Multiple choice technology databases

What is contained in a USI subtable? (Select 3)

  1. The buckets containing the AMP numbers where the data is stored.

  2. The USI column value

  3. The Row ID of the base row.

  4. The Secondary Index Row ID.

  5. The Integer Type of all Value-Ordered NUSIs.
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

A USI (Unique Secondary Index) subtable stores the index value itself, the RowID pointing to the base table row, and the secondary index's own RowID for internal navigation. AMP number buckets are part of the hash distribution mechanism, not stored in USI subtables. Value-ordered NUSIs have different structures than USIs.

Keep practicing — related questions