ASENTECH Senior Software Developer Interview Questions and Answers

SQL is a domain-specific language used for managing and manipulating relational databases.

• SQL stands for Structured Query Language.

• It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables.

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE, and JOIN.

• Example: SELECT * FROM customers WHERE city = 'New York';

Overloading is when multiple methods have the same name but different parameters. Overriding is when a subclass provides a specific implementation of a method that is already provided by its superclass.

• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding occurs when a subclass provides a specific implementation of a method that is already provided by its superclass.

• ...read more

A virtual method is a method in a base class that can be overridden in a derived class.

• Virtual methods allow for polymorphism in object-oriented programming.

• They are declared using the 'virtual' keyword in the base class and can be overridden using the 'override' keyword in the derived class.

• Virtual methods enable dynamic binding, where the method to be called is determined at runtime based on the actual type of the ob...read more

A static class in C# is a class that cannot be instantiated and is used to group related methods and properties.

• Static classes are declared using the 'static' keyword.

• Static classes cannot be instantiated or inherited.

• Static classes are commonly used for utility classes that contain helper methods.

• Example: 'Math' class in C# is a static class that contains mathematical functions like 'Math.Max()' and 'Math.Min()'.