Multiple choice technology databases

Teradata table will have ------ Primary Index

  1. Many

  2. Two

  3. One

  4. 64

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Teradata requires exactly one Primary Index per table. This PI (which can be single-column or composite) determines how rows are distributed across AMPs. A table cannot have multiple PIs or zero PIs - the system uses this single PI for all data distribution and retrieval operations.