interview questions shared by candidates
How do you check the performance of a SQL table and optimize it.
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.
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).
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