TCS Dot Net Developer Lead Interview Questions and Answers

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

It is online test. In this test there is question of apti and also coding and from 5g question.

There are two questions asked and time is enough to solve 60 minutes

Q1. Wap for palindrome number
Ans. 
A palindrome number is a number that remains the same when its digits are reversed.
• Convert the number to a string

• Reverse the string

• Check if the reversed string is equal to the original string
Answered by AI
Add your answer
Q2. Add two numbers by function
Ans. 
Create a function to add two numbers
• Define a function that takes two parameters as input

• Inside the function, add the two numbers together and return the result

• Example: function addNumbers(num1, num2) { return num1 + num2; }
Answered by AI
Add your answer
Q3. Write a code for Binary search
Ans. 
Binary search code implementation in Python
• Define a function that takes a sorted array and a target value as input

• Initialize two pointers, low and high, to the start and end of the array respectively

• While low is less than or equal to high, calculate mid as (low + high) // 2 and compare array[mid] with target

• If array[mid] is equal to target, return mid

• If array[mid] is less than target, update low to mid + 1

• If array[mid]...read more
Answered by AI
Add your answer
Q4. Wap for check your name is palindrome not
Ans. 
A program to check if a given name is a palindrome or not.
• Convert the name to lowercase to handle case-insensitivity

• Remove any spaces or special characters from the name

• Reverse the name and compare it with the original name to check for palindrome
Answered by AI
Add your answer
Q5. What is malloc and calloc function
Ans. 
malloc and calloc are functions in C programming used for dynamic memory allocation.
• malloc function is used to allocate a single block of memory of a specified size.

• calloc function is used to allocate multiple blocks of memory of a specified size, initialized to zero.

• Example: int *ptr = (int*)malloc(5 * sizeof(int));

• Example: int *ptr = (int*)calloc(5, sizeof(int));
Answered by AI
Add your answer

Q1. What is Virtual LAN?
Add your answer
Q2. Difference between L2 &L3 switch?
Add your answer

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

Q1. What is the extension method
Ans. 
Extension methods allow adding new methods to existing types without modifying the original type
• Extension methods are static methods that can be called as if they were instance methods of the extended type

• They are defined in static classes and must be in the same namespace as the extended type

• They are commonly used to add functionality to existing types or interfaces without modifying them directly
Answered by AI
Add your answer
Q2. What is difference between union and union all
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union removes duplicates from the result set, while Union All does not.

• Union is slower than Union All because it has to perform an additional step to remove duplicates.

• Union is used when you want to combine two result sets and remove duplicates, while Union All is used when you want to combine two result sets without removing duplicat
Answered by AI
Add your answer
Q3. What is constructor chaining
Ans. 
Constructor chaining is the process of calling one constructor from another constructor within the same class.
• Allows for reusing code and avoiding duplication

• Can be achieved using 'this' keyword in the constructor

• Example: public MyClass(int x) : this(x, 0) {}
Answered by AI
Add your answer
Q4. What is CTE and explain
Ans. 
CTE stands for Common Table Expressions, which is 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 help 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 ...read more
Answered by AI
Add your answer
Q5. What is constructor
Ans. 
A constructor is a special method in a class that is automatically called when an object of that class is created.
• Constructors have the same name as the class they belong to.

• They are used to initialize the object's state.

• Constructors can be parameterized or default (no parameters).

• Example: public class Person { public Person(string name) { this.Name = name; } }
Answered by AI
Add your answer
Q6. How to send bulk of data through db
Ans. 
Use bulk insert or batch processing to send large amounts of data through the database.
• Use bulk insert operations provided by the database management system.

• Consider using batch processing techniques to optimize performance.

• Use stored procedures or parameterized queries for efficient data transfer.
Answered by AI
Add your answer
Q7. Which design pattern do you used in your project
Ans. 
I have used the MVC (Model-View-Controller) design pattern in my project.
• Separates the application into three main components: Model, View, and Controller

• Promotes code reusability, modularity, and maintainability

• Example: ASP.NET MVC framework
Answered by AI
Add your answer
Q8. What are the characteristics of singleton pattern and how to use
Ans. 
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
• Characteristics include private constructor, static instance variable, static method to access instance, lazy initialization, and thread safety.

• Example: public class Singleton { private static Singleton instance; private Singleton() {} public static Singleton getInstance() { if (instance == null) { instance = new Singlet
Answered by AI
Add your answer
Q9. Write a linq to fetch the data from db table(students) and data (studentid) should be in asending rder
Ans. 
Use LINQ to fetch data from the 'students' table in ascending order of 'studentid'.
• Use LINQ query syntax or method syntax to retrieve data from the 'students' table.

• Order the data by 'studentid' in ascending order using the 'OrderBy' or 'OrderByDescending' method.

• Ensure that the LINQ query is executed against the database to fetch the data.
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