Technical Analyst Interview Questions

4,549 technical analyst interview questions shared by candidates

The first question was from dbms, he asked me what is the use of select keyword Then he gave me a simple query Then he asked me if I had to select the name and salary of different employees based on their postitions in the company like all the names and salary of managers and clerks should be displayed seperately. So here we can use group by clause to differentiate all employees salary and name. Select name, salary, position from tablename group by (position) Then he asked me to sort all the sorting algorithms according to their time complexities Then he asked me to differentiate between bubble sort and merge sort and do we use bubble sort instead of merge sort frequently even if it consumes less time . I was not able to answer this but the answer would be the merge sort algorithm has higher space complexity which makes it impractical
avatar

Technical Analyst

Interviewed at Deloitte

3.8
Sep 15, 2022

The first question was from dbms, he asked me what is the use of select keyword Then he gave me a simple query Then he asked me if I had to select the name and salary of different employees based on their postitions in the company like all the names and salary of managers and clerks should be displayed seperately. So here we can use group by clause to differentiate all employees salary and name. Select name, salary, position from tablename group by (position) Then he asked me to sort all the sorting algorithms according to their time complexities Then he asked me to differentiate between bubble sort and merge sort and do we use bubble sort instead of merge sort frequently even if it consumes less time . I was not able to answer this but the answer would be the merge sort algorithm has higher space complexity which makes it impractical

Viewing 1621 - 1630 interview questions

Glassdoor has 4,549 interview questions and reports from Technical analyst interviews. Prepare for your interview. Get hired. Love your job.