asked to write sql queries and asked "what is" questions on plsql
Oracle Software Engineer Interview Questions
1,915 oracle software engineer 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
See Interview Questions for Similar Jobs
Erp Software EngineerSap Software EngineerTechnology LeadOracle Soa DeveloperSenior Backend EngineerJava Solution ArchitectTechnical LeadSenior Back End EngineerSenior Software DeveloperJqueryFront End EngineerSenior Back-end EngineerMessage BrokerSoftware ArchitectSr. Software DeveloperSenior DeveloperSoftware Engineer Web DeveloperAws Solution Architect