Maximus Infoware interview question

SQL query , join , primary key , foreign key , unique