procedure creation, analytical functions, procedure vs function
Oracle Developer Interview Questions
1,918 oracle developer interview questions shared by candidates
Oracle technical questions on plsql , SQL, report and fprm
How comfortable i'm with my skill set.
Explain the Oracle DBA architecture and real time challenges in current projects?
1. Hcm extracts is runnig daily on old date where will you setup for to run current date? 2. How and where to configure the FTP setup in BIP Reports?
oracle architecture,RAC and data guard basis,Data migration and restoration concepts,Handful of day to day queries and unix level commands and automation ideas
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?
What are Global Temporary Tables? How to use them?
descibed a situation how and when you hav motivate your team
Reasons for leaving current role.
Viewing 1671 - 1680 interview questions