Accenture Interview Question

DBMS questions: the difference between foreign key, primary key and candidate key. Also, questions based on SQL.