Experian Dot Net Lead Interview Questions and Answers

JOINS are used in SQL to combine data from two or more tables based on a related column.

• Inner JOIN returns only the matching rows from both tables

• Equi JOIN is a type of Inner JOIN where the join condition is based on equality between two columns

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

Divide array in two halves and keep each half in ascending order without using new Array.

• Use Array.sort() method to sort the original array

• Use Array.slice() method to divide the array into two halves

• Use Array.reverse() method to reverse the second half of the array

Interfaces are contracts that define a set of methods and properties that a class must implement.

• Interfaces provide a way to achieve abstraction and polymorphism in object-oriented programming.

• They allow for loose coupling between classes and promote code reusability.

• Interfaces can be used to define common behavior across multiple classes.

• Example: IDisposable interface in C# ensures that an object can be properly dispo...read more

Inheritance is a mechanism in object-oriented programming where a class is based on another class.

• Inheritance allows a subclass to inherit properties and methods from a superclass.

• The subclass can also add its own properties and methods.

• Examples include a Car class inheriting from a Vehicle class, or a Dog class inheriting from an Animal class.