Database Consultant Interview Questions

5,608 database consultant interview questions shared by candidates

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.
avatar

Associate Database Developer

Interviewed at Media.net

3.5
Jun 24, 2016

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 4841 - 4850 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 5,608 interview questions and reports from Database consultant interviews. Prepare for your interview. Get hired. Love your job.