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'm a passionate software engineer with a strong background in full-stack development and a love for problem-solving.
Graduated with a degree in Computer Science from XYZ University.
Worked at ABC Corp, where I developed a web application that improved user engagement by 30%.
Proficient in languages like JavaScript, Python, and Java, with experience in frameworks such as React and Django.
Enjoy collaborating in agile teams...
Two easy questions two wasy questions two easy questions two easy questions
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...
1 coding question, and basic MCQ
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Find the largest rectangle containing only 1s in a binary matrix.
Use dynamic programming to track heights of consecutive 1s.
For each row, treat it as a histogram and calculate the maximal rectangle.
Utilize a stack to efficiently compute the largest rectangle in a histogram.
Example: For a matrix [[0,1,1],[1,1,0],[1,1,1]], the largest rectangle has area 4.
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
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
posted on 10 Sep 2023
It was an easy test. It consisted of MCQs and two coding qns. Prepare SQL well. It also had 2 programming question. Both were medium difficukty
posted on 5 Feb 2025
Old process take aptitude test
3 questions 3 sum linked list missing sum
System design involves creating a high-level architecture of a software system, while HR principles focus on managing people effectively.
System design involves identifying components, defining their interactions, and ensuring scalability and reliability.
HR principles include hiring the right talent, providing training and development opportunities, and fostering a positive work culture.
Both system design and HR princip...
based on 1 interview experience
Difficulty level
based on 3 reviews
Rating in categories
Senior Quality Analyst
123
salaries
| ₹3.3 L/yr - ₹8.5 L/yr |
Medical Coder
103
salaries
| ₹2.5 L/yr - ₹6.7 L/yr |
Group Coordinator
97
salaries
| ₹4.2 L/yr - ₹9.3 L/yr |
Senior Specialist
82
salaries
| ₹3.5 L/yr - ₹6.5 L/yr |
Specialist
79
salaries
| ₹2.5 L/yr - ₹7.9 L/yr |
Markets and Markets
Ascent Business Solutions
Coronis Health
Quintessence Business Solutions & Services