AkaaRa Consulting C Sharp and Dot Net Developer Interview Questions and Answers for Experienced

An interface is a programming construct that defines a contract for classes to implement certain methods and properties.

• Interfaces provide a way to achieve multiple inheritance in C#.

• They are used to define common behavior that can be implemented by multiple classes.

• Interfaces can be used to achieve loose coupling and promote code reusability.

• Classes that implement an interface must provide an implementation for all it...read more

Yes, static interfaces can be used in public classes in .NET.

• Static interfaces are used to define a set of static members that can be implemented by a class.

• They are useful when you want to group related static members together.

• Static interfaces cannot be instantiated or inherited, but they can be implemented by a class.

• The static members defined in the interface must be implemented as static members in the implementin...read more

OOPs concepts are fundamental principles of object-oriented programming like Inheritance, Polymorphism, Encapsulation, and Abstraction.

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

• Polymorphism: Ability of an object to take on many forms.

• Encapsulation: Bundling of data with the methods that operate on that data.

• Abstraction: Hiding the complex implementation details and showing only t

Delegate is a type that represents references to methods with a specific parameter list and return type.

• Delegates are similar to function pointers in C++ or pointers to member functions in C++.

• Delegates allow methods to be passed as parameters.

• Delegates can be used to define callback methods.

• Delegates can be multicast, meaning they can hold references to multiple methods.

• Example: delegate void MyDelegate(string message

Connection pool is a cache of database connections maintained so that the connections can be reused when needed.

• Connection pool helps in improving performance by reusing existing connections instead of creating new ones every time.

• It helps in reducing the overhead of establishing a new connection to the database.

• Connection pool size can be configured to control the maximum number of connections that can be opened at a ...read more

Use SQL query with GROUP BY and HAVING clause to delete duplicate records.

• Use GROUP BY clause to group records with same values.

• Use HAVING clause to filter out groups with count greater than 1.

• Delete duplicate records based on the grouped criteria.

To find the 2nd highest salary in a table, we can use a subquery or window function in SQL.

• Use a subquery to select the maximum salary that is less than the highest salary

• Use a window function like ROW_NUMBER() to rank the salaries and then select the 2nd highest

• Consider handling cases where there may be ties for the highest salary

SharePoint is a web-based collaborative platform that integrates with Microsoft Office.

• SharePoint is a document management and storage system.

• It allows teams to collaborate on projects and share information.

• SharePoint can be used to create websites, intranets, and extranets.

• SharePoint Online is a cloud-based version of SharePoint, while on-premise refers to a self-hosted version.

• SharePoint Online is part of Office 365 ...read more