The first two rounds were typical technical rounds and then I had an onsite technical round... I cleared all the technical rounds. Then there was a test on english Proficiency which I was able to clear as well. Then I had a discussion with director who does not know how to behave with people. He believes that interview is a one way process and things people who have come for interview are his slaves. He asked me to stand up and explain ...this shows his level of maturity..very very cheap and unprofessional... says you have not done any certification atleast for 5 times. ... Finally I though enough is enough after all the humilation that I faced and I walked out of the interview mid way. This is the worst experience in my life.... very very unprofessional behavior. This was for PWC SDC Bangalore unit for oracle apps SCM functional consultant role
Oracle Interview Questions
1,919 oracle interview questions shared by candidates
Tell me about yourself why this role and company
Tell us a situation where you faced a problem with your team member and how you solved it
He had made some questions like ONE SIZE FITS ALL for all Oracle modules such as Order to Cash, Purchase, Inventory, etc and asked all random questions one after the other. If a question was outof their job scope and they think for a minute before answering he mentioned OK YOU KEEP THINKING LATER NOW I WILL ASK NEXT QUESTION. (3) He was highly sarcastic of every word in resume and sort of challenged on them with toxic comments.
It was programing aptitude round asked about procedure, triggers, views
What is Trigger? The code
Find the department ID that has the highest average maximum salary
What is the difference between where and having clauses?
Relating real life examples with solutions
Performance tuning related questions and advance sql.
Viewing 1041 - 1050 interview questions