They asked a lot of technical questions and went in depth into the project I’m currently working on.
Oracle Consultant Interview Questions
1,923 oracle consultant interview questions shared by candidates
SOA Architecture, Current working Projects
Regarding product knowledge , working hours
Generally, they asked about the production side.
I was having ample experience and I did not think my interviewers were there to reject me
Comente sua trajetória em inglês.
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?
Day to day activities in current role?
1-How to itegrate 2-java 3-Oracle
What is the best possible way to avoid dead locks in concurrent programs that has several DML statements in it.
Viewing 1051 - 1060 interview questions