Skip to main content

Interview Questions

Review this list of 4,477 interview questions and answers verified by hiring managers and candidates.
  • Meta logoAsked at Meta 
    4 answers
    +1

    "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"

    Bala G. - "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"See full answer

    Data Scientist
    Coding
    +2 more
  • Meta logoAsked at Meta 
    13 answers
    +8

    "Answer: select fromcaller, count(DISTINCT tocallee) as num_calls from calls group by fromcaller having count(DISTINCT tocallee) >= 3 Setup: CREATE TABLE calls ( from_caller VARCHAR(20), to_callee VARCHAR(20) ); INSERT INTO calls (fromcaller, tocallee) VALUES ('Alice', 'Bob'), ('Charlie', 'Dave'), ('Alice', 'Frank'), ('Charlie', 'Heidi'), ('Charlie', 'Judy'); "

    KAI - "Answer: select fromcaller, count(DISTINCT tocallee) as num_calls from calls group by fromcaller having count(DISTINCT tocallee) >= 3 Setup: CREATE TABLE calls ( from_caller VARCHAR(20), to_callee VARCHAR(20) ); INSERT INTO calls (fromcaller, tocallee) VALUES ('Alice', 'Bob'), ('Charlie', 'Dave'), ('Alice', 'Frank'), ('Charlie', 'Heidi'), ('Charlie', 'Judy'); "See full answer

    Data Scientist
    Coding
    +3 more
  • "Thank you for the question - before I can begin, I would like to understand the question further. A. Clarification: I am the PM for overall Insta reels or any specific platform > Reels I am assuming we are evaluating the performance of the reels globally > Yes I will also assume that we are defining the current metrics / performance of reels and not specific to a new roll out. > yes B. Funnel - understanding the product To make sure I understand the product correctly, Re"

    Abhi - "Thank you for the question - before I can begin, I would like to understand the question further. A. Clarification: I am the PM for overall Insta reels or any specific platform > Reels I am assuming we are evaluating the performance of the reels globally > Yes I will also assume that we are defining the current metrics / performance of reels and not specific to a new roll out. > yes B. Funnel - understanding the product To make sure I understand the product correctly, Re"See full answer

    Product Manager
    Analytical
  • DoorDash logoAsked at DoorDash 
    1 answer

    "Went through scenarios where a user Interviewer asked me to select a scenario, mostly outside of the control of the app. The interviewer saw me rattled and suggested the need to get to a venue as an experience. I designed a solution and suggested an MVP. The goal was to select a scenario, design MVP and suggest user journey/cohort selection and demonstrate measurement."

    Bharat D. - "Went through scenarios where a user Interviewer asked me to select a scenario, mostly outside of the control of the app. The interviewer saw me rattled and suggested the need to get to a venue as an experience. I designed a solution and suggested an MVP. The goal was to select a scenario, design MVP and suggest user journey/cohort selection and demonstrate measurement."See full answer

    Product Manager
    Product Design
  • Google logoAsked at Google 
    2 answers

    "Its enough that I shared the question. Im not going to tell you how I answered. If you dont know how to answer, then this isn't the job or company for you. Sorry."

    David E. - "Its enough that I shared the question. Im not going to tell you how I answered. If you dont know how to answer, then this isn't the job or company for you. Sorry."See full answer

    Product Manager
    Product Strategy
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • Amazon logoAsked at Amazon 
    13 answers
    +8

    "I firstly discuss the brute force approach in O(n^2) time complexity , than i moved to O(nlogn) tine complexity than i discussed the O(n) time complexity and O(n) space complexity . But interviewer want more optimised solution , in O(n) time complexity without using extra space , The solution wants O(1) space complexity i have to do changes in same array without using any space . This method is something like i have to place positive values to its original position by swapping and rest negativ"

    Anni P. - "I firstly discuss the brute force approach in O(n^2) time complexity , than i moved to O(nlogn) tine complexity than i discussed the O(n) time complexity and O(n) space complexity . But interviewer want more optimised solution , in O(n) time complexity without using extra space , The solution wants O(1) space complexity i have to do changes in same array without using any space . This method is something like i have to place positive values to its original position by swapping and rest negativ"See full answer

    Software Engineer
    Data Structures & Algorithms
    +1 more
  • Meta logoAsked at Meta 
    Add answer
    Machine Learning Engineer
    System Design
  • Revolut logoAsked at Revolut 
    5 answers
    +1

    "Clarify understanding of the problem space. What does success look like? How is it measured? Platform specific? Market specific? Time period? Business goals? Then perform a funnel analysis to understand user journey and look for problems or opportunities. Choose a user segment to focus on. Identify different user segments and prioritise one. Summarise the goal of the user and the friction point. Brainstorm solutions. Come up with a number of rough solutions. Balance the business n"

    Alice S. - "Clarify understanding of the problem space. What does success look like? How is it measured? Platform specific? Market specific? Time period? Business goals? Then perform a funnel analysis to understand user journey and look for problems or opportunities. Choose a user segment to focus on. Identify different user segments and prioritise one. Summarise the goal of the user and the friction point. Brainstorm solutions. Come up with a number of rough solutions. Balance the business n"See full answer

    Product Manager
    Product Strategy
  • +7

    "Clarify the problem. Ask lots of questions to uncover the root cause of the problem. This could be related to internal factors like releasing buggy updates or external factors like market trends, infrastructure, regulation etc etc. Establish where in the user journey the problem might be happening, if it's happening for a subset of users or for everyone e.g. on iOS platform etc etc, what time period has the problem occurred? Gradually or suddenly? How is the metric (in this case revenue)"

    Alice S. - "Clarify the problem. Ask lots of questions to uncover the root cause of the problem. This could be related to internal factors like releasing buggy updates or external factors like market trends, infrastructure, regulation etc etc. Establish where in the user journey the problem might be happening, if it's happening for a subset of users or for everyone e.g. on iOS platform etc etc, what time period has the problem occurred? Gradually or suddenly? How is the metric (in this case revenue)"See full answer

    Product Manager
    Analytical
    +1 more
  • Google logoAsked at Google 
    4 answers

    "As a postgraduate student of computer science, one of my weaknesses might be that I sometimes focus too much on theoretical concepts, which can lead to delays in practical implementation. I also find that while I’m strong in certain areas like algorithms and data structures, I need to spend more time refining my skills in newer technologies or languages that aren't part of the core curriculum. Additionally, balancing research, coursework, and any side projects can be challenging, occasionally le"

    Vipan K. - "As a postgraduate student of computer science, one of my weaknesses might be that I sometimes focus too much on theoretical concepts, which can lead to delays in practical implementation. I also find that while I’m strong in certain areas like algorithms and data structures, I need to spend more time refining my skills in newer technologies or languages that aren't part of the core curriculum. Additionally, balancing research, coursework, and any side projects can be challenging, occasionally le"See full answer

    Frontend Engineer
    Behavioral
    +1 more
  • Meta logoAsked at Meta 
    7 answers
    +4

    "Product Overview: Instagram, a social network owned by Meta, allows users to create and share various types of content, including photos, videos, and Reels, which are short, TikTok-style videos. The platform serves different user segments, including content creators, viewers, and the platform itself as an ecosystem. User Segmentation: I segmented users into three primary categories: Content Creators: This includes businesses, public figures, influencers, and regular users who crea"

    Aviran H. - "Product Overview: Instagram, a social network owned by Meta, allows users to create and share various types of content, including photos, videos, and Reels, which are short, TikTok-style videos. The platform serves different user segments, including content creators, viewers, and the platform itself as an ecosystem. User Segmentation: I segmented users into three primary categories: Content Creators: This includes businesses, public figures, influencers, and regular users who crea"See full answer

    Product Manager
    Analytical
    +1 more
  • BizOps & Strategy
    Product Strategy
  • Meta logoAsked at Meta 
    9 answers
    +6

    "Introduction UberSenior is a new service offered by Uber that provides safe, reliable, and convenient transportation for senior citizens. This PRD outlines the key features, functionalities, and user experience for both seniors and drivers using UberSenior. Problem Statement Existing transportation options for seniors often have limitations, including: Accessibility: Lack of vehicles equipped for mobility aids or physical limitations Technology barriers: Difficulty using smartphone"

    Shubham S. - "Introduction UberSenior is a new service offered by Uber that provides safe, reliable, and convenient transportation for senior citizens. This PRD outlines the key features, functionalities, and user experience for both seniors and drivers using UberSenior. Problem Statement Existing transportation options for seniors often have limitations, including: Accessibility: Lack of vehicles equipped for mobility aids or physical limitations Technology barriers: Difficulty using smartphone"See full answer

    Product Manager
    Product Design
  • 1 answer

    "Hinge is a company that fosters community which I'm passionate about. I'm also excited to work on such an impactful mission to contribute to the safety of its users."

    Rosmary F. - "Hinge is a company that fosters community which I'm passionate about. I'm also excited to work on such an impactful mission to contribute to the safety of its users."See full answer

    Software Engineer
    Behavioral
  • "I like chatgpt for the following users Getting industry references are easy and time saving Getting recommendations is very easy Responses are accurate I use chatgpt to get feedback on content and identify gaps in my documentation or thought process I use chatgpt as a search engine and to get conscise situation based information. Chatgpt offers varierty of other tools in the explore version where similar users can create different content PRD template Chatgpt users 1."

    Shraddha D. - "I like chatgpt for the following users Getting industry references are easy and time saving Getting recommendations is very easy Responses are accurate I use chatgpt to get feedback on content and identify gaps in my documentation or thought process I use chatgpt as a search engine and to get conscise situation based information. Chatgpt offers varierty of other tools in the explore version where similar users can create different content PRD template Chatgpt users 1."See full answer

    Product Manager
    Analytical
    +3 more
  • Capital One logoAsked at Capital One 
    2 answers

    "For this answer, I'm assuming that I'm a PM who has just started at this company. I assume this product is a growing start-up and that's why I wasn't familiar prior to taking the role. Understand the business, mission, and product's context: Understand the company mission, values, vision Understand any near-term/long term company goals Meet & listen to key stakeholders & decision makers Build relationship with team members Understand who the first 'sale' or 'bu"

    Bailey O. - "For this answer, I'm assuming that I'm a PM who has just started at this company. I assume this product is a growing start-up and that's why I wasn't familiar prior to taking the role. Understand the business, mission, and product's context: Understand the company mission, values, vision Understand any near-term/long term company goals Meet & listen to key stakeholders & decision makers Build relationship with team members Understand who the first 'sale' or 'bu"See full answer

    Product Manager
    Product Strategy
  • Add answer
    Site Reliability Engineer
    System Design
  • Product Manager
    Product Design
Showing 1381-1400 of 4477