Excerpts from Interview #1:
(B. Tech background, with academic profile as 8.76 CGPA, 85% in 12th and 93% in 10th.)
Online Exam:
- What is “I” in ACID properties?
- What do you mean by “write ahead logging” in DBMS?
- Describe a few deadlock avoidance schemes.
- What do you understand by clustering index?
Technical Interview:
- Implement the malloc() and free() operations. Describe only the strategy for doing so, not the code.
- Explain and describe structure padding.
- A window of size k is sliding from left to right in an array of size n. Find out the maximum number in the window at each window position.
- Describe your final year project in detail. How would you describe your role in the same?
HR Interview:
- How has your interview experience so far?
- What are you weaknesses which you would like to work upon?
- Do you wish to change your domain? If yes, why?
- Describe a situation wherein you were asked to do something you didn’t like? How did you handle it?
Excerpts from Interview #2:
(B. Tech background, with academic profile as 9.01 CGPA, 88.02% in 12th and 89.06% in 10th.)
Online Exam:
- There is a program which inserts and deletes node in a sorted singly linked list. There is a bug in one of the modules. Give us a method of debugging it.
- What are the various techniques by which fault tolerance can be ensured in systems? (Different redundancy techniques)
- A pair of redundant systems is operating. Give us a method of ensuring that when one of them goes down, the other one will take over its operation.
- Describe the virtual function in C++.
Technical interview:
Implement a binary tree with the given interface,An interface for a sorted binary tree:
* The interface provides methods for inserting values, checking if certain values are contained and iterating over the elements.
* Note: Implementing classes should provide an iterator that traverse the inserted object in the sorted order.
*/
public interface IBinTree> extends Iterable {
/*
* Insert an object into the binary tree. Note: The tree should be sorted, inserting the same object twice is allowed but the insert is expected to be stable.
*/
void insert(V obj);
/*
* Batch-insert multiple elements.
*/
void insert(Vector vec);
/*
* Check if the object is already in the tree. Return true if it is, false otherwise.
*/
boolean contains(V obj);
}
- Give us a program to reverse a linked list.
- Suppose you have to store one lakh objects. Which of the two will be a better option- hash map or array list?
HR Interview:
- Has there ever been a situation wherein you weren’t able to complete your task in time and therefore had to take a quick decision to manage the situation?
- What extra-curricular activities are you involved in?
Excerpts from Interview #3:
(B. Tech background, with academic profile as 9.67 CGPA, 94.56% in 12th and 95% in 10th.)
Online Exam:
- At 6 o'clock the clock strikes 6times. The difference between the first and the last strike is 30 sec.
- Find the total time when it strikes 12.
- Suppose that while traveling at uniform speed you read a two digit number. After one hr the number is reversed. After another hour the number read is the same two digit number. What is the average speed of the car?
- If a=1, b=2...z=26 what is the sum of “p+q+r”?
- If z=1, y=2...a=26 what is the sum of “a+b+….+x+y+z”?
- Suppose a 4-inch cube is painted on all the sides. If this piece is cut into smaller cubes of side 1 inch each, how many cubes will be left unpainted at all?
Technical interview:
- Suppose that two of the nodes of a Binary Search Tree (BST) are interchanged. Give us a method to fix(or correct) this BST.
- Devise a program to check whether a binary tree is BST or not.
- Devise an algorithm to check if there is a loop in a doubly linked list.
HR Interview:
- What do you expect from our organization?
- Will you be comfortable in relocating?
Excerpts from Interview #4:
(B. Tech background, with academic profile as 9.46 CGPA, 91.02% in 12th and 94.8% in 10th.)
Online Exam
- A few choices were given. The question asked to pick out the Super Key from the lot.
- Which of the following is an odd one out - a)SMTP b)WAP c)SAP d)ARP
- Which of the following is an odd one out - a)Oracle b)LINUX c)ingress d)DB/2
- Considering GRANT is used to grant privileges to perform the queries specify the command which is used to remove these permissions?
Technical interview:
- How would you swap the Kth node from beginning with Kth node from end in a Linked List.
- what is the output of the following
#define AREA(x) (3.14*x*x)
int main()
{
float a,r1=6.25r2=2.5;
a=AREA(r1)
printf("\n the area of the circle is %f",a);
a=AREA(r2)
printf("\n the area of the circle is %f",a);
}
HR Interview:
- Would you be interested in changing your domain? If yes, why?
- Describe a situation wherein you were asked to do something you didn’t like? How did you handle it?
Excerpts from Interview #5:
(CCET student having 10th grade- 94.6% 12th grade - 85.7% and graduation score- 67.22%)
Technical interview:
- What do you understand by the term cloud computing?
- Describe some salient features of the cloud?
- Describe the difference between a Public and Private cloud.
- How would you define HADOOP? Describe the underlying principle of HADOOP and illustrate some of its features like MapReduce?
HR Interview:
- You have been through the pre-placement talk. Tell us a few negatives about the presentation and how can we improve next time onwards.
- How to you define your goals in life? Do you make plans and strategies for the future or grab opportunities as they come?
- At SAP you might have to do multiple tasks- Attend meetings related to your work as well as complete work for your client. How will you cope up with the same?
Excerpts from Interview #6:
(PEC student having 10th grade- 91.3% 12th grade - 87.2% and graduation score- 65.4%)
Technical interview:
- Differentiate between primary and foreign key.
- Describe macros in Excel. Explain how they are used.
- Explain your summer training project.
- What do you understand by an empty class? What is the functionality which it offers in Java?
HR Interview:
- What have been your highs and lows in the 4 years of college life?
- We have undergoing projects all over India. Will it be feasible for you as an employee if your job profile requires regular travelling or relocation to a place away from your current city?
- Logical or Choice Based Questions: You have a cake. Describe a method to divide it into 8 pieces using only 3 lines?
