Filter interviews by
I applied via Naukri.com and was interviewed in Mar 2024. There were 6 interview rounds.
Top trending discussions
I applied via Naukri.com and was interviewed in Sep 2018. There was 1 interview round.
I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.
I applied via Referral and was interviewed before Jan 2023. There were 2 interview rounds.
Buttons are used for actions within the form, while links are used for navigation.
Buttons can trigger JavaScript functions or perform form validation before submission
Buttons can have different styles and behaviors compared to links
Buttons are more accessible for users with disabilities
Optimize a SQL procedure with 5000 lines of code by identifying bottlenecks and implementing performance improvements.
Identify and analyze the most time-consuming parts of the procedure
Optimize queries by adding appropriate indexes, rewriting queries, or using query hints
Break down the procedure into smaller, more manageable parts
Use temporary tables or table variables to reduce the amount of data processed at once
Cons...
To optimize SQL procedures, keep them short, use small procedures with specific functionality, avoid temp tables and joins, use select statements wisely, avoid subqueries and dynamic SQL.
Break down complex procedures into smaller ones with specific functionality
Avoid using temporary tables and joins whenever possible
Use select statements wisely to retrieve only the necessary data
Avoid subqueries and find alternative ap...
I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 6 interview rounds.
SQL query to find latest record in a table with and without subquery
Without subquery: SELECT * FROM table_name ORDER BY date_column DESC LIMIT 1
With subquery: SELECT * FROM table_name WHERE date_column = (SELECT MAX(date_column) FROM table_name)
posted on 6 Aug 2024
Skill test and technical knowledge evaluation
I appeared for an interview in Jul 2022.
They ask you open Hacker Earth site and choose some random programs and ask you to complete it.
Multi threading is the ability of a program to perform multiple tasks concurrently.
It allows for better utilization of CPU resources
It can improve program performance and responsiveness
Examples include web servers handling multiple requests simultaneously and video games rendering graphics while processing user input
The extend keyword is used to add properties and methods to an existing object.
Used in JavaScript to add properties and methods to an object
Can be used to inherit properties and methods from a parent object
Syntax: Object.assign(target, ...sources)
Example: const obj1 = {a: 1}; const obj2 = {b: 2}; const obj3 = {...obj1, ...obj2};
Override is used to provide a new implementation of a method in a subclass. Virtual is needed to allow the method to be overridden.
Override is used to change the behavior of a method in a subclass
Virtual is used to allow the method to be overridden in a subclass
Without virtual, a subclass cannot override a method from its parent class
Override is used to implement polymorphism in object-oriented programming
Program to sort and remove duplicates from an array.
Use built-in sort() method to sort the array in ascending order.
Loop through the sorted array and remove duplicates using filter() method.
Return the sorted and duplicate-free array.
Is Relationship and As Relationship are two types of relationships in object-oriented programming.
Is Relationship is a type of relationship where one class is a subset of another class.
As Relationship is a type of relationship where one class is a type of another class.
Is Relationship is denoted by a solid line with a closed arrowhead pointing towards the superclass.
As Relationship is denoted by a dotted line with an o...
Architectural, structural, and behavioral design patterns are reusable solutions to common software design problems.
Architectural patterns define the overall structure of a software system
Structural patterns describe how objects and classes can be combined to form larger structures
Behavioral patterns focus on communication between objects and how they operate together
Design patterns help to improve software quality, ma...
posted on 19 Jun 2024
I appeared for an interview in May 2024.
posted on 13 May 2024
I applied via Job Portal and was interviewed before May 2023. There was 1 interview round.
1 hour, problem solving using data structures and algorithm
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Software Developer
224
salaries
| ₹6 L/yr - ₹24.6 L/yr |
Senior Software Engineer
155
salaries
| ₹9.1 L/yr - ₹27.4 L/yr |
Senior Systems Engineer
106
salaries
| ₹8 L/yr - ₹22.2 L/yr |
Software Engineer
74
salaries
| ₹7 L/yr - ₹23 L/yr |
Senior Software Developer
50
salaries
| ₹8.9 L/yr - ₹27 L/yr |
Advantmed
2050 Healthcare
Pacific BPO
Hindustan Latex Family Planning Promotion Trust