Teradata Vantage Certified Associate — Question 28

Which statement is true about both Primary Key and Primary Index?

Answer options

• A. They are hashed.
• B. They must be defined.
• C. They are the same concept.
• D. They can be made up of multiple columns.

Correct answer: D

Explanation

The correct answer is D because both Primary Keys and Primary Indexes can indeed consist of multiple columns. Option A is incorrect as they aren't necessarily hashed, option B is misleading since not all databases require them to be explicitly defined, and option C is false since they refer to different concepts despite some similarities.