Tech Mahindra interview questions

How will you ensure that the short term and long term attrition is controlled

I had prior experience in a small farm so I was asked about my job role and day to activities in my previous employer. A few SQL queries were asked - types of keys, whether you can have a foreign key if there is no primary key defined in that table and some case scenarios where JOIN was required. A bit of UNIX was asked too. Some questions from Operating system. Details of the projects that I have done in college as well as in my earlier employment. In the second technical round I was asked to explain Data structure e.g stack, queue and their pseudo codes. Then he asked structure, pointer, file handling, function overloading, overriding etc. In HR round I was asked about my strength, weakness and other not to important stuffs.