Hexaware Technologies Technical Lead Interview Questions, Process, and Tips

Java8 Stream program to filter even numbers and double them

• Use Stream to filter even numbers

• Use map to double the filtered numbers

• Use collect to collect the results into a list

OOPs concept in .NET refers to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.

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

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementatio...read more

Some advanced features of .Net Core include cross-platform support, performance improvements, and support for modern development practices.

• Cross-platform support allows developers to build and run applications on different operating systems.

• Performance improvements such as faster startup times and lower memory usage.

• Support for modern development practices like containerization and microservices architecture.

• Built-in s...read more

Interface defines a contract for a class to implement, while abstraction hides the implementation details.

• Interface is a blueprint of a class that defines what methods a class must implement.

• Abstraction is a concept that hides the implementation details and shows only the functionality.

• Interfaces can have multiple inheritance, while abstraction can be achieved using abstract classes.

• Example: Interface 'Shape' may have ...read more

Extension methods are a way to add new methods to existing types without modifying the original type.

• Extension methods are defined as static methods in a static class.

• They must be in the same namespace as the type being extended.

• They are called like instance methods on the extended type.

• Example: Adding a method to the String class to reverse a string.

Middle tier is the layer of software that acts as a bridge between the front-end user interface and the back-end database.

• Middle tier handles business logic and processing of data

• It often includes application servers, web servers, and APIs

• Examples include Java EE, .NET Framework, and Node.js

DI stands for Dependency Injection and is a design pattern used to increase flexibility and maintainability of code.

• DI is a technique where one object supplies the dependencies of another object instead of the object creating them itself.

• It helps in decoupling components, making them easier to test and reuse.

• DI containers like Spring Framework in Java are used to manage dependencies and inject them into objects.

• Example...read more

The current project is a web application for managing inventory and sales.

• The project follows a MVC (Model-View-Controller) architecture

• Uses technologies like React for the front-end and Node.js for the back-end

• Database schema includes tables for products, customers, orders, etc.

• Implemented features like user authentication, product search, and order processing

SOLID principles are a set of five design principles that help make software designs more understandable, flexible, and maintainable.

• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects o...read more

Inversion of Control (IoC) is a design principle where the flow of control is inverted compared to traditional programming.

• IoC is a design pattern where the control of flow is inverted from the traditional approach.

• In IoC, the control is passed to a framework or container that manages the flow of the application.

• Dependency Injection is a common implementation of IoC, where dependencies are injected into a class rather

Pipeline functions are a series of functions or tasks that are executed in a specific order to process data or perform actions.

• Pipeline functions help streamline complex processes by breaking them down into smaller, manageable tasks

• Each function in the pipeline takes input from the previous function and passes output to the next function

• Commonly used in data processing, automation, and software development workflows

Session in .NET Core is used to store user-specific information across multiple requests.

• Use services.AddSession() in ConfigureServices method of Startup class to enable session

• Use app.UseSession() in Configure method of Startup class to add session middleware

• Access session data using HttpContext.Session property

• Example: HttpContext.Session.SetString("UserName", "JohnDoe") to store a string in session

• Example: string us...read more

ACID properties in DB ensure data integrity and consistency

• Atomicity: All operations in a transaction are completed successfully or none at all

• Consistency: Data is always in a valid state before and after a transaction

• Isolation: Transactions are isolated from each other until they are completed

• Durability: Once a transaction is committed, changes are permanent and survive system failures

Isolation levels define the level of visibility a transaction has on other concurrent transactions.

• Isolation levels include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.

• READ UNCOMMITTED allows dirty reads, READ COMMITTED prevents dirty reads but allows non-repeatable reads, REPEATABLE READ prevents non-repeatable reads but allows phantom reads, and SERIALIZABLE prevents all anomalies.

• Isolation le...read more

Salary expectation is the amount of money a candidate expects to be paid for a specific job role.

• Salary expectation is usually discussed during the job interview process.

• Candidates may base their salary expectations on factors such as their experience, qualifications, industry standards, and cost of living.

• Employers may also consider the candidate's salary expectation when making a job offer.

• It is important for candida...read more

AD stands for Active Directory, a directory service developed by Microsoft for Windows domain networks.

• AD is used to store information about network resources such as computers, users, groups, and printers.

• It allows administrators to manage and secure access to resources within a network.

• AD uses a hierarchical structure with domains, trees, and forests to organize objects.

• Group Policy Objects (GPOs) can be used to appl...read more

Troubleshooting Oracle involves identifying and resolving issues with database performance, connectivity, and errors.

• Check database connectivity by testing connection using SQL*Plus or SQL Developer

• Review alert logs and trace files for error messages and performance issues

• Monitor database performance using tools like Oracle Enterprise Manager or AWR reports

• Check for resource contention issues such as high CPU or memory...read more