Campus Process and Interview Experience of Infotrellis India

First Round: (Written Test)

Objective questions:

• C (15 question)
• Java (15 question)
• Aptitude (20 questions)
• English (5 questions)
• DBMS (SQL) +Data Structures and Algorithms (10 questions).

After the first round 22 people were shortlisted

Second Round: (Technical Interview)

• My Introduction
• Questions aboutfavorite subjects and games.
• Project discussion and asked many question Related to Projects.
• Asked programs.

1. To find given number is prime or not.
2. Swap variable(without using third variable).

• What is stack and queue?
• Reverse the linked list(using two pointers).
• What is OOPS?
• OOPS concepts which are as follows.
• Explain class,object,encapsulation,polymorphism and abstractions etc. with real life examples.
• Asked questions to check very basic knowledge on C++ soafter that he told me that if I want to teach a child (5 year) how will I do the same given that the child doesn’t know any technical keyword like class,object etc.
• Function Overloading and function overriding? With code for function overloading and asked that where function overloading doesn’t work (return type or parameter)?
• What is pure virtual function and what is the purpose of using it?
• What is static data member?
• Asked some questions related to DBMS.
• What is normalization?
• Difference between left outer and right outer join and then he gave two tables and told that what will happen after if you will apply left and right join on that tables and why we use these join.
• What is inner join?
• What is cursor?Why we use it?
• What is trigger and where do you apply in your DBMS project?

After the second round 9 people were selected.

Third Round:(Technical interview)

• Asked Puzzle:
  • If you have 11 chock boxes and there are 100 chocks in every chock box.Weight of 1 chock is 10 g. Among all boxes,only one of them is havingdifferent (heavy) weight. I had to find the defective box.
  • Remove duplicates from the linked list(unsorted list) and if there are infinite numbers in the list then how you will remove duplicates and he also asked about the time complexity.
  • Do you have Knowledge in java;I replied that I have only basic theory knowledge andworked on only frontend. Then he said that in how many days youcan learn java?
  • Some questions asked about DBMS.
  • Normalization and Join?
  • The interviewer gave me 4 tables’product, order,order_detail, and customer. And asked what should be the attributes of these tables and what will be the relation between them.
  • How will you relate these tables?What is primary and foreign key? Which one will be the primary and foreign key in those tables?
  • If you want to insert one record of customer and that customer made an order (3 in 1 means order_id will be same but prouct_id will different).then how many row will be in each table.
  • What is the aggregate function?
  • Difference between distinct and group by? Where do you use group by?
  • Query to count the no. of order of customer (customer ordered item (having 3 products).

HR Round

• Tell About yourself.
• Why should we hire you?
• Tell about your strength and weakness.
• Tell about your hobbies and interest?
• Any question you want to ask?

That’s all