LeadSquared Interview Questions, Process, and Tips

Q1. Difference between union and union all in SQL
Ans. 
Union combines the results of two or more SELECT statements, while Union All includes all rows, including duplicates.
• Union removes duplicate rows, Union All includes all rows

• Union is slower as it has to remove duplicates, Union All is faster

• Union requires the same number of columns in each SELECT statement, Union All does not
Answered by AI
Add your answer
Q2. Explain different kinds of joins with example
Ans. 
Different kinds of joins in SQL are inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer

Q1. Use of case statement in SQL
Ans. 
Case statement in SQL is used to perform conditional logic and return different values based on specified conditions.
• Case statement can be used to replace multiple if-else statements in SQL queries.

• It can be used in SELECT, WHERE, and ORDER BY clauses.

• Syntax: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE default_result END

• Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS ag
Answered by AI
Add your answer
Q2. Windows functions in SQL
Ans. 
Windows functions in SQL are used to perform calculations across a set of rows related to the current row.
• Windows functions are used to calculate cumulative sums, averages, rankings, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM() OVER(), AVG() OVER().
Answered by AI
Add your answer

Q1. Tell me about your role, projects.
Ans. 
I have worked on various software projects, including developing web applications and implementing new features.
• Developed a web application for tracking inventory and sales

• Implemented new features for a customer relationship management system

• Collaborated with team members to troubleshoot and resolve technical issues
Answered by AI
Add your answer
Q2. What your day to day work include
Ans. 
My day to day work as a Software Engineer involves writing code, debugging, attending meetings, collaborating with team members, and researching new technologies.
• Writing and testing code for software applications

• Debugging and troubleshooting issues in existing code

• Attending meetings with team members and stakeholders to discuss project progress

• Collaborating with other engineers and designers to develop new features

• Rese...read more
Answered by AI
Add your answer

1 programming question on Strings and oral questions on Spring Boot and Java

Q1. More alignment towards requirements; how will you solve or tackle problems.
Ans. 
To ensure alignment towards requirements, I will prioritize clear communication, thorough analysis, and regular feedback.
• Regularly communicate with stakeholders to clarify requirements and expectations

• Conduct thorough analysis of requirements to identify potential issues or gaps

• Seek feedback from team members and stakeholders throughout the development process

• Use agile methodologies to adapt to changing requirements an
Answered by AI
Add your answer

Q1. Questions on previous experience
Add your answer

Q1. Situation based questions
Add your answer

Q1. With Office head
Add your answer

Q1. Hand on coding excercise
Add your answer

Q1. Discussion regarding project as well system design
Add your answer