In this round, there was no Q to code. All questions were MCQ. The difficulty was maintained throughout the test. There were many subsections under one section and a separate time limit for every subsection. No negative marking. There were Q from every topic - DSA, DBMS, OS, mental ability, vocabulary, english comprehension, maths. In the mental ability section, there were various sub-sections for logical ability, data analysis and critical thinking, attention to detail, and quantitative ability. This section had medium level questions, and time was relatively harder to manage. It was expected to know advanced data structures such as AVL trees. There were also Q over given codes, Q related to block diagrams, and OOPS. Some Q were there related particularly to JAVA. The last section was subjective. There were 2 Q- "why you want to join Oracle", and another situation-based. Clock ticking within 10 min for every subsection creates pressure. But you could relax between 2 sections since the camera stays off at that time. All that makes this round difficult is TIME.
In this round, firstly he asked Q related to my CV and information given during the introduction. 2 coding Q were given(easy). Prefer JAVA/CPP. They will try to provoke you to check how confident you are over your solution. The interviewer asked Q about the skills mentioned in the CV. He asked me Q related to data structures and oops. There was a deep discussion over CV. He tried to know the way how I approach a new problem somewhere related to my projects. He was supportive and helped me to approach the final solution. Although the code was perfect, interviewers score us based on our logic. ofc if the code is correct, the interviewer gets impressed.
This round started with an introduction. Then HR asked me to explain him all projects mentioned in my CV. Then there was a discussion over the fields related to my projects. Then he gave me coding Q too to check my coding skills. Later he asked me 1 puzzle(3lit jar, 5lit jar, make 4lit water). He asked me some situation based Q. He asked me "Since you are from ECE background, why are you doing coding?". He asked me about my hobbies. In the end, I asked him what will my job be? He gave me details about Oracle-FSGBU and said that projects are not decided but I would be working in one of these fields(the ones mentioned in details). Meanwhile we solve Q, HR checks our CV.
First-round was hard. After that interviewers check our approach, how we deal with the situation or how we solve the problem. Interviewers' intention is not to find ways to reject us, but they help us to solve problems and approach the solution. Whatever you mention in your CV, you must be fully acquainted with those subjects or skills. Use JAVA/CPP. cause they are fast as well as your basics become clear.