HCL Group Technical Lead Interview Questions and Answers

Q1. Explain RAG in detail.
Add your answer
Q2. Transformer Architecture in detail
Add your answer

Q1. Expalin about Dependency Injection Princple
Ans. 
Dependency Injection is a design pattern where components are given their dependencies rather than creating them internally.
• Allows for easier testing by mocking dependencies

• Promotes loose coupling between components

• Improves code reusability and maintainability

• Example: Constructor injection, Setter injection, Interface injection
Answered by AI
Add your answer
Q2. Types of LifeTime Scopes of Depedendy Injection Principle and UseCases
Ans. 
There are three types of LifeTime Scopes in Dependency Injection: Transient, Scoped, and Singleton.
• Transient: Objects are created each time they are requested.

• Scoped: Objects are created once per request.

• Singleton: Objects are created only once and shared across the application.
Answered by AI
Add your answer
Q3. If you have a complex Stored Procedures which are required to be called for certain Validation Which one you chose, ADo.net or Entity Framework Core
Ans. 
Choosing between ADO.NET and Entity Framework Core for complex stored procedures depends on flexibility and performance needs.
• ADO.NET provides more control and performance for complex stored procedures.

• Entity Framework Core simplifies data access but may abstract away some stored procedure complexities.

• If performance is critical, ADO.NET is preferred due to its direct database interaction.

• For rapid development and main...read more
Answered by AI
Add your answer
Q4. Share the screen and show how to implement DIP in .net core
Ans. 
Implementing DIP in .NET Core
• Create an interface for the dependency

• Implement the interface in a separate class

• Inject the dependency into the consuming class

• Use dependency injection container to resolve dependencies
Answered by AI
Add your answer
Q5. Explain about CTE
Ans. 
CTE stands for Common Table Expressions, a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTEs are defined using the WITH keyword in SQL.

• They can improve readability and maintainability of complex queries.

• CTEs can be recursive, allowing for hierarchical data querying.

• Example: WITH cte AS (SELECT * FROM table_name) SELECT * FROM cte;

• Example: WITH RECURSIVE cte AS (SELECT...read more
Answered by AI
Add your answer
Q6. Difference between ABstact Classes and 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 methods, while interfaces cannot.

• A class can only extend one abstract class, but it can implement multiple interfaces.

• Abstract classes are used to define a common behavior for subclasses, while interfaces are used to define a contract for classes to implem...read more
Answered by AI
Add your answer

Good questions from different topics like quant, apti

2 coding questions data structure based.

SQL- Joins, Subqueires

SQL - Joins, Sub queries, window functions

Q1. Explain about Past experience
Add your answer
Q2. Current CTC and Expected CTC
Ans. 
Current CTC is confidential. Expected CTC is based on market standards and my experience.
• Current CTC is confidential information and not typically shared during interviews.

• Expected CTC is based on market standards, industry trends, and my level of experience.

• I am open to discussing compensation based on the responsibilities and expectations of the role.
Answered by AI
Add your answer