I felt that the interview process could have been more clearly communicated regarding the expectations for the technical round. The interview leaned heavily on theoretical concepts, and for a product-based company relying on theory rather than practical , and judging a candidate does not seem right. To me it seemed like the interviewer didn't prepare and was asking only random questions. Even if answered correctly he disagreed for some questions.
Interview questions [1]
Question 1
1 sql intermediate question and some theoretical concepts.