Abco Advisory Board Company | Set 2 (On-Campus)

Round 1:

Technical aptitude 20 questions + 2 coding questions + 5 dbms queries

Round 2: Technical interview

1. Given a mxn matrix with elements sorted along the rows as well as the columns, find a given element in it
2. A thermometer records readings every 5 seconds. Suggest a data structure to maintain the minimum and maximum readings recorded in the last 24 hours
3. Find if two nodes are cousin’s in a binary tree
4. OOPS concepts, mention a few object oriented programming languages
5. What are the access modifiers allowed for a constructor, Singleton design pattern
6. Write SQL query to find the user who logged in maximum number of times (table has entries with username, timestamp)

Round 3: Technical interview

1. n people play a tournament having a match with every other participant. Form a round Robin queue structure such that for a person at index i, he has lost to person at i-1 and won with i+1. It does not matter if he has lost or won with a person two or more indices away. (use bst traversal)
2. Give applications for (and the need of) each tree traversal
3. Write an SQL query to find the person who secured the second rank in class (and a few similar variants of such queries)
4. Write a code to retrieve the minimum element present in a stack

Round 4: HR interview

1. Why computer science
2. Tell me about a situation where you felt immense pride and a situation where you failed. What motivates you etc
3. About projects. What would you do if you feel a team member is not contributing to the project
4. About extra curricular
5. What do you know about the company