Oracle Interview Expertise for Affiliate Advisor (On-Campus)


Oracle got here to our school for on-campus hiring for batch 2023 through which they permit solely CSE, IT, and ECE department college students and they’re hiring for the position of affiliate guide FTE.

There are 3 rounds for the choice course of and each spherical are elimination spherical.

  • Written Spherical
  • Technical Spherical
  • HR Spherical

Spherical 1 Written Spherical (90 minutes): This spherical is carried out on a hackerrank platform. there are 4 sections through which there are 2 coding questions, 1 REST API, 1 DBMS, and 5 MCQs (OS, Pseudocode, DBMS).

Issue: Simple to Medium 

From 1200 college students solely 42 had been chosen for the interview spherical a lot of the college students had been eradicated based mostly on relaxation API questions. So, no less than attempt to resolve 2 Coding & SQL or 1 Coding, SQL & REST API.

Spherical 2 (Technical Spherical): Firstly, the Interviewer ask me to introduce myself after which about my tasks which I discussed in my resume then she requested why you select this venture and from the place get the thought to do that venture I answered, after which she requested what are the algorithm’s you have got utilized in your tasks. then she requested some OOPs ideas like defining Polymorphism, Inheritance after which she provides me 3 coding questions and asks me to share my display and code it. the primary query is to reverse a string utilizing totally different strategies, the second is a Binary search algorithm and the third one is from SQL to put in writing a question to fetch the wage of staff who’re working in a division the place the of staff is larger than 3. I answered 2 coding questions however I’m not capable of third one.

after this, she asks me if in case you have any questions can ask I ask about her expertise in oracle. after this, she requested me to depart the assembly room and wait within the ready room. then a second interview spherical is carried out.

Spherical 3 (HR Spherical): For some college students, it’s fully HR Spherical. However for me fully Technical spherical firstly interviewer ask me to introduce myself after which ask about my tasks and what I study extra from these tasks aside from my lecturers and what are sources I used to study then he ask about API which I utilized in my venture. Then he some Fundamentals OOPs ideas, that’s all after which he asks if in case you have any questions for me.

Notice: Be assured in each spherical of interviews and attempt to reply level to level for each query and be ready for all issues which you talked about in your resume, particularly tasks.

Lastly, 18 college students had been chosen from our school.

Thank You. All The Finest.


Leave a Reply

Your email address will not be published. Required fields are marked *