Interview Questions

Derrick M. - "SELECT COUNT(DISTINCT o.customerid) AS customers, d.departmentname FROM orders o INNER JOIN departments d ON d.departmentid = o.departmentid WHERE d.departmentname IN ('Electronics','Fashion') AND o.orderdate BETWEEN '2022-01-01' AND '2022-12-31' GROUP BY d.department_name; `"See full answer

Vishal S. - "Q. Why is a promotional tool required? Swiggy vision is to provide unparalleled convenience to customers. There are a number of newer restaurants launching everyday all over India and swiggy is a place not just for order but also for customer acquisition and feedback. And in India one of the most tried and tested ways to acquire is by giving discounts on all orders or special items if one wants to try newer items with customers or even cross sell. I myself have used Swiggy trynew code multiple t"See full answer

P D. - "Avoid Accidents Avoid Theft "See full answer

Kitan F. - "I described why I liked the product Defined success metrics Proposed an A/B test"See full answer

Flora K. - "USING RECURSION"See full answer

Priyanka C. - "Firstly need to check is this service really beneficial or not. And video service provide more realistic perspective about the product so keep it"See full answer

Rahul M. - "We should define automated Scheduled Updates for deployment to keep the application up to date."See full answer

Vince S. - "func isMatch(text: String, pattern: String) -> Bool { // Convert strings to arrays for easier indexing let s = Array(text.characters) let p = Array(pattern.characters) guard !s.isEmpty && !p.isEmpty else { return true } // Create DP table: dpi represents if s[0...i-1] matches p[0...j-1] var dp = Array(repeating: Array(repeating: false, count: p.count + 1), count: s.count + 1) // Empty pattern matches empty string dp[0]["See full answer

Kk - "Video is collection of images and we can call them as moving pictures. Let us break down the important components of the video in comparison to photos and explain how they impact : Frame rate per second : It is at which a total number of frames are captured in a video while it was shot and played then later Resolution : What resolution video was shot and played on devices ( Both can be different) Let us talk a bit deep dive about Frame rate per second. Often , a video co"See full answer

Abdurhman M. - "To determine what predictions to show, our systems look for common queries that match what someone starts to enter into the search box but also consider:"See full answer

Darpan D. - "Clarifying and Assumptions Is there any specific geography we need to restrict to? Assumption: Total worldwide. Is there any specific segment we need to restrict to? Assumption: All segments. Number of users Total worldwide users: 300,000,000 Storage per user Slice the users into 3 segments. Low users 80% Free tier 2 GB per user available Using the 80-20 rule for segmentation. Medium users 10% Basic paid tier 2 TB per user available Usi"See full answer