Skip to contentSkip to footer

Oracle Interview Questions

Salaries
Interviews

1,916 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

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?

Principais desafios nos ultimos projetos e como lidei Principais entregas e resultados Motivos das finalizações dos ultimos clientes Como foram meus ultimos 3 clientes/projetos O que motiva meu dia a dia nos projetos O que eu poderia agregar a empresa em conhecimentos/habilidades e qual minhas expectativas
avatar

Consultor Funcional Oracle

Interviewed at Birlasoft

3.4★
Oct 11, 2022

Principais desafios nos ultimos projetos e como lidei Principais entregas e resultados Motivos das finalizações dos ultimos clientes Como foram meus ultimos 3 clientes/projetos O que motiva meu dia a dia nos projetos O que eu poderia agregar a empresa em conhecimentos/habilidades e qual minhas expectativas

Viewing 1561 - 1570 interview questions

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