10+ InfiSol Energy LLP Interview Questions and Answers

Static constructor gets executed first before default constructor.

• Static constructor is called only once, when the class is first accessed or instantiated.

• Default constructor is called every time a new instance of the class is created.

• Example: If a class has both static and default constructors, the static constructor will be executed before the default constructor.

Yes, by using access modifiers like public or internal.

• Yes, by changing the access modifier of the class to public or internal.

• Private variables can be accessed within the same class but not outside. Use properties or methods to access them in other classes.

• Example: class A has a private variable 'x'. In class B, create an instance of class A and access 'x' using a public method or property.

The query selects the ID and Name of the employee with the highest salary.

• The query uses a subquery to find the maximum salary in the Employee table.

• The outer query then selects the ID and Name of the employee with that maximum salary.

Abstract class can have implementation details while interface cannot. Class can implement multiple interfaces but only inherit from one abstract class.

• Abstract class can have method implementations while interface cannot.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Interfaces are used to define a contract for classes to implement, while abstract classes are used to provide a common base for subclasses.

• Abstract classes can have constr...read more

Encapsulation is the concept of bundling data and methods that operate on the data within a single unit.

• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• Data hiding is achieved by making the variables private and providing public methods to access or modify them.

• For example, a class 'Car' may have private variables like 'model' and 'year' with public methods like 'getModel()' and 'setYear()' to access or modify them.

No, static constructors cannot have multiple arguments.

• Static constructors in C# do not take any arguments.

• They are used to initialize static data members or perform any necessary setup for the class.

• Example: public static MyClass() { // constructor code }

The important pillars of OOPs are Inheritance, Encapsulation, Abstraction, and Polymorphism.

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

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

• Abstraction focuses on the essential features of an object while hiding the implementation details.

• Polymorphism allows objects to be treated as instances of their parent class, enabling flexibility and reusability.

Yes, a table can have multiple primary keys.

• A table can have a composite primary key, which consists of multiple columns.

• Each column in the composite primary key contributes to uniquely identifying each row.

• Example: CREATE TABLE Employee (emp_id INT, dept_id INT, PRIMARY KEY (emp_id, dept_id));

Query to find ID and Name of employee with maximum salary

• Use SQL query with MAX() function to find the maximum salary

• Join the result with employee table to get ID and Name

Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.

• OOP focuses on creating objects that interact with each other to solve problems.

• It involves concepts like classes, objects, inheritance, polymorphism, and encapsulation.

• Example: In a banking application, you can have classes like Account, Customer, and Transaction, each with their own properties and methods.

Layout page in MVC is a shared template that defines the structure of the final output HTML.

• Layout page contains common elements like header, footer, navigation menu, etc.

• It allows for consistent design across multiple views.

• Can be used to define sections that can be overridden by individual views.

Polymorphism is the ability of a single function or method to operate on different data types.

• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: Inheritance allows a child class to override a method of its parent class, exhibiting polymorphic behavior.

Abstract class is a class that cannot be instantiated and may contain abstract methods.

• Cannot be instantiated directly

• May contain abstract methods that must be implemented by derived classes

• Can have both abstract and non-abstract methods

Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.

• Allows a class to inherit attributes and methods from another class

• Promotes code reusability and reduces redundancy

• Creates a parent-child relationship between classes

• Derived class can access public and protected members of the base class

• Example: Class Car inherits from class Vehicle

Primary key is a unique identifier for each record in a database table.

• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key constraints prevent duplicate or null values