Single round: LeetCode-hard array DSA, progressively harder SQL, and DBMS/CN theory (indexing, B+ trees, OSI)

Application

I applied through an employee referral. The process took 1 day. I interviewed at Zomato in May 2025

Interview

Round 1. - Leetcode hard DSA question from Array. (Present in Striver SDE sheet) - Bunch of SQL questions progressively getting tougher. (Leetcode SQL medium level) - Few questions on DBMS and CN. (Types of keys, B+ trees, Indexing, OSI model)

Interview questions [1]

Question 1

How does indexing work for simple keys and composite keys?