Divya Portfolio Senior Software Engineer 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

Competitive Programming

Q1. Java Basics, and related framework basics in depth
Add your answer

Q1. Design Patterns and Design Principles
Ans. 
Design patterns and principles are essential for creating maintainable and scalable software.
• Design patterns are reusable solutions to common software problems.

• Design principles are guidelines for creating software that is easy to maintain and extend.

• Examples of design patterns include Singleton, Factory, and Observer.

• Examples of design principles include SOLID, DRY, and KISS.
Answered by AI
Add your answer

Q1. How you make yourself up to date with latest technologies
Ans. 
I stay up to date with the latest technologies by attending conferences, reading tech blogs, and participating in online forums.
• Attending conferences and tech events

• Reading tech blogs and articles

• Participating in online forums and communities

• Taking online courses and tutorials

• Experimenting with new technologies in personal projects
Answered by AI
Add your answer

Q1. Questions on spring boot
Add your answer
Q2. Questions on Java
Add your answer
Q3. Java 8 Stream APi
Add your answer
Q4. Questions on previous projects
Add your answer

Asked basic questions .... To check concept and logic

Q1. SQL query for------ deleting duplicate from table
Add your answer
Q2. SQL query for second highest salary
Ans. 
SQL query to find second highest salary
• Use ORDER BY and LIMIT to get the highest salary

• Use subquery to exclude the highest salary and get the second highest
Answered by AI
Add your answer

Q1. Basic information and documents verification
Add your answer

Q1. Roles and responsibilities and queries solving .
Add your answer

Medium leetcode problem on array and linked list. And some theoretical questions

Q1. Core java , collections, object oriented principles . Some small coding questions based on usage of overriding and overloading
Add your answer

Q1. Multi treading and 1 problem solving question.
Add your answer

Q1. Discussion with ED : expectations and managerial questions
Add your answer

Q1. Typical HR questions
Add your answer

Q1. Questions on Core and advance Java like Collections, Java8, streams, Multithreading, Spring Boot concepts like annotations, security, codes and Microservices, Agile.
Add your answer

Q1. Technical + Managerial Round Technical questions on Java Spring Boot and Microservices. Managerial round questions as well.
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. What are your salary expectations?
Add your answer
Q4. Share details of your previous job.
Add your answer
Q5. This was also the salary discuss round.
Add your answer

Q1. KAFKA MICRISERVICE ARCHITECTURE
Add your answer

Medium leetcode question on array list

Q1. Core java and collections, exceptions and threading
Add your answer
Q2. Core java collections
Add your answer
Q3. Multi threading
Add your answer
Q4. Executor framework
Add your answer

Q1. Threading related questions
Add your answer