Hexaview Technologies Interview Experience (On-Campus)

• Difficulty Level : Medium
• Last Updated : 02 Nov, 2021

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?
• Interviewer:  Which language do you prefer C++/ Java?
• 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.