Filter interviews by
Index is a data structure that improves the speed of data retrieval in a database. Types include clustered, non-clustered, unique, and composite.
Clustered index physically orders the data in the table based on the index key
Non-clustered index creates a separate structure to store the index key and a pointer to the actual data row
Unique index ensures that all values in the index column are unique
Composite index is creat...
Top trending discussions
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
Two dynamic programming challenges at the hard level on LeetCode and 10 medium-level SQL challenge.
posted on 8 Jan 2025
I applied via Company Website and was interviewed in Jul 2024. There was 1 interview round.
I applied via Job Portal and was interviewed before Nov 2023. There were 3 interview rounds.
Use a user table with a column for user type (free, gold, platinum)
Create a user table with columns for user ID, name, email, user type
Use a separate table for user types with columns for type ID and type name
Establish a one-to-many relationship between user and user type tables
Example: user table - user_id, name, email, type_id; user_type table - type_id, type_name
High-level design for a live rank dashboard for a live test with millions of users.
Use a scalable architecture to handle millions of users concurrently.
Implement real-time data processing to update ranks dynamically.
Utilize caching mechanisms to improve performance and reduce load on the database.
Design a user-friendly interface with intuitive data visualization.
Include features for filtering, sorting, and searching to
I applied via campus placement at Motilal Nehru Institute National Institute of Technology (NIT), Allahabad and was interviewed in May 2022. There were 4 interview rounds.
There was 2 coding question
One was easy One was very Difficult
20 MCQ question from Operating system and DBMS
Find the longest consecutive subarray.
Iterate through the array and keep track of the current subarray length.
Update the maximum length as you iterate.
Reset the current subarray length when a non-consecutive element is encountered.
Minimum Spanning Tree (MST) is a tree that connects all vertices in a graph with minimum total edge weight.
MST can be found using Prim's algorithm or Kruskal's algorithm.
Prim's algorithm starts with a single vertex and adds the closest vertex to the tree until all vertices are included.
Kruskal's algorithm starts with the edges with the lowest weight and adds them to the tree as long as they don't create a cycle.
MST has...
posted on 18 May 2024
I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.
Angular pipes are used in Angular applications to transform data before displaying it in the view.
Angular pipes are used to format data in the template.
They can be used to transform data such as currency, dates, and text.
Pipes can be chained together for more complex transformations.
Custom pipes can also be created for specific formatting needs.
Routing is the process of selecting a path for network traffic to travel from one point to another.
Routing involves determining the best path for data packets to travel through a network.
Routers use routing tables to make decisions on how to forward packets.
Routing protocols like OSPF and BGP help routers communicate and update routing information.
Examples of routing include IP routing in the internet and routing withi
Auth guard is a feature in software development that restricts access to certain resources based on user authentication.
Auth guard is commonly used in web applications to control access to certain pages or features.
It checks if a user is authenticated before allowing them to access a specific resource.
Examples include restricting access to admin pages or requiring login to view certain content.
An interceptor is a middleware component that intercepts incoming requests and outgoing responses in a web application.
Interceptors can be used for logging, authentication, authorization, error handling, and more
In Angular, interceptors can be used to modify HTTP requests before they are sent to the server or responses before they are returned to the calling code
posted on 17 Aug 2022
I applied via LinkedIn and was interviewed in Feb 2022. There were 2 interview rounds.
React is a JavaScript library for building user interfaces. It is different from Angular in various ways.
React is a library while Angular is a framework
React uses virtual DOM while Angular uses real DOM
React is more flexible and easier to learn than Angular
Deep copy creates a new object with the same values while shallow copy creates a new reference to the same object
Hoisting is a JavaScript mechanism where variables a...
Implement custom hooks and array flat method
Custom hooks are reusable functions that allow you to extract component logic into reusable functions
Array flat method is used to flatten an array of nested arrays into a single array
To implement custom hooks, create a function that uses the useState and useEffect hooks
To implement array flat method, use the reduce method to flatten the array
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Senior Software Engineer
13
salaries
| ₹22 L/yr - ₹33 L/yr |
Software Engineer
7
salaries
| ₹12 L/yr - ₹15.9 L/yr |
Delivery Lead
5
salaries
| ₹23 L/yr - ₹27 L/yr |
Senior Quality Engineer
5
salaries
| ₹21.9 L/yr - ₹23.7 L/yr |
Quality Engineer
4
salaries
| ₹13.4 L/yr - ₹18.7 L/yr |
Pearson
Cengage
McGraw-Hill Education
Wiley