I applied online. I interviewed at Zimyo (Gurgaon, Haryana) in Mar 2023
Interview
The interview process consists of three rounds. In the first round, questions focus on Database Management Systems (DBMS), covering concepts such as normalization, indexing, ACID properties, and SQL queries. In the second round, the emphasis shifts to Data Structures and Algorithms (DSA), where the candidate is expected to demonstrate a strong understanding of algorithms, complexity analysis, and efficient data structures like arrays, linked lists, trees, and graphs.
Interview questions [1]
Question 1
DBms, oops,dsa operating systemHere are some common interview questions for each round based on DBMS and DSA topics:
First Round: DBMS
1. Explain normalization and its different types. Why is it important?
2. What are the ACID properties in a database?
3. How does indexing work in a database, and why is it used?
4. What are the differences between SQL and NoSQL databases?
5. Explain the concept of joins in SQL and describe different types of joins.
6. What is the difference between clustered and non-clustered indexes?
7. How would you optimize a slow query?