Skip to contentSkip to footer

Oracle Software Engineer Interview Questions

Salaries
Interviews

1,918 oracle software engineer interview questions shared by candidates

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?
avatar

Oracle Developer

Interviewed at HCLTech

3.5★
Dec 25, 2016

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?

Interview questions were based on some database concepts, Some manegerial questions that test your problem solving and critical thinking ability - 15 uses of pen - some puzzles - difference between sharpener and eraser etc They dont conduct Aptitude but generally cover it indirectly in your PI
avatar

Oracle Consultant

Interviewed at EVOSYS

3.9★
Sep 21, 2018

Interview questions were based on some database concepts, Some manegerial questions that test your problem solving and critical thinking ability - 15 uses of pen - some puzzles - difference between sharpener and eraser etc They dont conduct Aptitude but generally cover it indirectly in your PI

Viewing 1681 - 1690 interview questions

Glassdoor has 1,918 interview questions and reports from Oracle software engineer interviews. Prepare for your interview. Get hired. Love your job.