It was campus recruitment.

There were four rounds of interview, all of them technical for the most part.

The last interview included a few HR questions.

The major areas of questioning were from:

• Java
• SQL
• Oracle Cloud (OCI)

First round of interview:

• Asked to write code in Java.
• A few questions about my internship and the work I did there.
• Also, some basic SQL queries.

Second round of interview:

• Convert a Java object to an XML form.
• Asked about a project from my resume: a project I did in a Compiler course, which was to implement an interpreter.

Third round:

• To write C++ code to sort an array, or something very similar.
• Two puzzles:
  • Fox and duck puzzle: One is in the middle of a circle, and the other can't enter this circle. What is the best path for the animal in the middle to escape?
  • Some square cutting puzzle: I don't remember this, but I suggest going through puzzles on Indiabix or CrazyForCode.

Fourth round:

• My strengths and weaknesses.
• To design a system to book reservations in a restaurant.
• A complex SQL query.
• Why do you want to work for Oracle?
• What Oracle products do you know about?