CMS Computers Limited (INDIA) Software Engineer Interview Questions, Process, and Tips for Experienced

There are four types of joins in SQL Server: Inner Join, Left Join, Right Join, and Full Outer Join.

• Inner Join returns only the matching rows from both tables.

• Left Join returns all the rows from the left table and matching rows from the right table.

• Right Join returns all the rows from the right table and matching rows from the left table.

• Full Outer Join returns all the rows from both tables, with NULL values in the col...read more

A procedure is a set of instructions that performs a specific task, while a function returns a value after performing a specific task.

• A procedure does not return a value, while a function does.

• Functions can be used in expressions, while procedures cannot.

• Functions are called by reference, while procedures are called by value.

• Examples of functions include sqrt() and pow(), while examples of procedures include printf() a

Constructor is a special method that is called when an object of a class is created in C#.

• Constructors have the same name as the class and can have parameters.

• They are used to initialize the object's data members and perform any necessary setup.

• If a class does not have a constructor, a default constructor is provided by the compiler.

• Constructors can be overloaded to provide different ways of initializing objects.

Abstract class can have implementation while interface cannot. A class can implement multiple interfaces but only extend one abstract class.

• Abstract class can have constructors while interface cannot.

• Abstract class can have non-abstract methods while interface can only have abstract methods.

• Abstract class can have instance variables while interface cannot.

• A class implementing an interface must implement all its methods...read more