Query Interview Questions | Glassdoor

Query Interview Questions

8

interview questions shared by candidates

Query Interview Questions

Sort: Relevance Popular Date

How do you check the performance of a SQL table and optimize it.

1 Answer

EXPLAIN is the way to go to check for performance improvements and optimization is mostly dependent on the schema design in the beginning consisting of of adding correct accurate indexes keeping a track of the space requirements for the index as well.

In a typical database query, how would you speed up an sql query that consisted of many conditions ANDED (&&) together?

2 Answers

Are you a good worker?

1 Answer

Write an algorithm to find out the price for a keyword of an item based on the values present in the existing tables. He gave me 2 tables and some columns with item details. Keywords to search for those items etc.. The keywords can have multiple words. For example if you have existing high volume keywords in the the table like iPOD with a certain price then how much price should be the phrase "iPOD Touch 8gb" (a potential low volume keyword).

1 Answer

Write a query that returns the first & last names (concatenated) of employees who have at least two direct reports and have been with the organization at least two years but not more than five; ordered last name

What SQL programming have you done? Did you query? What types of databases did you use? How much Access experience do you have? Was it gooey?

1 Answer

Database queries based on an assumed system

None of the questions were unexpected, at least for any candidate applying for this job. I definitely felt I could have answered few questions better.

4 Answers
18 of 8 Interview Questions