3rd Round: Q1. A question related to word search in file (check inverted index) Q2. Scenario: Let’s say if you have written a code in a Hurry and deployed. Have you ever gone through the code again and thought if I can optimize this code further? (Since in the interview you’re doing optimization after writing you first code) Q3. Design a Database schema for X.com. Focused functionality only Post by a User. [Users, Posts] Q4. Write a query to fetch the total number of posts by each user. Q5. Scenario: If your application is down at night and you got a call from the supporting team in early morning then what will be your approach to analyze the issue? Q6. How will you design an application like Amazon? You need to go live asap. [Define microservices, serverless architecture, databases to be used, Search product functionality, etc] Q7. Explain the flow of request to response when you hit a URL in your browser. Q8. Difference between SQL and NoSQL. When you decide to use SQL and NoSQL.
