Interview Questions

Palak S. - "-- Write your query here With cte as ( Select employee_id , test_id , max(score) as maximum_scores from test_results group by 1,2 ) Select employee_id , e.name as employee_name , sum (maximumscores) as totalscore from cte c join employees e on c.employee_id = e.id group by 1,2 ORDER BY total_score desc `"See full answer

Anonymous Roadrunner - "-- Write your query here select p.id, p.title, p.budget, count(e.id) as num_employees, sum(e.salary) as total_salaries from projects p join employeesprojects ep on p.id = ep.projectid join employees e on ep.employee_id = e.id group by 1 order by 5 desc; `"See full answer

Talles S. - "Me: First, let's design our product and then we will calculate the estimated amount of units sold. Before we begin, is there anything specific about this refrigerator, is this a 'smart refrigerator'? Interviewer: Yes, you can consider this is a smart refrigerator but the overall design is up to you. Me: Thank you, one more question, do we have a specific user in mind? Younger people? Retirees? Interviewer: No, you can select the user base based on your prioritization, but theoretically it cou"See full answer

SweetTaco - "Understand Wikipedia Wikipedia is an online encyclopedia that gives everyone access to unbiased and accurate knowledge and information. Current products: Website - people use Wikipedia to search and pull up articles written around a specific topic Integration with other products such as browsers and kindles - people highlight a word/subject and they can pull up the relevant wikipedia if it's available. Business model: It's a non-profit organization t"See full answer

Saket S. - "I will use the following approach for this situation: Understand Current Status of the Program: Program Goals, Schedule, How many teams, what are their deliverables, dependencies between teams Team level view of progress: Through tools like Burn down charts, Gantt charts etc. Identify laggards (lagging teams). Trend analysis for lagging teams: Understand at what point, the decline started. If the decline has started around same time, then following may be the potential issues: -"See full answer

Pranav M. - "Statement: Improve the music experience at youtube Is the goal to improve the experience for any particular kind of user/music genre? Ans: No, nothing in particular Goal: I’m going to assume the goal is to improve the experience of listening to music generally Google’s mission is to organise the world’s information. Youtube is a platform that lets people discover videos, interesting content as tailored to their interests, thus serving Google’s mission Music on Youtube also contributes to"See full answer

Anjesh D. - "I had multiple RCA to complete and each one had a deadline but the process to complete them wasn't streamlined which cause some of them to miss SLA and point of contact felt frustrated as she has no information to give to customer. I received feedback that what blocked me to move forward on those and how can I do better next time?"See full answer

Anonymous Flamingo - "Handling projects out of my expertise: When faced with a project that falls outside of my expertise, I take the following steps: Identify my skills and knowledge gaps: I assess my own strengths and limitations, and determine which areas of the project may be outside of my comfort zone or expertise. Seek guidance and mentorship: I reach out to colleagues or subject matter experts who have relevant knowledge or experience, and ask for their advice and guidance on the project. Learn and adapt"See full answer

Dan D. - "It would be nice if the final Google Docs link can be shared somewhere, so we can access it for reference with ease."See full answer

Judy W. - "Situation: COVID has impacted everyone's lives, especially small businesses. Earlier this year, during the second lockdown in Malaysia, it was estimated that 50%-70% of small businesses have closed. It got me thinking, beyond the existing training programmes, what can my company do to support small businesses? Task: So, I took the initiative to gather our Comms and Government Affairs team, to work together and explore how we can: 1) meaningfully demonstrate our company's commitment in"See full answer

Divya R. - "public static Integer[] findLargest(int[] input, int m) { if(input==null || input.length==0) return null; PriorityQueue minHeap=new PriorityQueue(); for(int i:input) { if(minHeap.size()(int)top){ minHeap.poll(); minHeap.add(i); } } } Integer[] res=minHeap.toArray(new Integer[0]); Arrays.sort(res); return res; }"See full answer

Arthur Y. - "Clarifying Questions: What are Discovery features on IG? My assumed answer: posts of followers you don’t already follow that you see on the Discovery tab of IG. The posts consist of video clips, IGTV posts, and pics. User can browse through endless scroll of posts, and can filter by category (e.g. sports, comedy, etc.) on the Discovery tab. Exclude IGTV and IG Shopping, which can also be accessed by Discovery tab, and just focus on Discovery of users you don’t already follow as"See full answer

Rafał P. - "def changeString(org: str,target:str) -> bool: lOrg = len(org) lTarget = len(target) \# They have to be equal in lenght if lOrg != lTarget: return False counter1 = Counter(org) counter2 = Counter(target) \# Counter internally iterates through the input sequence, counts the number of times a given object occurs, and stores objects as keys and the counts as values. if counter1 != counter2: return False diff = sum(org[i] != target[i] for i in range(n)) return diff == 2 or (diff == 0 and any(v > 1 f"See full answer

Yomna H. - "Evication Strategy: LFU Access Pattern: Write Around"See full answer

Prabhav G. - "Assumptions and Clarification! What kind of blind person are we talking about ? Are they partially blind? Color Blind? Can Detect Light ? Can See blurry Images? Is the Blind person an adult, elderly or a teenager? Do they have any additional disabilities? Where will this Iron be used? At home? or perhaps one for travel? Do we have any limitation of resources? Assumptions- We are talking about a Complete Blind person who cannot see anything at all i.e Zero ability to se"See full answer