CCS Global Tech SQL Server Developer interview questions

Very basic sql questions, like what is a constraint, primary key, how to join tables, inner join, left outer join, what is the difference and some basic programming question, what is an object, how to inherit from a parent class, write a program for prime number, so this is basically the type of questions you will encounter depending on what you have written on your resume

What is the difference between an inner join, left join, outer join and right join.