Filter interviews by
SQL server query optimization involves improving the performance of SQL queries by reducing execution time and resource usage.
Use indexes to speed up query performance
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using appropriate join types and conditions
Use query execution plans to identify bottlenecks and optimize accordingly
Top trending discussions
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 3 interview rounds.
posted on 4 May 2019
I applied via Naukri.com and was interviewed in Oct 2018. There were 3 interview rounds.
This question involves creating a specific pattern using loops and conditional statements in programming.
Identify the desired pattern (e.g., asterisks, numbers).
Use nested loops: outer loop for rows, inner loop for columns.
Control the output format with conditional statements.
Example: For a pyramid pattern, increase spaces and asterisks in each row.
posted on 13 Jan 2021
I applied via Referral and was interviewed before Jan 2020. There was 1 interview round.
We are using a variety of technologies, including some of the latest ones.
We are using React for our front-end development.
We are also using Node.js for our back-end development.
We are using Docker for containerization.
We are using Kubernetes for orchestration.
We are using AWS for cloud hosting.
We are constantly evaluating new technologies to see if they can improve our development process.
It depends on the specific requirements and constraints of the project.
Consider the project's goals and objectives
Evaluate the available technologies and their capabilities
Assess the project's budget and timeline
Consult with stakeholders and experts in the field
Examples: React vs Angular, MySQL vs MongoDB, Java vs Python
I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Normal apptitude queations were asked in this round
I appeared for an interview before Oct 2023.
A React Todo List app allows users to create, manage, and delete tasks efficiently using state management.
Use functional components and hooks like useState for managing state.
Implement a form to add new todos, capturing input with controlled components.
Display the list of todos using the map function to render each item.
Add functionality to mark todos as completed, possibly using a checkbox.
Include a delete button for ...
Closure in JavaScript allows a function to access variables from its outer scope even after the outer function has finished executing.
Closure is created when a function is defined within another function and the inner function references variables from the outer function.
The inner function maintains a reference to the outer function's scope, allowing it to access those variables even after the outer function has return...
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
I applied via LinkedIn and was interviewed before Nov 2023. There was 1 interview round.
Had to brief about myself, my technical skills and projects. Few Technical questions regarding the tech stack and casual discussion.
I appeared for an interview before Jun 2024, where I was asked the following questions.
Projects often face challenges like tight deadlines, scope changes, and team dynamics that impact delivery and quality.
Tight deadlines can lead to rushed development, resulting in bugs. For example, a project with a 2-week deadline saw a 30% increase in post-release issues.
Scope changes during development can derail timelines. In one project, adding new features mid-cycle delayed the launch by a month.
Team dynamics and...
based on 1 interview experience
Salesforce Developer
18
salaries
| ₹2.4 L/yr - ₹6 L/yr |
Senior Associate
9
salaries
| ₹1.8 L/yr - ₹11 L/yr |
Data Engineer
7
salaries
| ₹3 L/yr - ₹3.3 L/yr |
Information Technology Recruiter
7
salaries
| ₹1.8 L/yr - ₹5.2 L/yr |
Associate
5
salaries
| ₹2.4 L/yr - ₹5 L/yr |
Accel Frontline
Apmosys Technologies
Pitney Bowes
DynPro