asked to write sql queries and asked "what is" questions on plsql
Oracle Developer Interview Questions
1,915 oracle developer interview questions shared by candidates
Oracle technical questions on plsql , SQL, report and fprm
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
As i had worked on all things i wrote, the technical interview was like a cakewalk.
How would you approach a non-performing sql job.
SQL tuning and architecture related
Describe a difficult team member situation.
Have you used any analysis tools?
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?
Join queries and normalisation , familiarity with other databases.
Viewing 1561 - 1570 interview questions