Filter interviews by
SQL joins combine rows from two or more tables based on related columns, essential for relational database queries.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.a_id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.a_id;
RIGHT JOIN: Returns all records fro...
Calculate the number of hotel bookings from a given dataset of hotels and their booking details.
Identify the data structure: Ensure the dataset contains booking information, such as hotel ID, customer ID, and booking dates.
Count unique bookings: Use a method to count unique entries based on hotel ID and booking dates to avoid duplicates.
Example: If hotel A has 3 bookings on different dates and hotel B has 2 bookin...
Determine if a continuous subarray sums to a multiple of k.
A continuous subarray is defined as a sequence of elements from the array.
The sum of the subarray must be a multiple of k (i.e., sum % k == 0).
Example: For nums = [23, 2, 4, 6, 7] and k = 6, the subarray [2, 4] sums to 6, which is a multiple of 6.
Use a hashmap to store the cumulative sum and its index to check for previous occurrences.
If the same cumulativ...
Dynamic programming approach to solve the stair climbing problem efficiently.
Define the problem: Given n stairs, find the number of ways to reach the top.
Base cases: If n = 0, return 1; if n = 1, return 1.
Recurrence relation: ways(n) = ways(n-1) + ways(n-2).
Use an array to store results of subproblems to avoid recomputation.
Example: For n = 4, ways(4) = ways(3) + ways(2) = 3 + 2 = 5.
Determine the best time to buy and sell stock to maximize profit from given price data.
Identify the lowest price to buy before a higher price to sell.
Track price changes over time to find optimal buy/sell points.
Example: Prices = [7, 1, 5, 3, 6, 4]; Buy at 1, sell at 6 for max profit of 5.
Consider edge cases: prices always decreasing means no profit can be made.
Longest common subsequence is the longest sequence of characters that appear in the same order in two or more strings.
Use dynamic programming to solve this problem efficiently.
Create a 2D array to store the lengths of longest common subsequences of substrings.
Traverse the array to find the longest common subsequence.
posted on 7 Oct 2023
Easy basic dsa questions
Dynamic programming approach to solve the stair climbing problem efficiently.
Define the problem: Given n stairs, find the number of ways to reach the top.
Base cases: If n = 0, return 1; if n = 1, return 1.
Recurrence relation: ways(n) = ways(n-1) + ways(n-2).
Use an array to store results of subproblems to avoid recomputation.
Example: For n = 4, ways(4) = ways(3) + ways(2) = 3 + 2 = 5.
Longest common subsequence is the longest sequence of characters that appear in the same order in two or more strings.
Use dynamic programming to solve this problem efficiently.
Create a 2D array to store the lengths of longest common subsequences of substrings.
Traverse the array to find the longest common subsequence.
Determine the best time to buy and sell stock to maximize profit from given price data.
Identify the lowest price to buy before a higher price to sell.
Track price changes over time to find optimal buy/sell points.
Example: Prices = [7, 1, 5, 3, 6, 4]; Buy at 1, sell at 6 for max profit of 5.
Consider edge cases: prices always decreasing means no profit can be made.
Implement various operations on a linked list and solve related problems like reversing a linked list or detecting a cycle.
Understand the basic structure of a linked list with nodes containing data and a reference to the next node.
For insertion, update the pointers of the nodes accordingly to maintain the sequence.
For deletion, adjust the pointers to skip the node to be deleted.
To reverse a linked list, iterate through...
Calculate the number of hotel bookings from a given dataset of hotels and their booking details.
Identify the data structure: Ensure the dataset contains booking information, such as hotel ID, customer ID, and booking dates.
Count unique bookings: Use a method to count unique entries based on hotel ID and booking dates to avoid duplicates.
Example: If hotel A has 3 bookings on different dates and hotel B has 2 bookings, t...
SQL joins combine rows from two or more tables based on related columns, essential for relational database queries.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.a_id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.a_id;
RIGHT JOIN: Returns all records from the...
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
He will be asking you about the logic you used to solve the OA questions. So prepare well.
He then asked questions from my resume and asked me to code and explain cycle in a linked list. I easily did the coding part using brute force and optimized approach but then he asked my to give proof that why tortoise and hare algo will work here. I explained him the mathematical proof.
Determine if a continuous subarray sums to a multiple of k.
A continuous subarray is defined as a sequence of elements from the array.
The sum of the subarray must be a multiple of k (i.e., sum % k == 0).
Example: For nums = [23, 2, 4, 6, 7] and k = 6, the subarray [2, 4] sums to 6, which is a multiple of 6.
Use a hashmap to store the cumulative sum and its index to check for previous occurrences.
If the same cumulative sum...
Top trending discussions
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
SEO stands for Search Engine Optimization. It is the process of optimizing a website to improve its visibility on search engines.
SEO involves optimizing website content, meta tags, and backlinks to improve search engine rankings.
Keywords play a crucial role in SEO, as they help search engines understand the content of a website.
Quality content, mobile optimization, and user experience are also important factors in SEO.
...
SEO checklist includes keyword research, on-page optimization, link building, and tracking results.
Perform keyword research to identify relevant keywords for your website
Optimize on-page elements such as title tags, meta descriptions, and headings
Build high-quality backlinks from reputable websites
Track and analyze SEO performance using tools like Google Analytics
Content optimization involves improving the quality and relevance of content to increase visibility and engagement.
Research keywords and incorporate them strategically into the content
Optimize meta tags and descriptions for search engines
Create high-quality, engaging content that provides value to the audience
Use internal and external links to improve SEO
Regularly update and refresh content to keep it relevant and curr...
To work with a team on different projects, communication, delegation, collaboration, and flexibility are key.
Communicate clearly with team members about project goals and expectations.
Delegate tasks based on team members' strengths and expertise.
Collaborate effectively by encouraging open communication and feedback.
Be flexible and adaptable to changes in project scope or timeline.
Provide support and resources to team m...
Initiating audits of a website involves planning, conducting, and analyzing the review process to ensure compliance and effectiveness.
Develop a comprehensive audit plan outlining the scope, objectives, and methodology.
Utilize automated tools to scan for technical issues such as broken links, duplicate content, and page load speed.
Manually review the website for design, content accuracy, user experience, and SEO optimiz...
I am currently earning $60,000 per year.
My current salary is $60,000 per year.
I am earning $5,000 per month.
I received a 10% raise last year, bringing my salary to $60,000.
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the Team Lead role.
Research industry standards and salary ranges for Team Lead positions
Consider my level of experience and expertise in the field
Factor in the scope of responsibilities and leadership required for the role
Negotiate based on the company's budget and benefits package
Be open to discussing salary expectations ...
I applied via Referral and was interviewed before Sep 2021. There were 2 interview rounds.
I applied via Referral and was interviewed before Apr 2022. There were 3 interview rounds.
Firstly, they will see your portfolio than will give you assignment to complete.
I applied via Approached by Company and was interviewed in Dec 2022. There were 3 interview rounds.
posted on 4 Mar 2025
SEO audits for the website
based on 6 interview experiences
Difficulty level
Duration
Software Engineer
7
salaries
| ₹9 L/yr - ₹22.5 L/yr |
Data Analyst
4
salaries
| ₹4.2 L/yr - ₹10 L/yr |
Web Developer
4
salaries
| ₹1.2 L/yr - ₹3 L/yr |
Territory Manager
4
salaries
| ₹3.5 L/yr - ₹4.5 L/yr |
Business Head
4
salaries
| ₹40 L/yr - ₹48 L/yr |
CallOne Consultants
Viska
Conversion Perk
K and A Technology