Interview Questions

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

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

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

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

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

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

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

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

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