Skip to contentSkip to footer

Oracle Interview Questions

Salaries
Interviews

1,918 oracle 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?

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 1051 - 1060 interview questions

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