Infosys DOT NET Developer Interview Questions, Process, and Tips

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

Q1. What is oops concept
Ans. 
OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPs focuses on creating reusable code and organizing it into classes and objects.

• Key concepts include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation involves bundling data and methods that operate on the data into a single unit.

• Inheritance allows a class to inherit prop...read more
Answered by AI
Add your answer
Q2. What is routing
Ans. 
Routing is the process of selecting a path for network traffic to travel from source to destination.
• Routing determines the best path for data packets to travel on a network

• It involves making decisions based on routing algorithms and network protocols

• Examples include IP routing in the internet and routing tables in routers
Answered by AI
Add your answer
Q3. Solid principles
Add your answer
Q4. Difference between clustered and non clustered
Ans. 
Clustered index physically orders the data in the table, while non-clustered index does not.
• Clustered index determines the physical order of data in the table, while non-clustered index does not.

• Clustered index is faster for retrieval of data, while non-clustered index is faster for retrieval of specific data.

• Clustered index can only have one per table, while non-clustered index can have multiple per table.
Answered by AI
Add your answer

Apti, reasoning and verbal communication

Q1. What is CLR ?
Ans. 
CLR stands for Common Language Runtime, it is the virtual machine component of Microsoft's .NET framework.
• CLR is responsible for managing the execution of .NET programs.

• It provides services such as memory management, exception handling, and security.

• CLR compiles the intermediate language code into native code using Just-In-Time (JIT) compilation.

• It allows different languages to be used within the .NET framework, as lon...read more
Answered by AI
Add your answer
Q2. Difference between Kestrel and IIS
Ans. 
Kestrel is a cross-platform web server while IIS is a Windows-only web server.
• Kestrel is a lightweight, open-source web server developed by Microsoft and optimized for ASP.NET Core applications.

• IIS (Internet Information Services) is a full-featured web server developed by Microsoft for Windows servers.

• Kestrel can be used as a standalone server or behind a reverse proxy like IIS or Nginx.

• IIS provides additional features...read more
Answered by AI
Add your answer

Q1. Oops concepts in c#
Ans. 
Oops concepts in C# include inheritance, polymorphism, encapsulation, and abstraction.
• Inheritance allows a class to inherit properties and behavior from another class.

• Polymorphism allows objects to be treated as instances of their parent class.

• Encapsulation hides the internal state of an object and only exposes necessary functionality.

• Abstraction allows classes to define abstract methods that must be implemented by sub
Answered by AI
Add your answer
Q2. What is difference between.net and .net core
Ans. 
The main difference between .NET and .NET Core is that .NET Core is a cross-platform, open-source framework while .NET is a Windows-only framework.
• NET Core is cross-platform and can run on Windows, macOS, and Linux, while .NET is limited to Windows.

• .NET Core is open-source and has a more modular design compared to the monolithic .NET framework.

• .NET Core is optimized for microservices and containerized applications.

• Both...read more
Answered by AI
Add your answer

Q1. One coding questions given to me
Add your answer
Q2. SQL based one query asked
Add your answer