IDBI Intech Limited Team Lead Interview Questions and Answers

Remove duplicates from an array of strings

• Create a new set to store unique values

• Iterate through the array and add each element to the set

• Convert the set back to an array to remove duplicates

A SQL join is used to combine rows from two or more tables based on a related column between them.

• Use the JOIN keyword to specify the tables to be joined

• Use the ON keyword to specify the column to join on

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

Two common SQL joins are INNER JOIN and LEFT JOIN.

• INNER JOIN: Returns rows when there is at least one match in both tables.

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

I am currently working as a Senior Software Engineer, leading a team of developers in designing and implementing software solutions.

• Leading a team of developers in designing and implementing software solutions

• Collaborating with stakeholders to gather requirements and define project scope

• Mentoring junior team members and providing technical guidance

• Conducting code reviews and ensuring code quality and best practices are