Filter interviews by
Stored procedures are precompiled SQL statements that can be called by name, while functions return a single value.
Stored procedures can modify data, while functions cannot
Functions can be used in SQL statements, while stored procedures cannot
Stored procedures can have output parameters, while functions cannot
Functions can be called from within stored procedures, while stored procedures cannot be called from withi...
Filters are used to intercept and modify HTTP requests and responses in MVC.
Filters are used to add functionality to MVC applications.
There are five types of filters in MVC: Authorization, Action, Result, Exception, and Resource.
Authorization filters are used to authenticate users and restrict access to certain actions.
Action filters are used to modify the behavior of an action method before and after execution.
Re...
OOPs concepts are the fundamental principles of object-oriented programming.
Encapsulation - bundling of data and methods that operate on that data
Inheritance - ability of a class to inherit properties and characteristics from its parent class
Polymorphism - ability of an object to take on many forms
Abstraction - hiding of complex implementation details from the user
Web API routing is the process of mapping incoming HTTP requests to specific actions or methods in the API.
Routing is defined in the WebApiConfig.cs file in the App_Start folder.
Routes are defined using the HttpRouteCollection class.
Routes can include parameters, constraints, and defaults.
Attribute routing can also be used to define routes directly on controller actions.
Routing can be used to handle different HTTP...
CTE stands for Common Table Expression in SQL Server.
CTE is a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
It helps to simplify complex queries and improve performance.
It can be recursive, allowing a query to reference itself.
It starts with the WITH keyword followed by the name of the CTE and the SELECT statement that defines it.
ASP.NET supports two types of routing: convention-based routing and attribute routing.
Convention-based routing uses a set of predefined rules to map incoming URLs to controller actions.
Attribute routing allows developers to define routes directly on the controller actions using attributes.
Both types of routing can be used together in the same application.
Example: [Route("api/products/{id}")] public IHttpActionResu...
OOPs concepts are the fundamental principles of object-oriented programming.
Encapsulation - bundling of data and methods that operate on that data
Inheritance - ability of a class to inherit properties and characteristics from its parent class
Polymorphism - ability of an object to take on many forms
Abstraction - hiding of complex implementation details from the user
Web API routing is the process of mapping incoming HTTP requests to specific actions or methods in the API.
Routing is defined in the WebApiConfig.cs file in the App_Start folder.
Routes are defined using the HttpRouteCollection class.
Routes can include parameters, constraints, and defaults.
Attribute routing can also be used to define routes directly on controller actions.
Routing can be used to handle different HTTP meth...
Stored procedures are precompiled SQL statements that can be called by name, while functions return a single value.
Stored procedures can modify data, while functions cannot
Functions can be used in SQL statements, while stored procedures cannot
Stored procedures can have output parameters, while functions cannot
Functions can be called from within stored procedures, while stored procedures cannot be called from within fun...
CTE stands for Common Table Expression in SQL Server.
CTE is a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
It helps to simplify complex queries and improve performance.
It can be recursive, allowing a query to reference itself.
It starts with the WITH keyword followed by the name of the CTE and the SELECT statement that defines it.
ASP.NET supports two types of routing: convention-based routing and attribute routing.
Convention-based routing uses a set of predefined rules to map incoming URLs to controller actions.
Attribute routing allows developers to define routes directly on the controller actions using attributes.
Both types of routing can be used together in the same application.
Example: [Route("api/products/{id}")] public IHttpActionResult Ge...
Filters are used to intercept and modify HTTP requests and responses in MVC.
Filters are used to add functionality to MVC applications.
There are five types of filters in MVC: Authorization, Action, Result, Exception, and Resource.
Authorization filters are used to authenticate users and restrict access to certain actions.
Action filters are used to modify the behavior of an action method before and after execution.
Result ...
I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.
Quants verbal technical etc
Tricky dsa probs on arrays,stacks
Top trending discussions
I applied via LinkedIn and was interviewed before Jul 2021. There were 2 interview rounds.
Easy logical questions
basic quant
Easy level coding questions
Counting frequency of alphabets
I applied via Naukri.com and was interviewed before Sep 2019. There were 6 interview rounds.
I applied via Walk-in and was interviewed before Sep 2019. There were 3 interview rounds.
I appeared for an interview before Aug 2016.
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
I applied via Referral
Convert a sorted array to balanced binary search tree
Find the middle element of the array and make it the root of the tree
Recursively construct the left subtree using the left half of the array
Recursively construct the right subtree using the right half of the array
Repeat until all elements are added to the tree
Reverse a singly linked list in groups of k inplace
Divide the linked list into groups of k nodes
Reverse each group of k nodes
Connect the reversed groups to form the final linked list
A recursive routine to calculate a ^ n
The base case is when n is 0, in which case the result is 1
For any other value of n, the result is a multiplied by the result of a^(n-1)
The recursive function should call itself with a^(n-1) as the new input
Design optimal data structure for never-ending stream of numbers for insertion, deletion, searching, kth largest and kth smallest.
Use a balanced binary search tree like AVL or Red-Black tree for efficient insertion, deletion, and searching.
Maintain two heaps, one for kth largest and one for kth smallest.
For finding kth largest, use a min heap of size k and for kth smallest, use a max heap of size k.
Alternatively, use a...
I appeared for an interview before Sep 2016.
Search an element in sorted rotated array.
Use binary search to find the pivot point where the array is rotated.
Divide the array into two subarrays and perform binary search on the appropriate subarray.
Handle the cases where the target element is at the pivot point or not present in the array.
Find the Kth largest element in an array.
Sort the array in descending order and return the element at index K-1.
Use a max heap to find the Kth largest element efficiently.
Implement a quickselect algorithm to find the Kth largest element in linear time.
Reverse a linked list in groups of n elements.
Divide the linked list into groups of n elements.
Reverse each group individually.
Connect the reversed groups to form the final linked list.
Handle cases where the number of elements is not a multiple of n.
Example: 1->2->3->4->5->6->7->8, n=3 -> 3->2->1->6->5->4->8->7
Find the median of two sorted arrays.
Merge the two arrays into one sorted array and find the median.
Use binary search to find the median in O(log(min(m, n))) time complexity.
Handle edge cases like empty arrays or arrays of different lengths.
Count number of paths from (0, 0) to (m, n) in a matrix while crossing through some indexes were not allowed.
Use dynamic programming to solve the problem
Create a 2D array to store the number of paths
Traverse the matrix and update the array based on the allowed paths
Return the value at the last index of the array
based on 2 interview experiences
Difficulty level
Duration
based on 3 reviews
Rating in categories
Software Engineer
52
salaries
| ₹6 L/yr - ₹20 L/yr |
Associate Software Engineer
24
salaries
| ₹6.6 L/yr - ₹12 L/yr |
Test Engineer
17
salaries
| ₹7 L/yr - ₹12 L/yr |
Senior Software Engineer
16
salaries
| ₹11.4 L/yr - ₹22.8 L/yr |
Senior Test Engineer
11
salaries
| ₹12 L/yr - ₹14.2 L/yr |
Accenture
Capgemini
HCLTech
Teleperformance