Skip to main content

Interview Questions

Review this list of 4,411 interview questions and answers verified by hiring managers and candidates.
  • +7

    "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"

    Gowtami K. - "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"See full answer

    Coding
    SQL
  • +8

    "I couldn't follow the solution offered here, but my solution seemed to pass 6/6 tests. Any feedback is welcome, thank you! def encrypt(word): en_word = "" for i in range(len(word)): if i == 0: en_word += chr(ord(word[0])+1) else: num = ord(word[i]) + ord(en_word[i-1]) while num > 122: num -= 26 en_word += chr(num) return en_word def decrypt(word): de_word = "" for i in range(len(word)): if i == 0: de_word += chr(ord(word[i]"

    Anonymous Armadillo - "I couldn't follow the solution offered here, but my solution seemed to pass 6/6 tests. Any feedback is welcome, thank you! def encrypt(word): en_word = "" for i in range(len(word)): if i == 0: en_word += chr(ord(word[0])+1) else: num = ord(word[i]) + ord(en_word[i-1]) while num > 122: num -= 26 en_word += chr(num) return en_word def decrypt(word): de_word = "" for i in range(len(word)): if i == 0: de_word += chr(ord(word[i]"See full answer

    Data Structures & Algorithms
    Coding
  • Zillow logoAsked at Zillow 

    "Clarifying questions Is there a specific airline we are focusing on here? Assume any US passenger airline (Delta, United, Spirit etc.) Why is this company interested in improving the boarding experience? To increase customer satisfaction Can you define what we mean by 'boarding experience'? The time between the passenger arriving at the gate and sitting down in their assigned seat on the plane. Are there any constraints (resources or otherwise) that I should"

    William W. - "Clarifying questions Is there a specific airline we are focusing on here? Assume any US passenger airline (Delta, United, Spirit etc.) Why is this company interested in improving the boarding experience? To increase customer satisfaction Can you define what we mean by 'boarding experience'? The time between the passenger arriving at the gate and sitting down in their assigned seat on the plane. Are there any constraints (resources or otherwise) that I should"See full answer

    Product Design
    Program Sense
  • Lyft logoAsked at Lyft 

    "Clarifying questions: What's Lyft current goal and how does this new focus on Deaf drivers align with Lyft's goal & strategy? Do Lyft already have service/product to enable deaf users to drive for lyft? Assume We don't have any existing product/service to allow deaf users to drive for Lyft today We are designing for the ridesharing business and that the Deaf drivers can drive for all types of Lyft rideshare options Lyft's Mission: Improve people's lives w/ the world's best transport"

    Mark - "Clarifying questions: What's Lyft current goal and how does this new focus on Deaf drivers align with Lyft's goal & strategy? Do Lyft already have service/product to enable deaf users to drive for lyft? Assume We don't have any existing product/service to allow deaf users to drive for Lyft today We are designing for the ridesharing business and that the Deaf drivers can drive for all types of Lyft rideshare options Lyft's Mission: Improve people's lives w/ the world's best transport"See full answer

    Product Design
    System Design
  • Apple logoAsked at Apple 
    Software Engineer
    System Design
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • Product Manager
    Behavioral
  • Microsoft logoAsked at Microsoft 

    "You are given a string S and a number K as input, and your task is to print S to console output considering that, at most, you can print K characters per line. Example: S = "abracadabra sample" K = 11 Output: abracadabra sample Note that this problem requires the interviewee gather extra requirements from the interviewer (e.g. do we care about multiple white spaces? what if the length of a word is greater than K, ...)"

    B. T. - "You are given a string S and a number K as input, and your task is to print S to console output considering that, at most, you can print K characters per line. Example: S = "abracadabra sample" K = 11 Output: abracadabra sample Note that this problem requires the interviewee gather extra requirements from the interviewer (e.g. do we care about multiple white spaces? what if the length of a word is greater than K, ...)"See full answer

    Software Engineer
    Data Structures & Algorithms
    +1 more
  • Meta logoAsked at Meta 
    +1

    "depending on project phase, apply various methodologies. scrum for app dev, waterfall for data migration, Testing (TDD for dev, FUT FiT for manual, UAT) , OCM has it own methodology ."

    Sayee M. - "depending on project phase, apply various methodologies. scrum for app dev, waterfall for data migration, Testing (TDD for dev, FUT FiT for manual, UAT) , OCM has it own methodology ."See full answer

    Technical Program Manager
    Analytical
    +2 more
  • Google logoAsked at Google 

    "Improve facebook’s feed. Clarifying questions: Do we want to look at desktop or mobile specifically? – Mobile Is there a specific goal we have in mind that we are trying to meet or just general improvements? — General improvements, innovation Clarify Product: The Facebook newsfeed is the content feed that users see when landing on the app. The feed shows content posted by people users follow Within the feed the user is offered updates on people they follow - friends, family, celebrities"

    Kiley S. - "Improve facebook’s feed. Clarifying questions: Do we want to look at desktop or mobile specifically? – Mobile Is there a specific goal we have in mind that we are trying to meet or just general improvements? — General improvements, innovation Clarify Product: The Facebook newsfeed is the content feed that users see when landing on the app. The feed shows content posted by people users follow Within the feed the user is offered updates on people they follow - friends, family, celebrities"See full answer

    Product Manager
    Product Design
  • Meta logoAsked at Meta 

    "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"

    Michael B. - "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"See full answer

    Machine Learning Engineer
    Data Structures & Algorithms
    +1 more
  • Notion logoAsked at Notion 
    Software Engineer
    System Design
  • Snap logoAsked at Snap 

    "Measure the success of SnapMap Clarifying question Snap is the feature which is visible on right swipe on snap chat showing map and location of your friends right? Do we have any specific goal in mind or we want to decide the overall success of the feature? Mission - Help users be connected with their friends and family and be updated about them. That is why the main medium of exchange is photos or videos in Snapchat which keeps people updated which actually putting things in words. Goal"

    Namrata L. - "Measure the success of SnapMap Clarifying question Snap is the feature which is visible on right swipe on snap chat showing map and location of your friends right? Do we have any specific goal in mind or we want to decide the overall success of the feature? Mission - Help users be connected with their friends and family and be updated about them. That is why the main medium of exchange is photos or videos in Snapchat which keeps people updated which actually putting things in words. Goal"See full answer

    Product Manager
    Analytical
  • "In one of the projects I managed, one team member was slipping each of his task's ETAs several times, citing different reasons, and communicating the delay after it already happened. The delay seemed disproportional to the reasons thereof. I first collected sufficient historical data to confirm that this was a pattern, and similar circumstances were faced by other team members, but they were managing to still keep their ETAs. Then I had a talk with the person, and showed him the data. I also ex"

    Surekha G. - "In one of the projects I managed, one team member was slipping each of his task's ETAs several times, citing different reasons, and communicating the delay after it already happened. The delay seemed disproportional to the reasons thereof. I first collected sufficient historical data to confirm that this was a pattern, and similar circumstances were faced by other team members, but they were managing to still keep their ETAs. Then I had a talk with the person, and showed him the data. I also ex"See full answer

    Behavioral
  • Google logoAsked at Google 

    "You should be able to easily identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! "

    Exponent - "You should be able to easily identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! "See full answer

    Product Manager
    Analytical
  • Product Manager
    Artificial Intelligence
  • Google logoAsked at Google 

    "Clarifying Qs: What are we building the Google campus for on the moon? We are the Google X team and always want to move people forward and want to be the first private entity on the moon Are we trying to build for astronauts or our employees or someone else? This will be for employees Do we already have a location on the moon and we're expanding or will this be the first one ever? This is the first one ever. For us to answer this question, we'll want to discuss Google's mission, us"

    Angela - "Clarifying Qs: What are we building the Google campus for on the moon? We are the Google X team and always want to move people forward and want to be the first private entity on the moon Are we trying to build for astronauts or our employees or someone else? This will be for employees Do we already have a location on the moon and we're expanding or will this be the first one ever? This is the first one ever. For us to answer this question, we'll want to discuss Google's mission, us"See full answer

    Product Design
  • Salesforce logoAsked at Salesforce 

    "This is a Diagnosis problem. We've gone over diagnosis problems in the past, but most are centered around usage. Even though this is about retention - do not be alarmed. We can still follow the TROPIC method to create a plan to thoroughly diagnose the issue: Ask clarifying questions List potential high level reasons Gather Context (TROPIC)Time Region Other features / products (internal) Platform Industry / Competition Cannibalization **Establish a theory of proba"

    Exponent - "This is a Diagnosis problem. We've gone over diagnosis problems in the past, but most are centered around usage. Even though this is about retention - do not be alarmed. We can still follow the TROPIC method to create a plan to thoroughly diagnose the issue: Ask clarifying questions List potential high level reasons Gather Context (TROPIC)Time Region Other features / products (internal) Platform Industry / Competition Cannibalization **Establish a theory of proba"See full answer

    Product Manager
    Analytical
    +1 more
  • "Number of visits to the site had increased, so total reservations infact went up, but conversion was down due to more users visiting, due to a promotion offered by the company or may be due to more ad entry points, social media, friend recommendations etc."

    IamaPM - "Number of visits to the site had increased, so total reservations infact went up, but conversion was down due to more users visiting, due to a promotion offered by the company or may be due to more ad entry points, social media, friend recommendations etc."See full answer

    Product Manager
    Analytical
    +1 more
  • "1) create the experimental and control groups. 2) Then calculate the proportion (mean) of the true conversion rates for both groups using the convert column which counts True as 1 and False as 0. This is their conversion rates 3) calculate the statistic of the two groups by subtracting the proportion and standardizing. 4) get the p-value and compare with 0.05. 5) conclude the difference is statistically significant if the p-value is less than 0.05 otherwise no statistical difference"

    Frank A. - "1) create the experimental and control groups. 2) Then calculate the proportion (mean) of the true conversion rates for both groups using the convert column which counts True as 1 and False as 0. This is their conversion rates 3) calculate the statistic of the two groups by subtracting the proportion and standardizing. 4) get the p-value and compare with 0.05. 5) conclude the difference is statistically significant if the p-value is less than 0.05 otherwise no statistical difference"See full answer

    Coding
    Machine Learning
Showing 2121-2140 of 4411