Misha Infotech 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.

Button trigger in MVC allows for user interaction and execution of server-side code.

• Buttons can be created using HTML helpers in MVC

• Button click events can be handled using jQuery or JavaScript

• Server-side code can be executed using AJAX calls or form submissions

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++.

• Delegates can be used to pass methods as arguments to other methods.

• Delegates can be used to define callback methods.

• Delegates can be chained together using the + or += operator.

• Delegates can be removed from a chain using the - or -= operator.