Sigmoid Associate Software Engineer Interview Questions and Answers

3 simple coding questions

Q1. Merge sort with list
Ans. 
Merge sort is a divide and conquer algorithm that recursively divides the input array into smaller subarrays, sorts them, and then merges them back together.
• Divide the input list into two halves

• Recursively apply merge sort to each half

• Merge the sorted halves back together
Answered by AI
Add your answer
Q2. Similar to coin exchange DP
Add your answer
Q3. SQL query medium level
Add your answer

Q1. Maximal rectangal
Add your answer
Q2. Loop in linked list
Ans. 
Loop in linked list is a situation where a node points to a previous node in the list, creating an infinite loop.
• Check for loops using Floyd's cycle detection algorithm

• Use two pointers, one moving twice as fast as the other, to detect a loop

• If the fast pointer catches up to the slow pointer, there is a loop
Answered by AI
Add your answer

Q1. Basic hr question regarding your project and all
Add your answer
Q2. He was more interested in what is my thinking pattern
Add your answer

Q1. What is difference between function and stored procedure
Ans. 
Functions return a single value, while stored procedures can perform multiple operations and return multiple values.
• Functions return a single value, while stored procedures can return multiple values.

• Functions are called in SQL statements, while stored procedures are called using EXECUTE statement.

• Functions cannot have output parameters, while stored procedures can have output parameters.

• Functions cannot modify server ...read more
Answered by AI
Add your answer
Q2. How to implement custom exception in MVC
Ans. 
Custom exceptions can be implemented in MVC by creating a new class that inherits from Exception class.
• Create a new class that inherits from Exception class

• Override the constructor to pass a custom message to the base Exception class

• Throw the custom exception in the MVC controller or service layer
Answered by AI
Add your answer

Q1. What fifo? diff btwn fifo and lifo
Ans. 
FIFO stands for First In, First Out. LIFO stands for Last In, First Out.
• FIFO is a method for organizing and manipulating a data buffer, where the first element added is the first to be removed.

• LIFO is a method where the last element added is the first to be removed.

• FIFO is like a queue, while LIFO is like a stack.

• Example: In a FIFO queue, if elements A, B, and C are added in that order, they will be removed in the same...read more
Answered by AI
Add your answer

First round was on Hacker Earth

Q1. Technical round was on Spring Data Jpa, Pagination, SOLID principles
Add your answer

Q1. Core java concepts,Sql queries,2 coding question based on arrays and string
Add your answer
Q2. Reverse the string
Ans. 
Reverse a given string
• Use a loop to iterate through the characters of the string

• Swap the characters from start to end to reverse the string

• Return the reversed string
Answered by AI
Add your answer
Q3. Find third highest salary from a employee table
Add your answer

Q1. Advance java and project related
Add your answer
Q2. Springboot and spring diff
Add your answer
Q3. Springboot annotations used in your project
Ans. 
Some common Springboot annotations used in projects are @RestController, @Autowired, @RequestMapping, @Service, @Component, @Repository.
• @RestController - Used to define RESTful web services.

• @Autowired - Used for automatic dependency injection.

• @RequestMapping - Used to map web requests to specific handler methods.

• @Service - Used to indicate that a class is a service.

• @Component - Used to indicate that a class is a Spring...read more
Answered by AI
Add your answer
Q4. Springboot dependencies
Add your answer

Q1. Js questions and 2 coding questions
Add your answer
Q2. Questions on angular, html and css
Add your answer

Q1. Basics of sql and some coding questions
Add your answer
Q2. Data structures
Add your answer

Q1. Putin arrays strings
Add your answer