Inspira Enterprise India Limited Server Administrator Interview Questions and Answers

Interface defines a contract while abstract class provides partial implementation.

• Interfaces can only have abstract methods while abstract classes can have both abstract and non-abstract methods.

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

• Interfaces are used for loose coupling while abstract classes are used for code reusability.

• Example of interface: Runnable interface in Java...read more

Method overloading is when a class has multiple methods with the same name but different parameters.

• Method overloading allows for flexibility in method calls

• The methods must have different parameters, such as different data types or different numbers of parameters

• Example: public void print(int num) and public void print(String str)

• The compiler determines which method to call based on the arguments passed

Indexing in SQL Server database

• Indexing improves query performance by creating a structure that allows for faster data retrieval

• Clustered and non-clustered indexes are the two types of indexes in SQL Server

• Clustered indexes determine the physical order of data in a table while non-clustered indexes create a separate structure

• Indexing should be done strategically to avoid over-indexing which can slow down data modificat