Domanda di colloquio di Caresoft Consultancy

Simple sql basic questions like What is primary key, joins, foreign key, view, group by, order by? Difference between where and having clause? What is index? The interviewer will keep on asking questions until you fail to answer or answer wrongly Then they make you sit on a system using ms sql server in which you have to perform basic sql queries. Mostly using joins, creating table, inserting values in table. When there will concat, in ms sql server there is no concat use + symbol