I applied through a recruiter. I interviewed at Oracle (Bengaluru) in Mar 2017
Interview
Consisted of 3 Rounds
1.) Online Test
2.) Telephonic (2 Interviewer)
3.) F2F (2 Interviewer)
All interviews went very well, but after the 3rd round i did not hear back from HR.
no mails were answered about the status of interview
multiple hr's were involved, none responded.
So I called the HR who had scheduled my last interview and asked for an update and this was the answer i got "I dont recall you gave interview here !!!!!!! , let me check and get back to you !! )
Overall interview exp was good, but from the HR side they should at least have the professionalism to tell to a candidate if they are selected or not (at least not "I dont recall you gave interview here !!)
Interview questions [1]
Question 1
Round 1: Online Test (20 questions)
Basic PL/SQL Questions
Round 2: Telephonic (1 Hr)
tell me about urself
work u have done till now
Cursors
Triggers
Indexes
Pragma
Round 3 F2F (Technical and Managerial) (1 Hr 45 Mins)
Interviewers were friendly
why do we use index
what happens in backend when you create index
what will happen if you apply index on multiple column
plsql code tuning
what will you do if a query is working on your system and the same query is not working in clients system (Explain plan for both are same)
if your manager gives you work on friday which you have to complete it by monday and at the same time your parents are coming from your hometown what will you do?
PL/SQL Objects
types of SDLC model
tell about a situation when you have disagreement with your co-worker
how will you handle failure
questions on cursors, trigger (basic questions)
I applied through a recruiter. The process took 2 months. I interviewed at Oracle (Ciudad de Mexico) in Nov 2021
Interview
Fueron 2 entrevistas con las reclutadoras me imagino que una junior y la otra senior, luego entrevista con el mánager del proyecto y 2 entrevistas técnicas finales con gente del proyecto (1 de la india y el otro de Filipinas), lamentablemente después de tanto tiempo invertido me hacen una propuesta salarial muchísimo menor al salario de la empresa en la cual laboro actualmente, lo cual me parece absurdo y una falta de respeto, ya que desde un inicio les hice saber mis pretensiones económicas, no se si pensaban que al final les iba a decir: "Si, está bien, me voy con ustedes por un 40% menos de lo que gano actualmente solamente por ser Oracle". Una rotunda decepción.
Interview questions [1]
Question 1
Preguntas diversas sobre mi experiencia y sobre desarrollo de queries en SQL, además de algunas preguntas de acertijos.
I applied through an employee referral. I interviewed at Oracle (Chennai) in Aug 2021
Interview
Breakout rooms in Zoom, individual one to one basis, first the HR will guide us with the process and then tech person will take the interview. Based on the results, I did not proceed to further rounds
Interview questions [1]
Question 1
What is alias? how is it different from actual name
