Interview Questions

Ali H. - "SQL databases are relational, NoSQL databases are non-relational. SQL databases use structured query language and have a predefined schema. NoSQL databases have dynamic schemas for unstructured data. SQL databases are vertically scalable, while NoSQL databases are horizontally scalable."See full answer

Anonymous Koala - "Google mission==>organize world info and make it accessible to user Monetize from Ad revenue, enterprise productivity service, Developers Google glass provides==>smart  virtual screen , hands free voice commands activated glass for for $1000+. Fits in google mission If google is to launch google glass the key metrics of success would be Number of glasses purchase Usage in term of google search, texts, play video, take picture other activities performed Previous pitfalls "See full answer

Sampada J. - "Clarifying question- Current pricing model at lyft? So there is already some kind of dynamic pricing happening at lyft as depending on different factors like distance, driver availability, time of day, seasonality etc. the prices would change Hypothesis- I want to focus on real-time dynamic pricing. What I mean by that is that I want to have another option while booking a ride on lyft where the price for the ride is not shown upfront as the user is booking. Instead this option would basica"See full answer

Anonymous Unicorn - "Count items between indices within compartments compartments are delineated by by: '|' items are identified by: '*' input_inventory = "*||||" inputstartidxs = [1, 4, 6] inputendidxs = [9, 5, 8] expected_output = [3, 0, 1] Explanation: "*||||" 0123456789... indices ++ + # within compartments ^ start_idx = 1 ^ end_idx = 9 -- - # within idxs but not within compartments "*||||" 0123456789... indices "See full answer

nikilukman - "Clarifying questions #1: What does "investment" mean? #2: Verification badge already exists or not? #3: A verification badge is a special symbol (like a checkmark), usually displayed next to the username to identify/verify that an account with this badge is an authentic public figure or brand. It is NOT a way for Instagram to endorse the "importance" of verified accounts. Is this accurate? Anything else I should know of as a PM regarding the definition? **Assumption: Verification badge alre"See full answer

Nouna J. - "If this question was for a product manager; I would approach it as I don't really know how actually these vehicles work. I will try to simplify the concept and answer questions like why autonomous vehicles are exists and what is the purpose of them. Autonomous vehicle is a vehicle can do some actions on behalf on a human and as main reason is to increase the safety, so to come up into how they work, I should identify the main actions that human does and prioritize it based on what they may"See full answer

My N. - "Partner with IoT manufacturer new smart product, phone in the center Bundle google personal security subscription with IoT package Commercial package security, industrial use case medical device, airplane, ship, vehicle management, maintenance and remote usage Public sector smart cities"See full answer

Michael B. - "Problem: Given an input string txt consisting of alphanumeric characters and the parentheses characters '(' & ')', write a function which removes the minimum number of characters to return a version of the string with properly balanced parenthesis. Answer: You can do this with a counter. Psuedo-Python Start with counter = 0 output = [] Iterate through the string, every time you encounter a '(', increment the counter. Add the character to the output. If you encounter a ')', decrement the coun"See full answer

Guilherme F. - "A much better solution than the one in the article, below: It looks like the ones writing articles here in Javascript do not understand the time/space complexity of javascript methods. shift, splice, sort, etc... In the solution article you have a shift and a sort being done inside a while, that is, the multiplication of Ns. My solution, below, iterates through the list once and then sorts it, separately. It´s O(N+Log(N)) class ListNode { constructor(val = 0, next = null) { th"See full answer

Johannes C. - " import pandas as pd def findunsoldproducts(transactions: pd.DataFrame, products: pd.DataFrame) -> pd.DataFrame: products_keep = products[["id", "name", "stock"]] transactionskeep = transactions[["productid", "date"]] output = pd.merge(productskeep, transactionskeep, lefton="id", righton="product_id", how="left") output_filtered = output[output["date"].isna()] columns = ["id", "name", "stock"] outputfiltered = outputfiltered[columns] return o"See full answer

Harish K. - "Swiggy could implement to increase the average order value (AOV) on its platform: 1. Smart Recommendations and Upselling: Personalized suggestions: Leverage data to recommend items based on past orders, popular choices, and trending items in the user's area. Upselling prompts: When a user adds an item to their cart, suggest related or higher-value items (e.g., "Would you like to add a side of fries with that?" or "Upgrade to a large for just ₹X more"). Bundle deals: Offer c"See full answer