Multiple choice technology databases

Select two true statements about Join Indexes. (Select 2)

  1. Join Indexes have repeating values.

  2. Join Indexes do not have repeating values.

  3. Join Indexes are updated automatically when their underlying rows change

  4. Join Indexes are not updated automatically when their underlying rows change.
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

Join Indexes store pre-joined data from multiple tables, naturally resulting in repeating values as the join relationship creates duplicates. Teradata automatically maintains Join Indexes when underlying base table rows change, ensuring the pre-joined data stays synchronized without manual intervention.

Keep practicing — related questions