i
Advantmed
Filter interviews by
I applied via Referral and was interviewed before Jan 2023. There were 2 interview rounds.
Buttons are used when an action needs to be performed, while links are used for navigation.
Buttons are more suitable for actions like submitting a form, saving data, or triggering a function.
Links are used to navigate to different pages or sections within a website.
Buttons provide visual feedback when clicked, while links do not.
Buttons can be styled and customized more easily than links.
Buttons can have different stat
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...
Top trending discussions
posted on 12 Sep 2024
I applied via Company Website and was interviewed in Aug 2024. There were 4 interview rounds.
They asked easy to medium DSA . It includes arrays, strings, recursion.
posted on 9 Sep 2023
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
React hooks are functions that let you use state and other React features without writing a class.
Hooks are functions that let you use state and other React features in functional components
useState() is a hook that allows you to add state to functional components
useEffect() is a hook that allows you to perform side effects in functional components
useContext() is a hook that allows you to use the context API in functio
Liskov Substitution Principle states that objects of a superclass should be replaceable with objects of its subclasses without affecting the program's correctness.
Subtypes must be substitutable for their base types.
Derived classes must be able to replace their base classes without affecting the program's behavior.
Violating this principle can lead to unexpected behavior and errors in the code.
Example: If a program expec...
Oops concept is a programming paradigm that focuses on objects and classes.
Oops stands for Object-Oriented Programming
Key concepts include inheritance, encapsulation, polymorphism, and abstraction
Examples: Class Car with properties like make, model, and methods like start(), stop()
Example: Inheritance - Class SUV extends Car and adds property numSeats
posted on 19 Jun 2024
I was interviewed in May 2024.
posted on 16 Mar 2023
I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.
I was interviewed before Nov 2023.
Simple aarray problems
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
posted on 12 Sep 2024
I applied via Company Website and was interviewed in Aug 2024. There were 4 interview rounds.
based on 12 reviews
Rating in categories
Medical Coder
288
salaries
| ₹1.1 L/yr - ₹4.5 L/yr |
Senior Software Engineer
93
salaries
| ₹6 L/yr - ₹18 L/yr |
Team Lead
88
salaries
| ₹2.8 L/yr - ₹10 L/yr |
Software Test Analyst
82
salaries
| ₹3 L/yr - ₹7.8 L/yr |
Process Associate
56
salaries
| ₹1 L/yr - ₹2.4 L/yr |
Omega Healthcare
MiraMed Ajuba
VeeTechnologies
GeBBS Healthcare Solutions