Online Assessment
Questions:
- Multiple Choice Questions (MCQs)
- 2 Coding Questions
Technical Interview Round 1
Questions:
-
Excel Column Title to Number Conversion: Convert Excel columns (A, B, C, ..., Z, AA, AB, ...) to corresponding numbers.
-
Maximum Width of a Binary Tree: Distance between leftmost and rightmost nodes at any level, including null nodes in between.
-
Discussion on MERN Stack Project:
- What is MERN?
- What is NoSQL?
- Difference between SQL and NoSQL.
- Do NoSQL databases support ACID properties?
- Atomicity and Durability.
Candidate's Approach
- For the Excel Column Title to Number Conversion, I walked through my approach, performed a dry run, and then wrote the code.
- For the Maximum Width of a Binary Tree, I explained my approach, did a dry run, and wrote the code while explaining some C++ syntax to the interviewer.
- I validated some test cases with the interviewer during the coding questions.
Interviewer's Feedback
No feedback provided.
Technical Interview Round 2
Questions:
- How does data exchange happen between UI and backend? What is this mechanism called?
- Types of HTTP methods.
- Excel Column Title to Number Conversion: (same as first round).
- SQL Scenario-Based Question: Given a table with columns: id, name, email, date, batch_id. Scenario: Some rows have the same name, email, date (same person, different batch_id). Requirement: Remove duplicate rows (keeping only the first occurrence) if batch_id is ignored. Follow-up: Explain the ROW_NUMBER() function, what type of function it is and how it can help here.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Verdict: Rejected Even though I answered well from my side, the result came unexpected. Overall, the process was structured well. The focus was on core problem-solving skills and basic DBMS and web development concepts and project discussion.