Jindal Saw Interview Questions and Answers

Stored procedures are precompiled SQL queries stored in the database, while functions are user-defined routines that return a value.

• Stored procedures are used for performing specific tasks or operations on the database, while functions are used to return a single value.

• Stored procedures can contain multiple SQL statements and can have input and output parameters, while functions are more limited in their functionality.

• Stored procedures are generally used for complex business ...read more

Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.

• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing direct access and manipulation from outside the class.

• Encapsulation also promotes code reusability and modularity by grouping related data and methods together.

• For example, in a class representing a bank account,...read more

Interfaces define contracts for classes to implement, while abstraction is a way to hide implementation details.

• Interfaces are like a blueprint that defines what methods a class must implement.

• Abstraction is a concept where we hide the implementation details and show only the necessary features of an object.

• Interfaces can have multiple inheritance, while abstraction is achieved using abstract classes or interfaces.

• Example: Interface 'Shape' may have methods like 'calculateAre...read more

Web API is a framework for building HTTP services, MVC is a design pattern for web applications, and jQuery is a JavaScript library for simplifying client-side scripting.

• Web API is a framework provided by Microsoft for building HTTP services that can be consumed by a broad range of clients, including browsers, mobile devices, and desktop applications.

• MVC (Model-View-Controller) is a design pattern used in web development to separate the application's concerns into three main ...read more

Routing and filters are important concepts in MVC development.

• Routing determines how URLs are mapped to controllers and actions.

• Filters are used to add additional logic before or after an action is executed.

• There are several types of filters, including authorization, action, and result filters.

• Filters can be applied globally, to a controller, or to an individual action.

• Routing and filters are essential for creating a well-structured and secure MVC application.