There were three rounds of technical interview and one round of separate HR interview.HR interview is mainly for show.The interview rounds mainly comprises of SQL and PL/SQL questions.I didnt have PLSQL in my CV so they asked me from C and SQL.In SQL of course they'll ask you to write the query for Second highest marks in a class or second highest salary in a department.From C they asked tic-tac-toe questions.Aptitude questions were also there,most of which i could answer,all but one actually.Then they ask you for project work and all.In my opinion,luck and body language is key in Oracle interviews.

HR screen was great, felt very comfortable, basic screening telling about the job, pay, etc. Tech interview was honestly a nightmare, it was with a programmer from the India team. Never shared the cam so it was talking to a black screen. Had a very strong accent and needed to ask him to write some words in the Zoom chat because I couldn't understand them (also bad audio). After 45 minutes asking questions about my CV and some of the technologies listed there, we did the typical hackerrank medium exercise. I had like 12 minutes and did below average, pointing it was just a quick solution and had flaws but passed the test. Three weeks later they told me they were not following the process.