Recruter reached out via naukri
Exp: 4 years
Role: SSE

Round 1:

Design a in memory SQL like databases

• You should be able to store rows
• Column could be of int, string or boolean datatype
• We should be able to set a primary key or set of primary keys
• Create index on the primary key
• Should not break on concurrent operations
• Should be able to create tables, rows and columns

You can find more details about this quesiton on other interview experience on leetcode

Suggestions:

• Don't just directly jump into the problem understand the problem you should know how will you store the data and index the columns that is the important part.
• Keep input sanitization in mind for eg if you give a empty column name or things like that

Verdict: Rejected