Interview Questions

Review this list of 4,348 interview questions and answers verified by hiring managers and candidates.
  • "BETWEEN and HAVING clauses in SQL serve different purposes: 1. BETWEEN Clause Used to filter rows based on a range of values. Works with numeric, date, or text values. Can be used with WHERE or HAVING clauses. The range includes both lower and upper bounds. Example: Filtering employees with salaries between 30,000 and 50,000 `SELECT * FROM Employees WHERE salary BETWEEN 30000 AND 50000;` 2. HAVING Clause Used to filter **groups"

    Meenakshi D. - "BETWEEN and HAVING clauses in SQL serve different purposes: 1. BETWEEN Clause Used to filter rows based on a range of values. Works with numeric, date, or text values. Can be used with WHERE or HAVING clauses. The range includes both lower and upper bounds. Example: Filtering employees with salaries between 30,000 and 50,000 `SELECT * FROM Employees WHERE salary BETWEEN 30000 AND 50000;` 2. HAVING Clause Used to filter **groups"See full answer

    Software Engineer
    Concept
    +4 more
  • Software Engineer
    Behavioral
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • TikTok logoAsked at TikTok 
    Product Manager
    Behavioral
  • Meta (Facebook) logoAsked at Meta (Facebook) 
    +1

    "System Components Data Collection Layer Posts with hashtags are asynchronously sent to Kafka topics Each message contains: hashtag, timestamp, userid, postid Multiple Kafka partitions ensure scalability and fault tolerance Processing Layer Apache Flink processes streams in real-time Implements sliding window aggregation (1hr, 24hr, 7d windows) Calculates topic popularity using weighted metrics: Post count User engagement (likes, comments) Unique user"

    Usman B. - "System Components Data Collection Layer Posts with hashtags are asynchronously sent to Kafka topics Each message contains: hashtag, timestamp, userid, postid Multiple Kafka partitions ensure scalability and fault tolerance Processing Layer Apache Flink processes streams in real-time Implements sliding window aggregation (1hr, 24hr, 7d windows) Calculates topic popularity using weighted metrics: Post count User engagement (likes, comments) Unique user"See full answer

    Engineering Manager
    System Design
  • "Problem Understanding Is it within FB applications? > Yes FB Date has one on one matching. Can I consider extending existing capability? After matching, are we considering interactions within FB as well? FB mission is to give people power to connect build community and bring the world closer. Building connection through content engagement is the core of the FB product. With increased demand on learning online and velocity of acquiring new skills required to find a job or sustain in"

    Soodong P. - "Problem Understanding Is it within FB applications? > Yes FB Date has one on one matching. Can I consider extending existing capability? After matching, are we considering interactions within FB as well? FB mission is to give people power to connect build community and bring the world closer. Building connection through content engagement is the core of the FB product. With increased demand on learning online and velocity of acquiring new skills required to find a job or sustain in"See full answer

    Product Manager
    Product Design
  • Microsoft logoAsked at Microsoft 

    "T launch the Copilot Plus feature for Surface, follow these steps: Define Value Proposition: Highlight AI-driven enhancements for productivity, creativity, and collaboration tailored to Surface users. Target Audience: Focus on professionals, creators, and students with specific use cases. Product Development: Ensure seamless integration with Surface hardware (touchscreen, Pen) and leverage Azure AI for unique functionalities. Marketing Strategy: Build excitement with teasers, influencer partner"

    Priti S. - "T launch the Copilot Plus feature for Surface, follow these steps: Define Value Proposition: Highlight AI-driven enhancements for productivity, creativity, and collaboration tailored to Surface users. Target Audience: Focus on professionals, creators, and students with specific use cases. Product Development: Ensure seamless integration with Surface hardware (touchscreen, Pen) and leverage Azure AI for unique functionalities. Marketing Strategy: Build excitement with teasers, influencer partner"See full answer

    Technical Program Manager
    Program Sense
  • "import lombok.*; import org.springframework.boot.CommandLineRunner; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.stereotype.Component; import org.springframework.stereotype.Repository; import org.springframework.stereotype.Service; import java.time.LocalDateTime; import java.util.*; @SpringBootApplication public class LldPracticeApplication { public static void main(String[] args) t"

    Yash G. - "import lombok.*; import org.springframework.boot.CommandLineRunner; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.stereotype.Component; import org.springframework.stereotype.Repository; import org.springframework.stereotype.Service; import java.time.LocalDateTime; import java.util.*; @SpringBootApplication public class LldPracticeApplication { public static void main(String[] args) t"See full answer

    Engineering Manager
    System Design
  • "Mock interview 2/3/2025 Google Wallet User Needs (pain points): At physical store: understand the price tag proceed the transaction Audio cue to pick one credit card read the payment machine transaction confirmation (optional) balance hear transaction summary At home: check balance make payment send money receive money understand statement Prioritization Understand the price tag"

    Chloe T. - "Mock interview 2/3/2025 Google Wallet User Needs (pain points): At physical store: understand the price tag proceed the transaction Audio cue to pick one credit card read the payment machine transaction confirmation (optional) balance hear transaction summary At home: check balance make payment send money receive money understand statement Prioritization Understand the price tag"See full answer

    Product Manager
    Product Design
  • +6

    "Clarifying questions I am assuming the time frame for this question is irrelevant as this is a hypothetical question? : Yes Is IG prioritising the creator side or the viewer side more at the moment? : What do you think? I think it should be a balance for the long term sustenance of the network Are all these reels and views in a particular geography or globally? : Globally What is the duration for which these Views are measured? Assume a day Do we know anything about other engagemen"

    Kartikeya N. - "Clarifying questions I am assuming the time frame for this question is irrelevant as this is a hypothetical question? : Yes Is IG prioritising the creator side or the viewer side more at the moment? : What do you think? I think it should be a balance for the long term sustenance of the network Are all these reels and views in a particular geography or globally? : Globally What is the duration for which these Views are measured? Assume a day Do we know anything about other engagemen"See full answer

    Product Manager
    Analytical
    +1 more
  • "I got it right"

    Rudransh V. - "I got it right"See full answer

    Software Engineer
    Data Structures & Algorithms
    +1 more
  • Electronic Arts logoAsked at Electronic Arts 
    Product Manager
    Product Strategy
  • Electronic Arts logoAsked at Electronic Arts 

    "Ada Lovelace. There is much to admire about her: her strict analytical thinking coupled with the spirit of creative vision, which recognized a possibility for computers to do more than simply calculate at a time when it was considered revolutionary. Her ability to bridge between disciplines and see the connections between maths and science and even to poetry resonates within me. I also appreciate how she pursued intellectual passions in the face of huge gender barriers in her time."

    Ashish B. - "Ada Lovelace. There is much to admire about her: her strict analytical thinking coupled with the spirit of creative vision, which recognized a possibility for computers to do more than simply calculate at a time when it was considered revolutionary. Her ability to bridge between disciplines and see the connections between maths and science and even to poetry resonates within me. I also appreciate how she pursued intellectual passions in the face of huge gender barriers in her time."See full answer

    Product Manager
    Behavioral
  • Amazon logoAsked at Amazon 
    Software Engineer
    System Design
  • Data Engineer
    Data Modeling
  • Machine Learning
    System Design
Showing 841-860 of 4348