Interview Questions

Sreeram reddy B. - "select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"See full answer

Tara J. - "I would like to speak loud to narrow the scope of this question so I can be effective in identifying a solution to the problem on hand. Hope that is OK. You mentioned, “Re-design the airport experience”. Is there a goal for this re-design exercise? Some top goals that come to my mind are the following. Please guide me so I can set it and we can proceed from there. “Increase the number of passengers who travel to and from this airport” “Improve customer satisfaction” **“Get in"See full answer

Anonymous Roadrunner - "-- Write your query here select id, (case when p_id is null then 'Root' when pid in (select id from treenode_table) and id in (select pid from treenode_table) then 'Inner' else 'Leaf' end) as node_types from treenodetable order by 1; `"See full answer

Sandhya P. - "What is Meta Quest, Horizon world VR game? Horizons worlds is a platform that lets creators build worlds where real people can come and interact. This could be a gaming world, a socializing world, a marketplace, immersive experience, etc. Why would people want to use Horizon worlds: Because it isn’t possible to always visit all places in person I know that Meta has been encouraging creators at this time because the Horizon’s worlds needs a lot of worlds for it to be interesting for customers Cus"See full answer

Babaa - "Function signature for reference: def calculate(servers: List[int], k: int) -> int: ... To resolve this, you can use binary search considering left=0 and right=max(servers) * k so Example: servers=[1,4,5] First server handle 1 request in let's say 1 second, second 4 seconds and last 5 seconds. k=10 So I want to know the minimal time to process 10 requests Get the mid for timeline mid = (left+right)//2 -> mid is 25 Check how many we could process 25//1 = 25 25//4=6 25//5=5 so 25 + 6 +"See full answer

Tesfaye M. - "This situation requires balancing business urgency with technical stability. Here's how I'd approach it: 1. Understand the Business Requirement Clarify why the new requirement is urgent. What’s the impact if it's delayed? Is it revenue-generating, compliance-related, or competitive? 2. Assess the Bugs Work with engineering to understand:Root cause: Are the bugs pointing to a deeper systemic issue? Severity and impact: Are they blocking users or just edge cases?"See full answer

Karthik T. - "In our product portfolio there were many teams and we were almost 12 product managers interacting closely to deliver the entire product feature area. Situation was that we were frequently had defects come in which will result in defects pushed back and forth. Goal was to avoid this as SLA of defects was getting impacted immensely there were priority 2 defects which we were sitting for couple of weeks before being looked at. There was a need to establish a triaging process. Along with my leaders"See full answer

Carlos S. - "1) Clarifications Is this a Google initiative? Yes Timeline for development? MVP within 3 months. Hotel type? Focus on urban and mid-sized hotels Items to offer? Include ready-to-eat meals/snacks (e.g., microwaveable food, healthy snacks, beverages). Geographic scope? Launch in the US only. 2) Google Mission / Why "Organize the world’s information and make it universally accessible and useful." Google aims to enhance the guest experienc"See full answer

R K. - "As a Product Manager for Instagram Reels, understanding Meta's investment in this product requires considering the broader competitive landscape, primarily TikTok, and Instagram's monetization strategy through ads. The focus on Reels is a strategic move to capture a share of the short-form video market, increase user engagement, and drive ad revenue. Lets start with why Meta invested in Instagram reels 1. Competing with TikTok: TikTok's explosive growth in the short-form video space pose"See full answer

Saleel P. - "This is my first attempt at an estimation question, any feedback is appreciated. I'd like to clarify if AirBNB's core services would include user reservations on its web/mobile platform on a per night basis. I'd also assume if we would to estimate the topline revenue (or gross merchandise sales) without factoring operational expenses and taxes. I'd also clarify if basing my estimation on revenue from its largest marketplace, US, is reasonable. Population of US - 350 MM Avg Household size - 2.5"See full answer

Natalia N. - "Clarifying questions: How much is the decline? Since when have sales been declining? Make sure that it has correlation with competition and not a premature assumption that can come from something internal (not external competition). Is it all the stores? What is the variation in the dicline? If you have stores that have 20% less sales vs some that are steady, it might be something related to the store experience specifically. How does the decrease in sales compare to cities that ha"See full answer

Anubhav S. - " At low level: I would use two stacks: one for forward history and other for backward history. i go to tryexponent.com => this url will be stored in backward history stack. i go to google => again this url will be stored in backward history stack. i press back => data from backward history will be popped and put in to forward history stack. I press forward => data from forward history stack will be popped and put in to backward history tab. Also, whenever i go to any url,"See full answer

Nayla D. - "Clarify Questions: Is this app in Facebook app? or we build a different app for this? - Yes, this is in FB app now. Will we have monetization in the first launch or launch it for free first? - Free first, but there is a potential monetization in the future. Context: we will launch Facebook Jobs in two weeks, indicating that this is a new product. I want to step back a bit, why this is important for Meta. Meta mission is to make it easier to build community and bring the world closer"See full answer

Sugrim S. - "after completing my project, I asked my manager for feedback on my performance. My aim was to identify areas for improvement, and learn more about new technologies which are in the"See full answer

Aniket A. - "Clarifications: Where are we launching? -- US first 1:1 or n:n video conferencing? -- you assume Consumers or Business? -- consumers Part of FB or standalone product? -- part of messenger app Is it MVP launch or a full feature product? -- MVP What capabilities exist in the video conference product? -- you assume what capabilities will be > Trends and Markets Competitors: Consumer Zoom Google Meet Business: Slack MS Teams Trends: More and more people are usi"See full answer

Amana A. - "I have nothing in my mind even upon thinking that Google Product is going to be disliked. The reason is that it is made with the effort to serve the customers. I like Gooogle because the Searching using the web browser, its timely response, especially for Research problems, we use the Google Scholar, Google collaborative, Google Documents, Google Drive, Google GMAIL inbox and the interface design, and many other things."See full answer

Ashish G. - "Rate Limiter is to limit the number of request from a particular IP Address. Rate limiter will block the IP address to reduce the load on server. It should be highly available and handle concurrent requests. Blocked IP addresses should be kept in a pool which is present in shared cache. We need to keep threshold value after it reaches threshold value it should start blocking IP address. All these ip address to be kept in No SQL DB. Batch will run that will clear the cache and delete all the bloc"See full answer