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

In Teradata, if a Primary Key is defined but no Primary Index is specified during table creation, the system automatically uses the Primary Key as the Primary Index. The Primary Index determines data distribution across AMPs (Access Module Processors). Options A, B, and D are incorrect - it doesn't default to secondary index, first unique column, or first non-unique column.

Keep practicing — related questions