Aptitude, analytical, and technical (Online paper on Oracle's career website). Consists of C, C++, Data Structures, OOPs, DBMS, Java, OS.

3 PI technical rounds (Data Structures, DBMS, C++, OOPs), each around 1 hour.

1 PI HR round (20-25 minutes).

1st Round: Analytical & Technical Aptitude (2 hours)

• C
• Java
• DBMS
• OS

2nd Round: 1st PI Technical

• Tell me why you want to join Oracle.
• If I give you two numbers x and y, then find the last digit of x^y.
• Implement a Queue using two Stacks.
• All the joins in SQL.
• Some simple basic queries.
• A file is given with many words inside, separated by commas. A word will be given which is to be found in that file.

3rd Round: 2nd PI Technical

• Convert a BST into a DLL.
• Design a data structure so that push, pop, and min() take O(1) time.
• Design a data structure so that find takes minimum time.
• A sorted array is rotated 'r' times; you have to find 'r' in O(log n).
• Given a number and a sorted array, find the number of times the number is repeated in O(log n).

4th Round: 3rd PI Technical

• Some basic questions from class, OOPs concepts.
• What is normalization and its different forms?
• Because I am from Electrical, he asked why software.

5th Round:

• This was just to confirm where I want to join, and they explained about Oracle.
• Little about family and where do you see yourself in 5 years.

That's all.