They asked me basic SQL server related questions. Scenario based and theory based questions.
Senior Database Developer Interview Questions
5,219 senior database developer interview questions shared by candidates
How would you assess your current SQL skill level and why?
What has been your most difficult data analysis task/project?
In the event of ... what would you do and why? What lead you to that decision?
What kind of an opportunity are you looking for?
Dataabase Architecture
Not sure of a question they asked, basic dba questions.
Why do you want this position?
most questions about my background and what i did in my previous role. couple more technical questions
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.
Viewing 4501 - 4510 interview questions