Saravana Stores Interview Questions and Answers

UNION combines and removes duplicates, UNION ALL combines without removing duplicates.

• UNION merges the result sets of two or more SELECT statements and removes duplicates

• UNION ALL merges the result sets of two or more SELECT statements without removing duplicates

• UNION is slower than UNION ALL as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

My expected CTC is in line with industry standards for a software engineer with my experience and skills.

• My expected CTC is based on my years of experience in software development.

• I have researched the average salaries for software engineers in my location.

• I am looking for a competitive salary package that reflects my skills and contributions.

• I am open to negotiation based on the overall compensation package offered.

AutoMapper is a library for mapping objects, middleware is software that acts as a bridge between different systems, OOPs concepts are principles of object-oriented programming.

• AutoMapper is a popular object-to-object mapping library in .NET that helps to eliminate repetitive mapping code.

• Middleware in .NET is software that can handle requests and responses between a client and a server, providing additional functionalities like logging, authentication, etc.

• OOPs concepts in ....read more

I prepared a Business Requirements Specification (BRS) document outlining the functional requirements of a new software system.

• Outlined the scope and objectives of the project

• Documented the specific functional requirements of the software

• Included use cases and user stories to illustrate how the system should work

• Collaborated with stakeholders to gather and validate requirements

Abstract classes in C# provide a way to define common behavior for derived classes while allowing specific implementations.

• Use the 'abstract' keyword to define an abstract class.

• Abstract classes cannot be instantiated and can contain abstract methods that must be implemented by derived classes.

• Derived classes must provide implementations for all abstract methods.

• Abstract classes can also have non-abstract methods and properties.

• Example: abstract class Shape { public abstract ...read more

Interceptors are used to intercept and manipulate HTTP requests and responses in web applications.

• Interceptors can be used for logging, authentication, error handling, caching, and modifying request/response headers.

• In Angular, interceptors are used to add authentication tokens to outgoing requests or handle errors globally.

• In Spring Boot, interceptors can be used to log incoming requests, validate input, or modify response data.

Reverse a given string

• Use a loop to iterate through the characters of the string and build a new string in reverse order

• Alternatively, use built-in functions like Array.Reverse() in C#

• Consider edge cases like empty string or null input