Skip to contentSkip to footer

Oracle Interview Questions

Salaries
Interviews

1,919 oracle interview questions shared by candidates

Technical Questions: • Core Java concepts: OOP, inheritance, polymorphism, interfaces, abstract classes. • Java 8+ features: Streams, Lambda expressions, Optional, Date/Time API. • SQL queries, joins, aggregations, and basic database concepts. • Data structures & algorithms: arrays, lists, sorting, searching (basic level). • Spring Boot / REST APIs basics (if relevant to your project). Behavioral / HR Questions: • Tell me about yourself. • Explain your past projects (e.g., PFE, Taxigo, INE-Alumni). • Challenges you faced and how you solved them. • Teamwork and problem-solving examples. • Why Oracle / why this internship.
avatar

Oracle internship

Interviewed at Oracle

3.5★
Oct 6, 2025

Technical Questions: • Core Java concepts: OOP, inheritance, polymorphism, interfaces, abstract classes. • Java 8+ features: Streams, Lambda expressions, Optional, Date/Time API. • SQL queries, joins, aggregations, and basic database concepts. • Data structures & algorithms: arrays, lists, sorting, searching (basic level). • Spring Boot / REST APIs basics (if relevant to your project). Behavioral / HR Questions: • Tell me about yourself. • Explain your past projects (e.g., PFE, Taxigo, INE-Alumni). • Challenges you faced and how you solved them. • Teamwork and problem-solving examples. • Why Oracle / why this internship.

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 1031 - 1040 interview questions

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