For SQL Programming/Analytical questions Some of the standard ones are:
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)