Filter interviews by
I applied via Naukri.com and was interviewed before Apr 2023. There were 2 interview rounds.
To improve SQL query performance, optimize indexes, minimize data retrieval, use proper joins, and consider query structure.
Optimize indexes to speed up data retrieval
Minimize data retrieval by selecting only necessary columns
Use proper joins (e.g. INNER JOIN instead of CROSS JOIN)
Consider query structure and avoid unnecessary subqueries or functions
I appeared for an interview before Apr 2023.
Top trending discussions
I applied via LinkedIn and was interviewed before Apr 2023. There were 4 interview rounds.
Fetching data from api, DSA question (Queue implementation)
I applied via Approached by Company and was interviewed in Feb 2023. There were 3 interview rounds.
Redux is a predictable state container for JavaScript apps.
Redux is a state management library for JavaScript applications.
It helps in managing the state of an application in a predictable way.
Redux follows a unidirectional data flow pattern.
Context API is a built-in feature of React that can be used for state management, but it is not as powerful as Redux.
ES6 features include arrow functions, template literals, destru...
Output based question regarding shallow and deepcopy related to object.
write a program for i/p: "This is the JS guide, developer!" o/p: "sihT si eht SJ ,ediug !repoleved"
react timer based output start, stop and reset.
I applied via Naukri.com and was interviewed in Nov 2020. There were 5 interview rounds.
I applied via Naukri.com and was interviewed in Apr 2022. There were 3 interview rounds.
Interface defines a contract while abstract class provides partial implementation.
Interfaces can only have abstract methods while abstract classes can have both abstract and non-abstract methods.
A class can implement multiple interfaces but can only inherit from one abstract class.
Interfaces are used for loose coupling while abstract classes are used for code reusability.
Example of interface: Runnable interface in Java...
Method overloading is when a class has multiple methods with the same name but different parameters.
Method overloading allows for flexibility in method calls
The methods must have different parameters, such as different data types or different numbers of parameters
Example: public void print(int num) and public void print(String str)
The compiler determines which method to call based on the arguments passed
Indexing in SQL Server database
Indexing improves query performance by creating a structure that allows for faster data retrieval
Clustered and non-clustered indexes are the two types of indexes in SQL Server
Clustered indexes determine the physical order of data in a table while non-clustered indexes create a separate structure
Indexing should be done strategically to avoid over-indexing which can slow down data modificat
based on 2 interviews
Interview experience
Software Engineer
44
salaries
| ₹6.9 L/yr - ₹15.8 L/yr |
Senior Software Engineer
28
salaries
| ₹14.6 L/yr - ₹26 L/yr |
Associate Software Engineer
26
salaries
| ₹5.8 L/yr - ₹10 L/yr |
Software Engineering Specialist
22
salaries
| ₹17 L/yr - ₹35 L/yr |
Technical Manager
22
salaries
| ₹25.5 L/yr - ₹55 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech