Airtel X- Labs Senior Software Engineer Interview Questions and Answers

Q1. Explain oops concepts
Ans. 
OOPs concepts are fundamental principles in object-oriented programming that help in organizing and designing code.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Allowing a class to inherit properties and behavior from another class.

• Polymorphism: Ability of objects to take on multiple forms or behaviors.

• Abstraction: Hiding the complex implementation details and...read more
Answered by AI
Add your answer
Q2. Explain design patterns
Ans. 
Design patterns are reusable solutions to common problems in software design.
• Design patterns help in creating flexible, maintainable, and scalable software.

• They provide a common language for developers to communicate about solutions.

• Examples include Singleton, Factory, Observer, and Strategy patterns.
Answered by AI
Add your answer

Q1. What is difference between the abstract class and interface
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructor, fields, and methods, while interface cannot have any of these.

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

• Abstract classes are used to provide a common base for multiple classes, while interfaces define a contract that implementing
Answered by AI
Add your answer

Q1. What design pattern used in angular
Ans. 
The design pattern commonly used in Angular is the Observer pattern.
• The Observer pattern is used to establish a one-to-many dependency between objects.

• In Angular, Observables are used to implement the Observer pattern for handling asynchronous data streams.

• Components in Angular often use Observables to subscribe to changes and react accordingly.
Answered by AI
Add your answer

Q1. Sort array, database, basics of js and nodejs
Add your answer
Q2. DSA array and objects
Add your answer

Q1. Fundamentals and Basics of android, projects you are worked on.
Add your answer

It was sort of pair programming where you will be told to implement some feature. Here they check your coding style, your approach and the architecture you follow.

Q1. Advanced android questions were asked and some scenario based questions.
Add your answer

Q1. It was managerial round, most discussion were on my projects and past experience.
Add your answer

Q1. I applied for SQL profile, around 40 questions were asked from basic to advanced based on concepts like triggers, stored procedures, SQL server agent, security, SQL profiler, constraints, types of indexes,...read more
Add your answer
Q2. How do I see SQL sessions? If we want to store temporary data inside stored procedure what should we do? When should we go for temp tables? Difference between index seek and index char? Diff b/w view and t...read more
Ans. 
Answers to SQL-related questions for Senior Software Engineer position
• To see SQL sessions, use the sp_who2 stored procedure or the Activity Monitor in SQL Server Management Studio

• To store temporary data inside a stored procedure, use table variables or temporary tables

• Use temp tables when you need to store large amounts of data or when you need to perform complex joins or aggregations

• Index seek is a type of index acces...read more
Answered by AI
Add your answer

Q1. About Insurance Domain Knowledge
Add your answer

Q1. About shift / Working hrs / Salary
Add your answer

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