Multiple choice technology databases

Primary Index can not be

  1. Null

  2. dropped

  3. have duplicates

  4. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Once defined, a Primary Index in Teradata cannot be dropped or altered without recreating the table. However, a Primary Index can contain NULL values and can have duplicate values (in a Non-Unique Primary Index). The 'cannot be dropped' constraint is permanent and fundamental to Teradata's architecture.

Keep practicing — related questions