Oracle Interview Expertise for Affiliate Advisor (On-Campus)

[ad_1]

Oracle got here to our school for on-campus hiring for batch 2023 during which they permit solely CSE, IT, and ECE department college students and they’re hiring for the function 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 performed on a hackerrank platform. there are 4 sections during 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 many 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 initiatives which I discussed in my resume then she requested why you select this venture and from the place get the concept to do that venture I answered, after which she requested what are the algorithm’s you will have utilized in your initiatives. 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 completely 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 in a position to third one.

after this, she asks me you probably 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 performed.

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 initiatives and what I be taught extra from these initiatives other than my lecturers and what are sources I used to be taught then he ask about API which I utilized in my venture. Then he some Fundamentals OOPs ideas, that’s all after which he asks you probably have any questions for me.

Word: 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 initiatives.

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

Thank You. All The Finest.

[ad_2]

Leave a Reply