Vistaar Technologies Trainee Software Engineer interview questions

It was a smooth interview process. Overall good experience Aptitude was taken on 26th of February -> 14 questions on Maths , all domains -> 8 of DS , mainly time complexity , tree traversals, Sorting Algorithms -> 3 programming questions of which you have to attempt 2. Logic is more important , syntax can be bit here and there. Our first round was on 19th March Technical round for about 1hr 15mins Q1 - Return true/false if there exist 5 consecutive 0 in a string of 0's and 1's(Also optimize for a few test cases) Q2- Write program to find 2nd largest element in array(Asked to Optimize) Q3-Write any one sorting algorithm you know Q4- Multiprocessing vs Multithreading Q5- What is primary and foreign key Q6 - Gave me a table and asked for different SQL queries Q7- DDL and DML Q8 - Truncate vs Delete Q9- Angle between the minute hand and hour hand on clock Q10 - Two ropes are given which take 1 hour to burn each, how will you calculate 45 mins Technical Round 2 Q1- Asked me about myself and projects Q2 - 3 boxes are given , one has gold other 2 do not , they have a writing on them puzzle Q3- Write a code to find equilibrium of array(leftsum should be equal to right sum) Round 3- Q1 - Asked me about myself Q2- My projects Q3 - Why do you take python over java (I was asked my choice of language), tell me from personal expericne Q4- Another few resume based questions.