Multiple choice technology databases

While creating a table Primary key is defined but not Primary Index, then this will be considered as Primary Index

  1. Secondary Index

  2. First unique column in the table

  3. Primary key

  4. First non-unique coulmn in the table
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When you define a PRIMARY KEY but no explicit PRIMARY INDEX, Teradata automatically uses the PRIMARY KEY columns as the PRIMARY INDEX. This is a default behavior - the primary index ensures unique row distribution. It won't default to the first unique column or any other heuristic.

Keep practicing — related questions