There were 3 rounds
Round 1
- Questions on SQL, No SQL, when they are used in different conditions
- MongoDB joins, find and update functions, SQL Query-related questions
- Message Queue, what it is, and when it is used
- DSA Question same as https://www.geeksforgeeks.org/dsa/program-to-convert-a-given-number-to-words-set-2/
- Questions on OOPS - Polymorphism, why we need run time polymorphism
Round 2
- DSA Question - Given two sorted arrays print all the operations that are needed to convert array 1 to array 2. We can perform Add or remove of numbers in array 1.
- Tree traversals
- Find the valid BST - First asked using inorder traversal and a separated array and then asked without using a separate array.
- Design a database for students and their branch in a college - write the query to find the number of students in each branch.
- What is the order in which all SQL commands are executed?
Round 3 was HR