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...
Fidelity Investments Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
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

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter