Sigmoid Associate Software Engineer Interview Questions and Answers

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

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. What is a bloom filter in hbase ?
Ans. 
A bloom filter in HBase is a data structure used to test whether a given element is a member of a set.
• Bloom filters are used to reduce the number of disk reads in HBase by quickly determining if a row may exist in a table.

• They are implemented as a compact array of bits, with multiple hash functions used to map elements to bits.

• Bloom filters can produce false positives but not false negatives, making them useful for pre...read more
Answered by AI
Add your answer
Q2. Write a query to remove duplicate rows in pyspark based on primary key.
Ans. 
Use dropDuplicates() function in pyspark to remove duplicate rows based on primary key.
• Use dropDuplicates() function on the DataFrame with the primary key column specified.

• Specify the subset parameter in dropDuplicates() to specify the primary key column.

• Example: df.dropDuplicates(['primary_key_column'])
Answered by AI
Add your answer

Q1. All questions based on your resume and recent project you have done including OOPS concept, MVC , Design patterns, SOLID principles
Add your answer

Q1. Here test the communications, problem solving skills, Decision making skill, Situation handle, conflict management
Add your answer

Easy questions according to the role.

Q1. Interview was for 30 min
Add your answer

Q1. Basic HR Questions like Introduce yourself etc
Add your answer