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
1y
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...
Fidelity Investments Software Engineer interview questions & answers
A Software Engineer was asked Q. Given a string, find the character with the maximum frequency.
A Software Engineer was asked Q. Write the code for the Fibonacci series.
A Software Engineer was asked Q. Write a SQL query joining two tables on a key column.
Popular interview questions of Software Engineer
A Software Engineer was asked Q1. Given a string, find the character with the maximum frequency.
A Software Engineer was asked Q2. Write the code for the Fibonacci series.
A Software Engineer was asked Q3. Write a SQL query joining two tables on a key column.
>
Fidelity Investments Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

