10+ Money Edge Financial Consultancy Interview Questions and Answers

REST is an architectural style for web services, while SOAP is a protocol. HTTP verbs include GET, POST, PUT, PATCH, and DELETE.

• REST is stateless and uses standard HTTP methods, while SOAP is a protocol that uses XML for communication.

• HTTP verbs: GET retrieves data, POST submits data, PUT updates entire resource, PATCH updates part of a resource, DELETE removes a resource.

• PUT is idempotent, meaning multiple requests have the same effect as a single request, while PATCH is not...read more

Synchronous programming is blocking, while asynchronous programming is non-blocking. Threads are lower-level units of execution, while tasks are higher-level abstractions. Main thread can handle exceptions thrown by threads or tasks.

• Synchronous programming blocks the execution until a task is completed, while asynchronous programming allows the program to continue executing while waiting for a task to complete.

• Threads are lower-level units of execution managed by the operatin...read more

To improve SQL query performance, optimize queries, use indexes, and consider using stored procedures. SQL functions and stored procedures have different use cases. Indexes improve query performance by allowing faster data retrieval. Views are virtual tables that simplify complex queries.

• Optimize SQL queries by avoiding unnecessary joins, reducing the number of columns retrieved, and using appropriate filters

• Use indexes to improve query performance by creating indexes on freq...read more

Garbage collection is an automatic memory management process in .NET. It collects and frees up memory occupied by unused objects.

• Garbage collection automatically identifies and releases memory occupied by objects that are no longer in use.

• It improves performance by eliminating manual memory management and preventing memory leaks.

• Garbage collection in .NET is generational, dividing objects into three generations based on their age and usage patterns.

• Generation 0 contains newly...read more

OOPs pillars: Abstraction, Encapsulation, Inheritance, Polymorphism. Abstraction hides complexity. Encapsulation bundles data and methods.

• Abstraction: Focuses on hiding unnecessary details and exposing only essential features. Example: A car dashboard hides the internal working of the car and provides only necessary information to the driver.

• Encapsulation: Wrapping data and methods into a single unit. Example: A class in C# encapsulates data and methods related to a specific ...read more

Singleton design pattern ensures that a class has only one instance and provides a global point of access to it.

• Singleton pattern restricts the instantiation of a class to a single object.

• It is useful when only one instance of a class is needed to control actions throughout the system.

• Singleton pattern can be implemented using a private constructor, a static method to get the instance, and a static variable to hold the instance.

• Example: Singleton pattern can be used in a logg...read more

Extension methods allow adding new methods to existing types without modifying the original type.

• Extension methods are defined as static methods in a static class.

• The first parameter of an extension method specifies the type being extended, preceded by the 'this' keyword.

• Extension methods can be called on instances of the extended type as if they were instance methods.

• Extension methods can be used to add functionality to built-in types or third-party types.

• Here's an example o...read more

Group and sort a list of strings by their first character.

• Use a dictionary to group the strings by their first character.

• Sort the keys of the dictionary alphabetically.

• Retrieve the strings for each key and sort them alphabetically as well.

Code to print n numbers of Fibonacci series

• Use a loop to iterate n times

• Initialize the first two numbers of the series as 0 and 1

• Print each number in the series as it is calculated

• Calculate the next number by adding the previous two numbers

IEnumerable is for in-memory collections, IQueryable is for querying data sources. FirstOrDefault returns the first element, SingleOrDefault returns the only element.

• IEnumerable is used for querying in-memory collections like lists and arrays.

• IQueryable is used for querying data sources like databases.

• FirstOrDefault returns the first element of a sequence or a default value if the sequence is empty.

• SingleOrDefault returns the only element of a sequence or a default value if t...read more