Eligible Branches: Open to All.
Online Test (135 mins): Platform: Hackerrank. The test consisted of 5 sections:
- 2 Coding Questions in 30 min. Both were easy-level questions and simple brute-force solutions passed all test cases.
- 1 Leetcode medium question. (45 min) https://leetcode.com/problems/snakes-and-ladders/
- Aptitude Questions (20 min)
- CS MCQs (25 min)
- 2 descriptive questions (15 min) Test was proctored
Verdict: To the next round
Round 1 (40 min): Platform: Codepair
- The round started with “Tell me something about yourself”.
- Coding Question: https://www.geeksforgeeks.org/burn-the-binary-tree-starting-from-the- target-node/
Verdict: To the next round
Round 2 (70 min): Platform: Codepair
- Questions on SQL union, intersect. Write a query to find the union of two tables with distinct entries only. Also, add a column to this newly created table that indicates from which original table the entry has come. ( Like 1 indicating 1st table and 2 indicating 2nd table).
- Leetcode hard coding question. https://leetcode.com/problems/median-of-two-sorted-arrays/
- Coding Question: Given a disk of size 10GB containing integers. If you have 1GB of RAM then how would sort the numbers in the disk?
Verdict: To the next round
Round 3 (40 min): Platform: Zoom
- Introduce yourself
- Explain one of your projects.
- Which Database did you use in a project? (I used SQLite)
- Why did you choose SQLite?
- What are the problems you will face if you try to scale up your project with SQLite as a Database?
- What are ACID properties in the database? Explain each with an example.
- He gave me a Schedule and asked if was it consistent (it wasn’t) and then asked how would you ensure Isolation in that case?
- Asked a little bit about concurrency control protocols.
- How would you ensure the durability of the database?
- What have distributed databases?
- What is horizontal and vertical scaling?
- And at the end “Do you have some questions? “
Verdict: Selected
Recommended Articles