TR1 Questions (Duration: 30-35 mins): 1. Self Introduction. 2. Projects 3. DBMS 4. Second highest salary - answer multiple approaches and also inform about the type of SQL query (MySQL specific, oracle db specific, etc..) 5. DSA-1: For a given array of unsorted integers find the possibility of sum of a pair to give a target K. 6. DSA-2: For a given tree verify if it is a perfect parent or not. (Perfect parent is where if the parent node value is equal to the sum of the values of its child nodes). 7. Javascript - promises, callback functions. 8. Internship experience - project that I'm involved in, technologies I used in it. 9. Asked about S3 bucket which I used in my internship. 10. Also asked about AWS Services which I used in my internship. 11. Differences between CPP and JS 12. Which prg language i prefer to use and why. 13. Do you have any questions for me? TR2 Questions (Duration: 30-35 mins): 1. Self introduction. 2. DBMS - Normalisation techniques, Anolamlies, ACID properties. 3. SQL - Given a table order table with customer id, product quantity and product price per unit. Find the top 3 spenders. (Note: the customer might repeat as this is orders table and primary key is order I'd not customer id). 4. Given a table and asked me to identity it's normal form. And asked for the problems with in it. Asked to convert it into next higher normal form and asked for an ER diagram for this new normal form state. And asked for the problems with in this new normal form and approaches to over come it. 5. Programming-1: In word document or text editors when a line is out of space to fit a complete word we need to move that complete word to the next line rather than breaking the word into two lines. He asked me to code this functionality and dry run my code with diverse test cases. 6. Programming-2: Given two dates in DD-MM-YYYY format and aksed to calculate due number of days in between (guaranteed that second is always equal or greater than the previous date). Asked me to dry run the code by thinking for multiple edge cases and asked to explain how each block of code is handling each edge case. 7. Do you have any questions for me? TR3 (Managerial) Questions (Duration: 30-35 mins): 1. Self introduction. 2. Why oracle? 3. Why only oracle? (This question might be specific to your answer for above question) 4. What role do you like the most developement or testing and why? 5. Asked about my experiences in previous rounds. 6. Write testcases for a coding question asked in previous rounds. 7. Projects - (Indepth analysis of them) 8. Project related questions like - I used OAuth in one of my projects. So he asked me to explain its necessity for this project and it's complete working. 9. Choose any project and explain the complete architecture of it. 10. Other than studies - hobbies, what are your interests. He might also test you in those interests whether do you really do them in real life. 11. Do you have any questions for me? HR Interview Questions (Duration: 5-10 mins): 1. Interview experience. 2. What do you like the most in this interview and what did you hate. 3. Relocation (they look for valid, genuine and unique explanation for your answer). 4. M.S. / M.Tech plans (they look for valid, genuine and unique explanation for your answer). 5. Expectations from the role. 6. Hobbies. 7. Do you have any questions for me?