TCS Dot Net Lead Interview Questions and Answers

Q1. What is the repository design pattern?
Add your answer
Q2. What is the difference between IEnumerable and IQueryable?
Add your answer

Q1. Demonstrate Function Overriding.
Add your answer
Q2. Linq query with order by
Add your answer
Q3. What is Out Parameter with example
Add your answer
Q4. Authentication and autherization, JWT Tocken
Add your answer
Q5. Reflection in C#
Add your answer

Q1. What are the types and number of constraints in your specific context?
Ans. 
There are various types of constraints in DOT NET development, including primary key, foreign key, unique, check, and default constraints.
• Primary key constraints ensure each record in a table is unique.

• Foreign key constraints enforce referential integrity between tables.

• Unique constraints ensure that all values in a column are distinct.

• Check constraints validate the data before it is inserted or updated.

• Default constra...read more
Answered by AI
Add your answer
Q2. What is the difference between an independent class and an abstract class?
Ans. 
Independent class can be instantiated while abstract class cannot be instantiated directly.
• Independent class can be directly instantiated using the 'new' keyword.

• Abstract class cannot be instantiated directly, it can only be used as a base class for other classes.

• Independent class does not require any derived class to implement its members.

• Abstract class can have abstract methods that must be implemented by derived cla
Answered by AI
Add your answer

Q1. Technical coding with the technical team
Add your answer

Q1. What are your reasons for changing your job?
Ans. 
Seeking new challenges, growth opportunities, and a better work-life balance.
• Looking for new challenges and opportunities to learn and grow.

• Seeking a better work-life balance.

• Interested in working with new technologies or in a different industry.

• Wanting to advance my career and take on more responsibilities.

• Company restructuring or changes in management.
Answered by AI
Add your answer

Q1. How to call abstract constructor
Add your answer
Q2. Difference between generic list and list which is faster
Add your answer

Write prime number code

Q1. Where are Logic App logs stored?
Ans. 
Logic App logs are stored in Azure Monitor Logs (formerly known as Log Analytics).
• Logic App logs are stored in Azure Monitor Logs, which is a centralized log storage and analytics service in Azure.

• Logs can be viewed and analyzed using Azure Monitor Logs queries.

• Logs can also be integrated with other Azure services for monitoring and alerting purposes.
Answered by AI
Add your answer
Q2. How to get the 5th top position data in Sql?
Ans. 
Use the OFFSET and FETCH clauses in SQL to get the 5th top position data.
• Use the ORDER BY clause to sort the data in descending order.

• Use the OFFSET clause to skip the first 4 rows.

• Use the FETCH clause to retrieve only the next row after skipping the first 4 rows.
Answered by AI
Add your answer
Q3. How do you implement custom middleware in .net core?
Ans. 
Custom middleware in .NET Core can be implemented by creating a class that implements the IMiddleware interface and adding it to the application pipeline.
• Create a class that implements the IMiddleware interface

• Implement the InvokeAsync method in the middleware class to handle the request processing logic

• Add the custom middleware to the application pipeline in the Configure method of the Startup class
Answered by AI
Add your answer
Q4. Explain Authentication & Authorization in asp.net core?
Ans. 
Authentication verifies the identity of a user, while authorization determines what resources a user can access.
• Authentication confirms the identity of a user through credentials like username and password.

• Authorization determines the permissions and access levels of a user based on their authenticated identity.

• In ASP.NET Core, authentication is handled through middleware like Identity, OAuth, or JWT tokens.

• Authorizati...read more
Answered by AI
Add your answer
Q5. Explain session management in asp.net core?
Ans. 
Session management in ASP.NET Core involves storing and retrieving user-specific data during a user's visit to a website.
• Session data is stored on the server side by default in ASP.NET Core

• Session data can be accessed and manipulated using the HttpContext.Session property

• Session data can be configured to use different storage providers such as in-memory, distributed cache, or SQL Server

• Session data is typically used to...read more
Answered by AI
Add your answer

I would like simple test

Q1. I would like to lisen the words of company maganement .. And the process of company rules and regulations ..
Add your answer
Q2. I will occupy the group of my team to secrue the entire the company to first stage
Add your answer
Q3. I want to.Get a job inMahindra
Add your answer
Q4. I didn't learn the computertyping but will learn definitely.. in tech Mahindr company basics
Add your answer
Q5. I am a student degree first year.. ButI would like work in techMahindra..
Add your answer

An aptitude is a component of a competence to do a certain kind of work at a certain level. Outstanding aptitude can be considered "talent", or "skill". Aptitude is inborn potential to perform certain kinds of activities, whether physical or mental, and whether developed or undeveloped

Coding is the process of allowing humans to speak to computers. As computers only understand binary language — a series of zeros and ones — humans need to use a programming language as a translator of sorts.

Group discussion is a discussion between a group of participants on a given subject. A group discussion typically forms a part of the selection process used by organisations and educational institutions. The candidates talk about the given topic to present facts, opinions and conclusions.

An assignment is a task that someone in authority has asked you to do. The word assignment is just the noun form of the common verb assign, which you use when you want to give someone a duty or a job. When you assign something, that something is called an assignment.

Case study is an appropriate research design when you want to gain concrete, contextual, in-depth knowledge about a specific real-world subject. It allows you to explore the key characteristics, meanings, and implications of the case. Case studies are often a good choice in a

Q1. Human resources (HR) is the division of a business responsible for finding, recruiting, screening, and training job applicants.
Add your answer
Q2. Finding, recruiting, screening, and training job applicants
Add your answer
Q3. Human resources (HR) is the division of a business responsible for finding, recruiting, screening, and training job applicants. HR departments also handle employee compensation, benefits, and terminations.
Add your answer

Q1. Examples of more advanced technical skills that a job might require include programming languages, technical writing, or data analysis. Unlike workplace skills, also called soft skills, such as communicati...read more
Ans. 
Technical skills often require specific education, such as programming languages, technical writing, or data analysis.
• Programming languages: Examples include Java, Python, C++, etc.

• Technical writing: Ability to write technical documentation, manuals, and reports.

• Data analysis: Skills in analyzing and interpreting data using tools like Excel, SQL, or R.
Answered by AI
Add your answer
Q2. Programming languages, technical writing, or data analysis
Add your answer

Q1. General questions on ASP.NET, Projects
Add your answer
Q2. Questions from my resume and current project
Add your answer