Multiple choice technology databases

Which two of the following statements are true regarding a Primary Index are accurate?

  1. A primary Index is a physical mechanism.

  2. There is a limit to the number of columns in a Primary Index.

  3. A Primary Index requires uniqueness

  4. A Primary Index value can not be null.
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

A Primary Index is indeed a physical mechanism used for data distribution and retrieval in Teradata, determining which AMP stores each row. There is a practical limit on the number of columns that can be in a Primary Index (typically around 16 columns depending on the version). However, a Primary Index does not require uniqueness (that would be a UPI), and Primary Index values can be null.

Keep practicing — related questions