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 attribute that can uniquely identify an entity instance, other than the primary key. It provides an alternative way to access records and must have the uniqueness property of a key, even though it's not designated as the primary identifier.