Pergunta de entrevista da empresa athenahealth

What is Inner Join and Self Join. Difference between clustered and non-clustered index. Difference between primary key and foreign key.