FE fundinfo Senior Software Developer Interview Questions and Answers

Q1. Pagination in SQL
Ans. 
Pagination in SQL allows for displaying a subset of query results at a time.
• Use LIMIT and OFFSET clauses in SQL queries to implement pagination.

• LIMIT specifies the maximum number of rows to return.

• OFFSET specifies the number of rows to skip before starting to return rows.
Answered by AI
Add your answer
Q2. OOPS concepts.. SOILD design principles
Add your answer
Q3. Thread vs task in multiprocessing.. explain with examples
Ans. 
Threads and tasks are both used in multiprocessing, but have different characteristics and use cases.
• Threads are lightweight processes within a single process, sharing memory space. They are managed by the operating system.

• Tasks are units of work that can be executed asynchronously. They are typically managed by a task scheduler.

• Threads are suitable for parallel processing and improving performance, while tasks are use...read more
Answered by AI
Add your answer
Q4. ViewBag vs Tempdata in MVC
Ans. 
ViewBag is used to pass data from controller to view, while TempData is used to pass data between controller actions.
• ViewBag is a dynamic property that allows you to pass data from controller to view

• TempData is a dictionary object that allows you to pass data between controller actions

• ViewBag is not type-safe and requires typecasting, while TempData is type-safe

• ViewBag data is lost if redirection occurs, while TempData
Answered by AI
Add your answer
Q5. Abstract vs Interface
Ans. 
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
• Abstract classes can have constructors, fields, and non-abstract methods.

• Interfaces can only have abstract methods and constants.

• A class can implement multiple interfaces but can only inherit from one abstract class.
Answered by AI
Add your answer

Basic concepts of programming

Q1. Programming concepts
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. In How many ways we can create objects in Java
Ans. 
Objects in Java can be created in multiple ways, including using new keyword, cloning, deserialization, and reflection.
• Using the 'new' keyword

• Cloning an existing object

• Deserialization from a file or network

• Using reflection to create objects dynamically
Answered by AI
Add your answer
Q2. Difference between Interface and Abstract Class
Ans. 
Interface is a contract that defines the methods a class must implement, while abstract class can have both implemented and abstract methods.
• Interface methods are public and abstract by default, while abstract class can have abstract and non-abstract methods.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Interfaces are used to achieve multiple inheritance in Java, while abstract ...read more
Answered by AI
Add your answer
Q3. What is Serialization
Ans. 
Serialization is the process of converting an object into a format that can be easily stored or transmitted.
• Serialization is used to convert complex data structures or objects into a stream of bytes.

• Serialized data can be stored in files, databases, or sent over a network.

• Common serialization formats include JSON, XML, and Protocol Buffers.
Answered by AI
Add your answer