Sigmoid Sde1 Interview Questions and Answers

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

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

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

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

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

Fail fast iterator throws ConcurrentModificationException if the collection is modified while iterating. Fail safe iterator does not throw exception but works on clone of collection.

• Fail fast iterator checks for modification during iteration and throws ConcurrentModificationException if found.

• Fail safe iterator works on clone of collection and does not throw exception if collection is modified.

• Example: ArrayList iterat...read more