This was managerial round and it included question like family, schooling, background, favorite sports, hobbies, aptitude, SQL and where you see yourself in 5 years?

Question

Accepted Answer

Don't be too casual or too serious, be diplomatic. It was supposed to last less than 30 minutes but it lasted almost an hour. First he started with ice breakers like tell me about yourself, family, schooling,  etc and then moved on to aptitude questions and then he asked how to retrieve second or third highest salary from database or some variation of that, basically you have to use rank or dense rank for that in most of the SQL, you can also use offset in certain flavor. He finally wanted to know where I see myself in five years, basically they want to know if you're a reliable hire and not going to run away at the sight of first problem. So I told him I will work for like 2 years and then assess myself if this company can offer me growth and also told him about my plan for higher studies in five years as you might reach stagnation after certain years of work. He told me that you don't need to go for an MBA to reach his position and he was cool with my answer that you need to revaluate your position within a company as he himself had changed lot of ships before landing in the current one.

This was managerial round and it included question like family, schooling, background, favorite sports, hobbies, aptitude, SQL and where you see yourself in 5 years?

Top HR questions asked in Oracle Cerner Change Implementation Analyst