Filter interviews by
Optimizing PHP and MySQL queries involves using indexes, optimizing queries, and reducing data transfer.
Use indexes to speed up data retrieval
Optimize queries by avoiding unnecessary joins and subqueries
Reduce data transfer by selecting only necessary columns
Use caching to avoid repetitive queries
Avoid using SELECT *
Use EXPLAIN to analyze query performance
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
I applied via Internshala and was interviewed before Sep 2021. There were 2 interview rounds.
I applied via Recruitment Consultant and was interviewed in May 2020. There were 3 interview rounds.
Diameter of a binary tree is the longest path between any two leaf nodes.
Calculate the height of left and right subtrees recursively.
Calculate the diameter recursively using the formula max(left_height + right_height + 1, max(left_diameter, right_diameter)).
Return the maximum diameter.
To find interchanged terms from an AP series
Identify the common difference between terms
Swap the positions of adjacent terms
Check if the new series is also an AP
Repeat until no more interchanged terms can be found
Database indexing is a technique to improve the performance of database queries.
Indexing creates a data structure that allows for faster retrieval of data.
Indexes are created on one or more columns of a table.
Queries that use indexed columns can be executed faster.
Indexes can be clustered or non-clustered.
Clustered indexes determine the physical order of data in a table.
Non-clustered indexes create a separate structure...
I applied via LinkedIn and was interviewed before Jan 2024. There were 2 interview rounds.
1 DSA and some simple programming questions asked.
I applied via Walk-in and was interviewed before Jan 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Will be given Requirement to write code for Restraunt. Based on that have write code for delivering orders by delivery boys.
I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.
Sales Manager
5
salaries
| ₹7.2 L/yr - ₹13 L/yr |
Software Engineer
4
salaries
| ₹3 L/yr - ₹6.5 L/yr |
Business Development Manager
3
salaries
| ₹6.4 L/yr - ₹10.1 L/yr |
Senior Sales Associate
3
salaries
| ₹4.8 L/yr - ₹7 L/yr |
Senior Associate Operations
3
salaries
| ₹4 L/yr - ₹5 L/yr |
Shiprocket Private Limited
Delhivery
Ecom Express
Shadowfax Technologies