Difference between Primary Key, Unique Key and candidate key

Question

What is difference between Primary Key, Unique Key and candidate key?

Answer 1

Candidate key is a minimal (i.e. irreducible) key, unique key is a pleonasm, and primary key is an obsoleted concept still surviving from the days when people thought it possible for one key to be "more unique" than any of the others.