MR.
COOPER INTERVIEW EXPERIENCE
-Madumitha S
Round-1 MCQs and Coding
25 mcqs+ 3 coding questions
Mcqs were based on sql queries, oops, aptitude.
Of 3 coding questions one was easy ,one was medium, and other was hard.
Round-2 : Long Coding Round
They asked us to create a fitness tracker application with certain functionalities to be
implemented like activity tracking, goal setting, creating work plans, social networking, etc.
Firstly, we should create a UML diagram or ER diagram of our preference for the application.
Questions was asked based on the diagram like “Why have you used this relation between these
two classes” or “How will you relate these two classes”. So the relations should be properly
mentioned.
Next if they give permission to proceed we should start drawing System architecture for that
application. They expected us to create a very simple minimal architecture along with tech stack
used for each layers.
Then if that is verified by the HR, we could start coding the application. Any object oriented
programming language can be used. We weren’t be expected to produce the output. But the
approach towards implementing the functionalities and how well the OOPS concepts are used
were checked. The code should be explained to the HR and they would ask questions based on
that and we should make changes based on their suggestions.
Another questions on SQL query was given. Two tables were given one with user id and user
name another with numberofstepstaken ,date, userid, etc.
Our task is to find the average number of steps taken by every user each month for the past
year.
Round-3 : Tech HR-1
This round happened for around 30 – 45 minutes.
All questions were based on OOPS,DBMS,DSA.
1.How is human readable code understood by the processor?
2.DSA :
1. Difference between linear and non linear data structure.
2. Implement stack using linked list.
3. Explain the different use cases where we prefer arrays over linked list and linked list over
arrays.
4. Give real time example of linked list.
5. How is linked list used in web browser?
6. Give real time example of graph.
7. What happens to other nodes if one node is removed from a social network?
8. Real time example of tree.
9. Questions on Binary Search tree.
10. List all the functionalities of a music player application. Explain the data structure used
for each functionality
11. Tree traversal questions
,etc
3.OOPS:
1. Why is abstraction necessary? How is abstraction used in real life?
2. All types of inheritance and real life examples
3. Method overloading, overriding
4. Explain the OOPs concepts used in the class diagram drawn in round 2.
5. How can this class diagram be optimized using OOPS.
6. Why should we use encapsulation. How can we say data is protected in encapsulatio
, etc
4.DBMS:
1. SQL queries using joins.
2. SQL query to find third maximum salary.
3. Different types of joins.
4. Explain all ACID properties.
5. How should we normalize a table. Explain all Normal forms.
6. Why are views used? Why cant we use select instead of views while both does the same
job?
, etc
Every question will be followed by follow up questions based on the answers you give.
Round – 4 Tech HR-2
1.Gave a use case and asked to implement it using OOPS.
There would be two classes User and Activity.
User class would have username and Activity class would have activity type, Calories Burnt,
Distance covered.
There should a method in User class called printActivity(), which should print all the activities
performed by the user so far.
2. Question on linked list to swap first and last node n number of times.
3. Question on joins in sql.
Round – 5 General HR
Questions like
How can you adapt to new environment and city?
Do you have the idea of doing higher education?
Reason for choosing the department
Reason for choosing Mr.Cooper
Personal questions about schooling, family, etc.