Skip to contentSkip to footer

Senior Oracle Developer Interview Questions

Salaries
Interviews

1,919 senior oracle developer interview questions shared by candidates

The questions that they asked, really do not seem that hard. You should know what your dependent and independent variables are, if you are writing that paper! And you should know the assumptions that you are making. And you should know which variable you expect to find positive or negative and significant. Sorry to sound rude, but these questions are quite reasonable. Now they should have made you feel comfortable, which they did not and in that way, they clearly were bad interviewers.
avatar

Oracle Database Administrator

Interviewed at Wipro

3.6★
Oct 17, 2016

The questions that they asked, really do not seem that hard. You should know what your dependent and independent variables are, if you are writing that paper! And you should know the assumptions that you are making. And you should know which variable you expect to find positive or negative and significant. Sorry to sound rude, but these questions are quite reasonable. Now they should have made you feel comfortable, which they did not and in that way, they clearly were bad interviewers.

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?

How to import a schema with out data ? How to import full backup with consitent ? how to import a schema into different tablespace ? How to take backup ( DP ) – using SCN number How to Verify how many nodes in oracle Steps for grid Installation ? Patch installation steps , how to verify patch installed or not ? What is golden gate ? rman datafile recovery ? what is control file, if control file is missing how you can recover ? What is SCAN IP ? How to Verify archive log gaps ?
avatar

Senior Oracle-DBA

Interviewed at Wipro

3.6★
May 17, 2022

How to import a schema with out data ? How to import full backup with consitent ? how to import a schema into different tablespace ? How to take backup ( DP ) – using SCN number How to Verify how many nodes in oracle Steps for grid Installation ? Patch installation steps , how to verify patch installed or not ? What is golden gate ? rman datafile recovery ? what is control file, if control file is missing how you can recover ? What is SCAN IP ? How to Verify archive log gaps ?

Viewing 1041 - 1050 interview questions

Glassdoor has 1,919 interview questions and reports from Senior oracle developer interviews. Prepare for your interview. Get hired. Love your job.