LeadSquared Senior Product Manager Interview Questions and Answers

Fancy string problem

Q1. You are given 2 tables, customer and orders, you have to write an SQL query to fetch the total order placed by each customer and also give the total order amount.
Add your answer
Q2. Java Streams question to find the total number of employees that have salary greater than 50000
Ans. 
Use Java Streams to find total employees with salary > 50000
• Filter employees with salary > 50000 using stream.filter()

• Count the number of employees using stream.count()
Answered by AI
Add your answer
Q3. The various annotations used in Springboot @Entity, @RestController etc
Ans. 
Annotations in Springboot like @Entity, @RestController are used for defining classes and endpoints respectively.
• Annotations like @Entity are used to define JPA entities in Springboot.

• Annotations like @RestController are used to define RESTful web services endpoints.

• Annotations like @Autowired are used for dependency injection in Springboot.
Answered by AI
Add your answer
Q4. AWS services used in my previous project
Ans. 
In my previous project, I used AWS services such as EC2, S3, and RDS for hosting, storage, and database management.
• EC2 for hosting application servers

• S3 for storing and retrieving files

• RDS for managing relational databases
Answered by AI
Add your answer

Q1. All questions were asked based on my resume. So prepare well from your resume.
Add your answer

Q1. 4th round was a one on one with the manager, asked me general questions about why I was looking for a job change.
Add your answer

Q1. Product roadmap
Add your answer

Q1. Server Realted Questions
Add your answer

Backtracking problem for tree

Q1. High level design of search engine
Ans. 
A search engine is a software system that is designed to search for information on the World Wide Web.
• Crawling: Search engines use web crawlers to discover and index web pages.

• Indexing: The search engine creates an index of the content it finds during crawling.

• Ranking: Algorithms are used to determine the relevance of web pages to a user's query.

• User Interface: A search engine provides a user-friendly interface for use...read more
Answered by AI
Add your answer

Q1. Resume overview
Add your answer
Q2. Product case studies
Add your answer

Q1. Favorite product
Ans. 
My favorite product is the iPhone because of its sleek design, user-friendly interface, and seamless integration with other Apple products.
• Sleek design

• User-friendly interface

• Seamless integration with other Apple products
Answered by AI
Add your answer
Q2. Past experience
Add your answer

Q1. More about working behaviour and previous experience
Add your answer

Q1. Product knowledge
Add your answer

SQL query based questions where asked

Q1. Being a fresher, the question asked qas about OOPS, stack , query, resume based.
Add your answer
Q2. Behavioral questions
Add your answer