Filter interviews by
Stored procedures and functions are both database objects used to encapsulate and execute a set of SQL statements.
Stored procedures are primarily used to perform an action, such as inserting or updating data, and may or may not return a result set.
Functions, on the other hand, are designed to return a single value or a table of values.
Stored procedures can have input and output parameters, while functions can only have...
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
Domain Driven Design is an approach to software development that focuses on the core domain and domain logic.
Focuses on understanding and modeling the core domain of the software
Emphasizes collaboration between domain experts and developers
Encourages the use of a common language to bridge the communication gap between technical and non-technical stakeholders
Promotes the use of domain models to capture and express the c...
Use SQL query with window function to find third highest salary of an employee.
Use ROW_NUMBER() function to assign a unique row number to each record based on salary in descending order
Filter the result where row number is 3 to get the third highest salary
To find the average salary of employees in a particular department, calculate the total salary of all employees in that department and divide by the number of employees.
Retrieve the salary of all employees in the particular department
Calculate the total salary by summing up all individual salaries
Divide the total salary by the number of employees to get the average salary
posted on 8 Aug 2024
Microfrontend is a software architectural style where a frontend application is decomposed into smaller, more manageable pieces.
Microfrontend allows teams to work on different parts of the frontend independently.
Each microfrontend can be developed, tested, and deployed separately.
Microfrontend architecture helps in scaling large frontend applications.
Examples of microfrontend frameworks include single-spa, Webpack Modu
Setting up environment in Angular app, understanding pipes, async, pure/impure, Subject and BehaviorSubject in theory
Setting up environment in Angular app involves configuring environment files for different environments like development, production, etc.
Pipes in Angular are used for transforming data in templates. Async pipes are used for handling asynchronous data streams.
Pure pipes are stateless and only recompute w...
I applied via Walk-in and was interviewed in Apr 2024. There were 2 interview rounds.
MVC stands for Model-View-Controller, a software design pattern that separates the application into three main components.
Model: Represents the data and business logic of the application.
View: Represents the UI components of the application.
Controller: Acts as an intermediary between Model and View, handling user input and updating the Model accordingly.
MVC helps in organizing code, improving maintainability, and promo...
Index fragmentation in SQL occurs when the logical order of pages in an index does not match the physical order in the data file.
Index fragmentation can lead to decreased query performance as the database engine has to scan more pages to retrieve data.
Fragmentation can be caused by frequent insertions, deletions, or updates on the indexed columns.
Rebuilding or reorganizing indexes can help reduce fragmentation and impr...
posted on 1 Aug 2024
The microservices design pattern used is the API Gateway pattern.
API Gateway pattern is used to provide a single entry point for clients to access multiple microservices.
It helps in routing requests, load balancing, authentication, and monitoring.
Examples include Netflix Zuul and Amazon API Gateway.
Hash map is a data structure that stores key-value pairs and uses a hash function to map keys to their corresponding values.
Hash map uses a hash function to determine the index of the key-value pair in the underlying array.
Collisions can occur when multiple keys hash to the same index, which can be resolved using techniques like chaining or open addressing.
Hash maps have O(1) average time complexity for insertion, dele
posted on 6 Jun 2024
I applied via Naukri.com and was interviewed in Dec 2023. There were 3 interview rounds.
Entity Framework is an ORM (Object-Relational Mapping) framework for .NET applications.
ORM framework for .NET applications
Maps database tables to classes in code
Provides a way to query and manipulate data using LINQ
Supports various database providers such as SQL Server, MySQL, etc.
CTE stands for Common Table Expression in SQL, used to create temporary result sets that can be referenced within a query.
CTEs are defined using the WITH keyword
They can be recursive or non-recursive
CTEs improve readability and maintainability of complex queries
Example: WITH cte AS (SELECT * FROM table_name) SELECT * FROM cte
SOLID principles are a set of five design principles for writing maintainable and scalable object-oriented code.
Single Responsibility Principle (SRP) - a class should have only one reason to change
Open/Closed Principle (OCP) - classes should be open for extension but closed for modification
Liskov Substitution Principle (LSP) - objects of a superclass should be replaceable with objects of its subclasses without affectin...
Design patterns are reusable solutions to common problems in software design.
Design patterns provide a template for solving recurring design problems in software development.
They help in making code more maintainable, scalable, and efficient.
Examples include Singleton, Factory, Observer, and Strategy patterns.
Core java , colletions
Software Engineer
10
salaries
| ₹7 L/yr - ₹10 L/yr |
Software Developer
6
salaries
| ₹6 L/yr - ₹10 L/yr |
Senior Software Engineer
6
salaries
| ₹8.5 L/yr - ₹14 L/yr |
Team Lead
6
salaries
| ₹21 L/yr - ₹30 L/yr |
Junior Software Developer
5
salaries
| ₹3.5 L/yr - ₹5.5 L/yr |
Infosys
TCS
Wipro
HCLTech