There was a total of 5 rounds, The eligibility criteria for the hiring process was CGPA 7+ or 70% throughout.
Round 1: Coding Round
There were 2 coding questions (easy) conducted on skype. The duration of the round was 40 minutes.
- Given two arrays, Array1 and Array2, of equal size S, the objective is to track down the least value of Array1[0] * Array2[0] + Array1[1] * Array2[1] +…+ Array1[S-1] * Array2[S-1]. Shuffling of elements of arrays are allowed.
- Given an array Numbers[] and a number N, display for all pairs in Numbers[] with a difference as 2N
- It was an easy round but there were a few things that most people didn’t notice and couldn’t move to the next rounds, like return type and variable naming.
Tips: Be very active and observe every detail very carefully, don’t hurry and jump on a solution.
- I cleared the first round and the next day received a mail for the next coding rounds
Out of 181 students, 28 were selected for the next round.
Round 2: Coding Round
This round was 15 minutes round on skype where I was given a question (easy) and was allowed to use notepad only.
- Given a number N, find all numbers from 0 to “N” having an occurrence of a digit “D”, where N>0 & 0<=D<= 9
- I wrote the code and explained my approach.
- Got selected and received a call for the next technical rounds after few hours.
Round 3: Technical Interview
This round was 55 minutes round on skype where I was asked questions from OOPS, DBMS, DSA.
- Interviewer: Explain OOP.
- Me: Explained.
- Interviewer: What is Abstraction?
- Me: Explained with example.
- Interviewer: What is Polymorphism?
- Me: Explained with both types.
- Interviewer: Explain the virtual function, friend class, an abstract class?
- Me: Explained.
- Interviewer: What is Inheritance and explain multi-level inheritance?
- Me: Explained.
- Interviewer: What are data structures and why do we need them?
- Me: Explained.
- Interviewer: Different types of keys and differences between Primary key and Unique key.
- Me: Explained.
create table Course(
Name varchar(255), Roll No int PRIMARY KEY, Course varchar(255)
) ;
insert into Course Values(“Kshitiz”,”21″,”Maths”);
create table Student(
student id int PRIMARY KEY ,name varchar(255), roll no int, marks int,
FOREIGN KEY(roll no), REFERENCES student(roll no)
);
Fetch the student id who are enrolled in Maths.
- Interviewer: Perform SQL query
- Me: Explained.
- Interviewer: What is an interface in C++?
- Me: I was not sure so I honestly told her I’m not sure.
- Coding question.
- Interviewer: Check if the given array is sorted or not using recursion.
- Me: Explained and gave the solution.
- Coding question.
- Interviewer: Explain and implement stack.
- Me: Explained and gave the solution.
- Interviewer: Explain the difference between stack and queue
- Me: Explained and with examples.
- Interviewer: Explain Normalization, 1NF, 2NF, 3NR.
- Me: Explained and with examples.
- Interviewer: Explain Partial dependency and Transitive dependency.
- Me: Explained.
- Interviewer: Explain prime attributes.
- Me: Explained.
- Cleared this round and received a call for the next Technical round the next day.
Round 4: Technical Round
This was 20 minutes technical round on skype.
- Interviewer: Difference between array and set.
- Me: Explained.
- Interviewer: Why do you want to join Hexaview?
- Me: Answered.
- Interviewer: Which language do you prefer C++/ Java?
- Me: Answered.
- Coding question (easy).
- Interviewer: Add two numbers without using the + operator. Explain the logic for this question.
- Me: Explained.
- Cleared this round and received a call for the next HR round.
Round 5: HR Round + Technical
- It was 62 minutes round on skype.
- Coding question (easy-medium).
- Interviewer: Code this pattern question within 15-20 minutes.
- Me: Explained and gave the solution.
- Puzzle question (medium-difficult).
- Interviewer: Gave a puzzle question.
- Me: Tried but couldn’t solve it. He explained.
- Interviewer: Explain DDL, DML commands
- Me: Explained.
- Interviewer: Write a query to fetch the third maximum salary.
- Me: Explained.
- Interviewer: Any questions from your side.
- Me: I asked two questions.
- He asked few more questions mostly from DBMS.
- Result: Selected
- Successfully cleared this and received mail after 7 days.
TIP: Be clear with fundamentals (DBMS, OOP, DSA, CN) and read about the company before your interview.
I hope it will help you.
Thank you
Vartika Shakya