Skip to contentSkip to footer

Software Engineer Production Support Interview Questions

Salaries
Interviews

563 software engineer production support 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 and Support

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?

Viewing 261 - 270 interview questions

Glassdoor has 563 interview questions and reports from Software engineer production support interviews. Prepare for your interview. Get hired. Love your job.