What is Indexes? And there types. Difference between truncate and delete. Local and global temperory table. Recursive cte. Find 2nd highest salary. Find 2nd highest no in array .(Data structure) Difference between stored procedure and function. What are the types of stored function? Basically this questions depends upon person to person. Anything they can ask. But there main interest was in data structures algo and query optimisation. Although you have sound knowledge of Database you should know Data structure and query optimisation.
