Technical Questions
Oracle Consultant Interview Questions
1,922 oracle consultant interview questions shared by candidates
About u r experience and profile
descibed a situation how and when you hav motivate your team
ora 1555 was the 1st question asked, grow up guys..wen u think u start from basics, u have more nd more to drill me to understand me..1st listen my intro or walk through my profile to know me
Core HR Payroll Absence Management Benefits OTL
Oracle technical questions on plsql , SQL, report and fprm
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?
If you have an under performer in your team, how do you manage that. Flexible picking other ERP technologies.
Oracle data guard , rac
self join, cursors and its types, functions, procedures, can we have commit in functions, framing query for business logic
Viewing 1631 - 1640 interview questions