Interview Questions

Akshay D. - "SELECT SUM(orderquantity) AS totalunitsorderedyesterday FROM orders WHERE order_date = DATE('now', '-1 DAY') `"See full answer

Sue G. - "Abstract class A class that can have Abstract methods - without implementations and Concerete Methods i.e with implementation. Can have private, protected and public access modifiers. Supports Single inheritance i.e a class can extend only 1 abstract class Can have constructors Mainly used when sharing common behaviors Interface Class A collection of abstract methods ( can have static and default methods also - onwards of java 8) Public, static, final are the access"See full answer

John F. - "(i) helped others success Over the years, I’ve had a few non-technical friends who wanted to start companies. Around two years ago, one of these friends reached out to ask for some guidance on how to start. This individual wanted to take the Airbnb model and apply it to outdoor recreational activities, mainly hunting and fishing. His problem was he had no frame of reference for where to start of what kind of effort and investment it would take. Over the course of a couple of conversations I help"See full answer

Riku H. - "Before I start, can I ask some clarifying questions? Is Facebook Reels the same as Facebook Watch where a user can go to Watch and consume short clips, react, comment and share them? In terms of measuring success, are you looking at a segment of users like the reel creators or viewers, or is that up to me? (Assume interviewer will say it's totally up to me) Can I also assume that I am looking at the product across platforms as well? Android, iOS, desktop (Assume answer is yes) Thanks fo"See full answer

Anonymous Krill - "I wish there were more real-life examples, more practical information that actually demonstrates the wealth of experience. In the beginning, we are introduced to 3 pillars: trust, high productivity, and growth mindset. It would have been nice to see 1 example for each of these pillars in practice. the interview response was very theoretical and diplomatic. Very shy in providing even small real-life examples e.g. question what are the example guidelines teams would set by themselves to identify w"See full answer

Mahima M. - "class Solution: def lengthOfLIS(self, nums: List[int]) -> int: temp = [nums[0]] for num in nums: if temp[-1]< num: temp.append(num) else: index = bisect_left(temp,num) temp[index] = num return len(temp) "See full answer

Pankhuri T. - "Step - 1 Ask any clarifying questions you'd have Is there any particular reality show that we are talking about? (Assuming "The Great Indian Kapil Sharma Show" for this answer that there is no particular reality show that we are going with rather a general answer) Are we talking about any particular demographics? (Assuming we are going to launch this game globally and for any specific country or city). Step - 2 Apply a Product Design Framework (let's go with CIRCLES) C(Com"See full answer

Adarsh S. - "Hey, Thanks for the question - it’s an interesting real-life existing problem wherein a few of my friends and colleagues who have tried to work and travel have faced these issues at their respective airBnBs. Cool so this is the rough backbone structure that we can follow and ofcourse we can add meat later on to it and pivot if required. So here it goes: First would like to lay out the broader mission of Airbnb + WHY this is needed as to why we are doing this and then some clarific"See full answer

Kshitij I. - "Data lake and warehouse are both places that allow an organization to store large amounts of data. When swimming in a lake, one would imagine that they come across all sorts of stuff - floating twigs, fish in the water, stones, chemicals and sometimes may be even a snake. Similarly, a data lake stores all forms of data that the company has without any indexing. The data is available at any time but needs to be first cleaned up and reorganized before it can be used for any type of analysis. A"See full answer

Nikita C. - "WhatsApp is a free messaging platform, that introduces new and amazing features frequently to leverage its user data and vast user base. I assume the goal is to get revenue from the services without affecting user satisfaction. For that, I am listing a few ideas using which we can monetize WhatsApp. Whatsaap has recently introduced channels, for verified channels WhatsApp can start a subscription model. WhatsApp can introduce in-app ads in the stories section showing relevant ads. What"See full answer

Unicorn 2. - "I would like to ask a few clarifying questions Lyft for kids: Does this mean we want to design a ride sharing app for kids? (Assuming yes) Do we have any existing features catered to kids? (Assuming no) Lyft has a lot of features. I am going to assume basic table stake features which Lyft already has as: Ability to call for a ride Ride tracking Are there any goals that we would like to achieve with this feature? If we look at current market conditions, Lyft has biggest threat f"See full answer

Abhijit B. - "I would start with the User feedback- both explicit (from surveys) and implicit(from Product insights on app usage/drop offs). Then understand the business direction/priorities that Paypal wants to take with Venmo and come up with a Iteration plan that starts with "low hanging fruit" first and then builds to more ambitious products. The goal is to find features that are at the intersection of "valuable(to users), feasible(for dev) and usable(to users) . Once we prioritize these features, I would"See full answer

Praveen D. - "Let me try to explain it with simple life analogy You're cooking dinner in the kitchen. Multithreading is when you've got a bunch of friends helping out. Each friend does a different job—like one chops veggies while another stirs a sauce. Everyone focuses on their task, and together, you all make the meal faster. In a computer, it's like different jobs happening all at once, making stuff happen quicker, just like having lots of friends helping makes dinner ready faster."See full answer

Maggie S. - "I would structure my answer to this question by considering: Clarifying Questions Landscape Options for Growth Prioritization Risks & Considerations Clarifying Questions Are we talking about Uber’s ride sharing service, Uber Eats, or both? -- assume Uber rides Do we care about total users who have ever used the platform, or total users per day/time period? -- assume ever How many resources do we have to acquire resources? -- assume have a budget larger than the curre"See full answer

Rohit K. - "First, let's align the Airbnb homepage with Airbnb's mission. Airbnb's mission is to "create a world where anyone can belong anywhere by providing healthy travel that is local, authentic, diverse, inclusive and sustainable." The homepage serves as the primary entry point for both potential guests and hosts, setting the stage for their journey and embodying this mission. Now, for the goals of Airbnb homepage, we can consider different aspects like awareness, engagement, and ultimately, driving bo"See full answer