Filter interviews by
Indexing, viewing, and optimization techniques are essential for improving database performance.
Use indexes to quickly retrieve data from tables
Regularly analyze and optimize queries for better performance
Utilize views to simplify complex queries and improve readability
Consider partitioning tables for better manageability and performance
Use tools like explain plans to analyze query performance
MVC is a design pattern for organizing code in web applications, while ADO.NET is a data access technology for connecting to databases.
MVC stands for Model-View-Controller and helps in separating concerns in web applications.
ADO.NET is a data access technology in .NET framework for connecting to databases.
Filters in MVC are used to add pre-processing or post-processing logic to controller actions.
Resultset in MVC refer...
Functions in SQL server can be ranked based on their usage, complexity, and performance.
Rank functions based on usage - COUNT, SUM, AVG, MAX, MIN
Rank functions based on complexity - CASE, COALESCE, ISNULL
Rank functions based on performance - ROW_NUMBER, RANK, DENSE_RANK
Top trending discussions
I applied via Job Portal
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Loop in linked list is a situation where a node points to a previous node in the list, creating an infinite loop.
Check for loops using Floyd's cycle detection algorithm
Use two pointers, one moving twice as fast as the other, to detect a loop
If the fast pointer catches up to the slow pointer, there is a loop
Two easy questions two wasy questions two easy questions two easy questions
1 coding question, and basic MCQ
I applied via Referral and was interviewed in Aug 2021. There was 1 interview round.
Find k min elements in given array.
Sort the array and return the first k elements.
Use a min heap of size k to find the k min elements.
Use quickselect algorithm to find the kth smallest element and return first k elements smaller than it.
Check if a given tree is a Binary Search Tree (BST) or not.
Traverse the tree in-order and check if the elements are in ascending order.
Check if the maximum value in the left subtree is less than the root and the minimum value in the right subtree is greater than the root.
Use recursion to check if all subtrees are BSTs.
Time complexity: O(n), Space complexity: O(h) where h is the height of the tree.
Given a BST and a sum, find a pair of nodes whose values add up to the given sum.
Traverse the BST in-order and store the nodes in a list
Use two pointers approach to find the pair with the given sum
If the sum is less than the current pair, move the right pointer to the left
If the sum is greater than the current pair, move the left pointer to the right
If the sum is equal to the current pair, return the pair
Time complexit
Prepare well on coding n programming
Topic will be give should talk for a min
FIFO stands for First In, First Out. LIFO stands for Last In, First Out.
FIFO is a method for organizing and manipulating a data buffer, where the first element added is the first to be removed.
LIFO is a method where the last element added is the first to be removed.
FIFO is like a queue, while LIFO is like a stack.
Example: In a FIFO queue, if elements A, B, and C are added in that order, they will be removed in the same...
In Mu Sigma APT round is divided into 3 sections Quant, Logical and verbal
I applied via Referral and was interviewed before Dec 2023. There were 2 interview rounds.
OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
OOP focuses on creating objects that interact with each other to solve problems.
Key concepts include classes, objects, inheritance, polymorphism, and encapsulation.
Classes are blueprints for creating objects, while objects are instances of classes.
Inheritance allows a class to i...
Coding was good and it was based on bubble sort
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Senior Quality Analyst
125
salaries
| ₹3.3 L/yr - ₹8.5 L/yr |
Medical Coder
98
salaries
| ₹1.8 L/yr - ₹6.5 L/yr |
Group Coordinator
97
salaries
| ₹4.2 L/yr - ₹9.4 L/yr |
Senior Specialist
81
salaries
| ₹3.5 L/yr - ₹6.5 L/yr |
Specialist
70
salaries
| ₹2.5 L/yr - ₹5.8 L/yr |
Indegene
Markets and Markets
Coronis Health
Quintessence Business Solutions & Services