My company's interviews are almost purely knowledge-interrogation. Some candidates have literally walked out or reverted to a bitter attitude when getting stumped on easy-to-moderate questions.
1) How to Find top 3 maximum values in a column (ANS using TOP clause with ASC)
2) Reverse the characters of a name and print them out (If name is Jack -> Then output shall be kcaJ)
3) Write a query to Find and eliminate duplicate values (i.e. one sol', would be to use Group BY, HAVING COUNT(*)>1 Clause)
4) Print results from two tables having uncommon values using JOINS(If TabA has 1,2,3,4 Values and TabB has Values 2,3,4,5,6 only 1 and 6 should be the output)(This would demonstrate knowledge of JOINS)
My company regularly asks questions like these. Haven't heard about anything of the #2 type being asked (string manipulation). My boss doesn't like candidates that knows too much about cursors though.
1.Referentail integrity
2.Types of Indexes(Perfermence Wise Which is better)
3.Types of Joins
4.What are temperory tables.(perfermence wise cursors r Temperory Tables which are better)
5.What is CTE(Common Table Expression) in Sql Server.
6.What are Derived Tables.
7.What are Views.
8.Diff between Stored Procedures and Stored Functions.
9.Types of triggers.
10.Types of Cursors.
These get asked a lot.