
Asked in Fidelity Investments
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...
Top Software Engineer Interview Questions Asked at Fidelity Investments
Q. Write the code for the Fibonacci series.
Q. Write a SQL query joining two tables on a key column.
Q. Describe your experience with data structures, especially trees, as they relate ...read more
Interview Questions Asked to Software Engineer at Other Companies
Top Skill-Based Questions for Fidelity Investments Software Engineer
Algorithms Interview Questions and Answers
250 Questions
Data Structures Interview Questions and Answers
250 Questions
Web Development Interview Questions and Answers
250 Questions
Java Interview Questions and Answers
250 Questions
Software Development Interview Questions and Answers
250 Questions
SQL Interview Questions and Answers
250 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

