eXEGESIS Infotech SQL Developer Interview Questions and Answers

Dispose and finalize are methods used for releasing resources in .NET.

• Dispose is used to release unmanaged resources immediately.

• Finalize is used to release managed resources when the garbage collector runs.

• Dispose can be called manually or through the using statement.

• Finalize is called automatically by the garbage collector.

• Dispose is implemented by IDisposable interface.

• Finalize is implemented by Object class.

OOPs concepts are the principles of Object-Oriented Programming that help in designing and implementing software solutions.

• Encapsulation - binding data and functions together

• Inheritance - creating new classes from existing ones

• Polymorphism - ability of objects to take on multiple forms

• Abstraction - hiding implementation details

• Objects - instances of classes that encapsulate data and behavior

Inheritance is a mechanism in OOP where a new class is derived from an existing class.

• It allows for code reusability and promotes a hierarchical structure.

• It can lead to tight coupling and make the code harder to maintain.

• It can also result in the creation of unnecessary classes and increase complexity.

• Example: A Car class can inherit properties and methods from a Vehicle class.

• Example: A Square class can inherit prope

Explicit interface is a way to implement multiple interfaces with same method names.

• Explicit interface is used to avoid naming conflicts when implementing multiple interfaces.

• It is implemented by prefixing the interface name to the method name.

• It is useful when implementing COM interfaces in .NET.

• Example: void IInterface1.Method() and void IInterface2.Method()

Interface defines only method signatures while abstract class can have method implementations.

• Interfaces can be implemented by multiple classes while abstract classes can only be extended by one class.

• Interfaces are used for achieving multiple inheritance in Java while abstract classes are used for single inheritance.

• Interfaces cannot have constructors while abstract classes can have constructors.

• An example of an inter...read more

Startup method in .NET Core is used to configure the application's services and middleware.

• Startup method is defined in Startup.cs file.

• It includes ConfigureServices and Configure methods.

• ConfigureServices is used to add services to the dependency injection container.

• Configure is used to configure the HTTP request pipeline.

• Example: public void ConfigureServices(IServiceCollection services) { services.AddMvc(); }

• Example...read more

HTTP verbs are used to indicate the type of action being performed on a resource.

• HTTP verbs include GET, POST, PUT, DELETE, PATCH, HEAD, OPTIONS

• GET is used to retrieve data from a server

• POST is used to submit data to a server

• PUT is used to update an existing resource on a server

• DELETE is used to delete a resource from a server

• PATCH is used to partially update a resource on a server

• HEAD is used to retrieve only the head...read more

Project architecture refers to the overall design and structure of a software project.

• It includes the organization of components and modules

• Defines the relationships between them

• Specifies the technologies and tools used

• Determines the overall performance and scalability

• Examples include MVC, microservices, and client-server architecture