What is an alternate key?
-
The relationship between more than one entity which has more than one attribute
-
An attribute that cannot easily identify a record, but can easily viewed as a field
-
An attribute, other than primary key, that can be used to identify an instance of an entity
-
A non-distinguishable primary key which is not used to identify fields or records
-
A primary key with two or more columns on a non-clustered index
Reveal answer
Fill a bubble to check yourself
C
Correct answer
Explanation
An alternate key is any candidate key in a database table that is not selected as the primary key. It still uniquely identifies each row or entity instance. The distractors describe relationships, non-unique attributes, or complex primary/non-clustered index combinations that do not define an alternate key.