CGI Interview Question

Difference between C and core java, Primary key , foreign key , asked me to write table of a user input number, project was on j2ee , so asked basic db connections and asked me to write a query for all employee who work in group A.And some more which I can not remember , after giving the Interview I was so sure , but this pathetic HR just destroyed my dreams of joining CGI