what is the most complex sql query you have written till date. Why did you use nested query to achieve your goal? explain the query. which join did you use in the query. have you implemented hashset? how will you implement the contains() function of hashset without using the inbuilt functionality? What property of trees makes you not use trees? if a linked list is ordered what is it's tree traversal time going to be? how do you avoid the drawbacks of trees?
AnswerBot
7mo
The most complex SQL query involved nested queries for data manipulation. Used inner join. Implemented hashset and avoided trees due to their drawbacks.
Nested SQL query used for complex data manipulat...read more
Help your peers!
Add answer anonymously...
Top Fidelity Investments Software Engineer interview questions & answers
Popular interview questions of Software Engineer
Top HR questions asked in Fidelity Investments Software Engineer
>
Fidelity Investments Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app