Skip to contentSkip to footer

Oracle Software Engineer Interview Questions

Salaries
Interviews

1,918 oracle software engineer interview questions shared by candidates

Triggers, type of trigger, Package... only specification enough , body required? Which is mandatory? If specification has 2 procedure and 2 functions and body doesn't have one function among them will it error ? Difference between procedure and package? What's a sequence ? Select seq.curval, seq.nextval from dual; - what will be the output of this query if it is a fresh sequence? Types of indexes? Views... can DML be performed in complex views? Example of implicit cursor ? What are cursors? Keys- primary , unique, composite ? Cursor attributes.. can we use cursor attributes in implicit cursor ? Reference cursor? Where can you find the list of views? What are Trigger event ? Materialized view? How materialized view is refreshed ? What is clustered index? Btree index?
avatar

Oracle Developer and Support

Interviewed at HCLTech

3.5★
Dec 25, 2016

Triggers, type of trigger, Package... only specification enough , body required? Which is mandatory? If specification has 2 procedure and 2 functions and body doesn't have one function among them will it error ? Difference between procedure and package? What's a sequence ? Select seq.curval, seq.nextval from dual; - what will be the output of this query if it is a fresh sequence? Types of indexes? Views... can DML be performed in complex views? Example of implicit cursor ? What are cursors? Keys- primary , unique, composite ? Cursor attributes.. can we use cursor attributes in implicit cursor ? Reference cursor? Where can you find the list of views? What are Trigger event ? Materialized view? How materialized view is refreshed ? What is clustered index? Btree index?

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
avatar

Oracle Applications Functional Consultant

Interviewed at PwC

3.7★
Feb 13, 2015

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

Viewing 1071 - 1080 interview questions

Glassdoor has 1,918 interview questions and reports from Oracle software engineer interviews. Prepare for your interview. Get hired. Love your job.