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 specific, etc.).
5. DSA-1: For a given array of unsorted integers, find the possibility of a 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. (A perfect parent is where 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 involved in, technologies used.
9. Asked about S3 bucket used during internship.
10. Also asked about AWS Services used during internship.
11. Differences between C++ and JS.
12. Which programming language do you prefer to use and why?
13. Do you have any questions for me?

TR2 Questions (Duration: 30-35 mins):

1. Self introduction.
2. DBMS - Normalization techniques, Anomalies, ACID properties.
3. SQL - Given an orders table with customer ID, product quantity, and product price per unit. Find the top 3 spenders. (Note: The customer might repeat as this is an orders table and the primary key is order ID, not customer ID).
4. Given a table, identify its normal form. Discuss the problems within it. Convert it into the next higher normal form and provide an ER diagram for this new normal form state. Discuss the problems within this new normal form and approaches to overcome them.
5. Programming-1: In a word document or text editor, 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. Code this functionality and dry run the code with diverse test cases.
6. Programming-2: Given two dates in DD-MM-YYYY format, calculate the number of days in between. (Guaranteed that the second date is always equal to or greater than the previous date). Dry run the code by considering multiple edge cases and explain how each block of code handles 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 the above question).
4. What role do you like the most: development or testing, and why?
5. Asked about experiences in previous rounds.
6. Write test cases for a coding question asked in previous rounds.
7. Projects - In-depth analysis.
8. Project-related questions, e.g., I used OAuth in one of my projects. Explain its necessity for this project and its complete working.
9. Choose any project and explain its complete architecture.
10. Other than studies - hobbies, interests. (May test whether you genuinely engage in these interests).
11. Do you have any questions for me?

HR Interview Questions (Duration: 5-10 mins):

1. Interview experience.
2. What did you like the most in this interview, and what did you dislike?
3. Relocation (Requires a valid, genuine, and unique explanation).
4. M.S. / M.Tech plans (Requires a valid, genuine, and unique explanation).
5. Expectations from the role.
6. Hobbies.
7. Do you have any questions for me?

DSA

SQL

DBMS

PROJECTS

WORK EXPERIENCE