IBS Software Services Product Engineer 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

Array sliding window

Q1. Java and project
Add your answer

It will check simply the aptitude.

Write a program to find the factorial of a number.