Upload Button Icon Add office photos

Oracle

Compare button icon Compare button icon Compare
3.8

based on 4.4k Reviews

HQ - Austin,Texas, United States Software Product 50k-1 Lakh Employees (India) +3 More
award

#22 Best Mega Company - 2022

award
award

#3 Best Mega Internet/Product Company - 2022

award

Filter interviews by

Oracle Interview Questions, Process, and Tips

Updated 2 Mar 2024

Top 10 Oracle Interview Questions and Answers

Curated by AmbitionBox

  • Q1. Minimum Cost to Connect All Points You are given an array, ‘COORDINATES’ that represents the integer coordinates of some points on a 2D plane. Your task is to find the mi...read more
    Asked in Application Developer interview
  • Q2. 1. Write a program to remove duplicate elements from String and mention the count of duplication.
    Asked in Associate Consultant interview
  • Q3. Triplets with Given Sum You are given an array/list ARR consisting of N integers. Your task is to find all the distinct triplets present in the array which adds up to a g...read more
    Asked in Software Developer interview
  • Q4. Regular Expression Match Given a string ‘str’ and a string ‘pat’. The string s has some wildcard characters i.e ‘?’ and ‘*’. If any character is a ‘?’ we can replace that...read more
    Asked in Member Technical Staff interview
  • Q5. Intersection of Linked List You are given two Singly Linked List of integers, which are merging at some node of a third linked list. Your task is to find the data of the ...read more
    Asked in Senior Application Developer interview
  • Q6. Number and Digits You are given a positive number ‘N.’ You need to find all the numbers such that the sum of digits of those numbers to the number itself is equal to ‘N.’...read more
    Asked in Mts1 interview
  • Q7. Reverse Words in a String You are given a string of length N. You need to reverse the string word by word. There can be multiple spaces between two words and there can be...read more
    Asked in Software Engineer interview
  • Q8. Explain how CLR works
    Asked in Senior Software Developer interview
  • Q9. What is difference between writing rule in Excel and word in oracle policy automation
    Asked in Senior Consultant interview
  • Q10. How to solve the question 1 with O(n),O(logn) time complexity
    Asked in Server Technology interview

548 Oracle Interview Experiences

1.4k questions found

Sort by: Popular
user image Anonymous

posted on 13 Sep 2023

Interview experience
Rating 4
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at National Institute of Technology (NIT), Tiruchirappalli and was interviewed in Aug 2023.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2

Coding Test Round

1 hour - Coding question-hard type palindrome type question , 10 MCQs including aptitude, math and paragraph question and finally a RESTAPI question on hackerrank platform

3

One-on-one Round (4 Questions)

  • Q1. Resume scrutiny about projects and internship
  • Q2. There N rooms in a hotel so customers will check-in and check-out a rooms simultaneously so which type of data structure you implement and it should be efficien...read more
  • Q3. There are 25 horses in which you need to find out the fastest 3 horses. you can conduct a race among at most 5 horses to find out relative speed. At no point, y...read more
  • Q4. There is snail which has to climb a ramp of some slope with length of 30ft while climbing the ramp the snail moves 3ft/hour up and simultaneously moves 2ft/hour...read more
4

One-on-one Round (3 Questions)

  • Q1. You have given array of numbers in which you need to write an algorithm to sort them (preferably in java)
  • Q2. SQL-QUERY, There is a department table with department name ,department ID and with staff members ID who are working in department and also there is a Staff mem...read more
  • Q3. How do you measure 4 liters with a 5 liters and 3 liters container

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare with puzzles as they are asking so many puzzle questions in the interview, brush up your DSA skills from basics and SQL is very important for oracle. they encourage java programmers a lot.

Top skills recommended for Oracle Application Developer interview

Insights by AmbitionBox
  • Javascript
  • Application Development
  • C++
  • J2Ee
  • Java
  • SQL
  • HTML
  • Python
user image Anonymous

posted on 10 Feb 2024

Interview experience
Rating 3
Average
Difficulty level
-
Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Jan 2024.

1 Interview Round

1

Technical Round (5 Questions)

user image Anonymous

posted on 23 Feb 2024

Interview experience
Rating 4
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
-

I applied via Approached by Company and was interviewed in Jan 2024.

3 Interview Rounds

1

Interview Round (1 Question)

  • Q1. Interviewer divided questions to Manual testing, Agile, Automation. Not asked to share my screen and asked lot of questions.
2

Technical Round (2 Questions)

  • Q1. Java coding questions and Selenium related too Not too difficult as I kept 2 years experienced. It is more to test my Logical thinking for a problem.
  • Q2. Pallindrome, largest of an array, if else block related coding question, selenium real time scenario
3

Technical Round (1 Question)

  • Q1. Not yet conducted. In 2 days I am going to attend

Interview Preparation Tips

Topics to prepare for Oracle Selenium Automation Tester interview:
  • Core Java
  • Selenium

Oracle interview questions for popular designations

Software Developer

 (35)

Application Developer

 (25)

Software Engineer

 (23)

Applications Engineer

 (15)

Member Technical Staff

 (15)

Senior Software Engineer

 (15)

Senior Consultant

 (14)

Associate Consultant

 (11)

user image Anonymous

posted on 17 Nov 2023

Interview experience
Rating 3
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in May 2023.

5 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

HR Round (1 Question)

3

Technical Round (1 Question)

  • Q1. Question 1:- Two Sum Question 2:- Three Sum Question 3:- Anagram in String
4

Technical Round (3 Questions)

5

Technical Round (3 Questions)

  • Q1. Design circular doubly linked list with all operations.
  • Q2. Discussion on past projects, toughest problem solved till now.
  • Q3. Different types of searching and sorting algo discussion.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep Applying, focus was to code problems in Java.

Top skills recommended for Oracle Application Developer interview

Insights by AmbitionBox
  • Core Java
  • JQuery
  • Jenkins
  • Microservices
  • PLSQL
  • ASM
  • Corporate Banking
  • Customer Satisfaction
user image Anonymous

posted on 7 Oct 2022

I applied via Approached by Company and was interviewed in Sep 2022.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2

Technical Round (12 Questions)

3

Technical Round (11 Questions)

4

Domain Interview Round (6 Questions)

Interview Preparation Tips

Topics to prepare for Oracle Associate Consultant interview:
  • Java
  • Spring Boot
  • REST API
  • JPA
Interview preparation tips for other job seekers - 1. Focus more on coding questions as question may differ.
2. Be confident on Java 8 features.

Top skills recommended for Oracle Associate Consultant interview

Insights by AmbitionBox
  • Capital Market
  • Investment Banking
  • mortgage
  • Derivatives
  • Finance
  • Financial Services
  • Fixed Income
  • Fund Accounting
user image Anonymous

posted on 13 Oct 2023

Interview experience
Rating 4
Good
Difficulty level
-
Duration
-
Result
-

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
2

Coding Test Round

1 DSA Question ( LIS DP )
1 Rest Api Question
Hacker Rank Platform
Duration 1.5 hr

3

One-on-one Round (5 Questions)

  • Q1. DSA Questions Resume Projects and skills
  • Q2. Convert a number to english form that how it can be read in english .
  • Q3. Eliminate Duplicates in array .
  • Q4. How you build the project mentioned in my resume. What are take ways , why this tech stack is used , how this feature is added more discussion.
  • Q5. Some oops Java questions like Difference between Interfaces and abstract classes, why interfaces are used . Some more general oops questions . Also encryption r...read more

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare DSA , prepare projects mentioned in resume.
Have a good CGPA .

Top skills recommended for Oracle Software Engineer interview

Insights by AmbitionBox
  • Java
  • Javascript
  • SQL
  • Software Development
  • C++
  • Software Engineering
  • C
  • CSS

Jobs at Oracle

View all
Lead Financial Analyst

Bangalore / Bengaluru

5-10 Yrs

₹ 10.1-11 LPA

Oracle EBS/ Fusion Finance (Technical/ Functional Consultant)

Bangalore / Bengaluru,

Hyderabad / Secunderabad

5-10 Yrs

₹ 3.8-11.5 LPA

ODI Developer

Bangalore / Bengaluru

4-9 Yrs

Not Disclosed

Senior Security Analyst

Bangalore / Bengaluru

4-8 Yrs

Not Disclosed

Software Development Senior Manager

Bangalore / Bengaluru

10-14 Yrs

Not Disclosed

Sr. Java developer

Bangalore / Bengaluru

4-9 Yrs

Not Disclosed

user image Anonymous

posted on 11 Oct 2023

Interview experience
Rating 3
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 2023.

4 Interview Rounds

1

Coding Test Round

One binary search question ( aggressive cow) and one restapi

2

Technical Round (1 Question)

3

Technical Round (1 Question)

4

Technical Round (2 Questions)

Top skills recommended for Oracle Application Developer interview

Insights by AmbitionBox
  • Dataguard
  • Docker
  • Hibernate
  • Html5
  • Installation
  • JPA
  • Middleware
  • ODI

Oracle Database Administrator interview

user image edureka!

posted on 24 Nov 2021

user image Anonymous

posted on 29 Oct 2023

Interview experience
Rating 5
Very good
Difficulty level
Hard
Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2023.

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
2

Technical Round (3 Questions)

  • Q1. How the solution can be implemented based on the case or customer requirement?
  • Q2. What kind of Fast Formulas are used to meet the requirement?
  • Q3. Payroll process that are generic for all countries
3

One-on-one Round (2 Questions)

Top skills recommended for Oracle Principal Consultant interview

Insights by AmbitionBox
  • Cloud
  • ERP Implementation
  • Accounting
  • EBS
  • ERP
  • Finance
  • Mba Finance
  • Oracle Apps

SMTS Interview Questions

user image Anonymous

posted on 26 Feb 2024

Interview experience
Rating 4
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jan 2024.

4 Interview Rounds

1

Technical Round (1 Question)

2

Technical Round (1 Question)

3

Technical Round (1 Question)

4

Technical Round (1 Question)

Oracle Interview FAQs

How many rounds are there in Oracle interview?
Oracle interview process usually has 2-3 rounds. The most common rounds in the Oracle interview process are Technical, Resume Shortlist and One-on-one Round.
How to prepare for Oracle interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Oracle. The most common topics and skills that interviewers at Oracle expect are Java, Javascript, J2Ee, Microservices and Spring Boot.
What are the top questions asked in Oracle interview?

Some of the top questions asked at the Oracle interview -

  1. Puzzle: – Two persons X and Y are sitting side by side with a coin in each’...read more
  2. Tell me about the OS your phone uses? What are the other phone operating system...read more
  3. 1. Write a program to remove duplicate elements from String and mention the cou...read more
How long is the Oracle interview process?

The duration of Oracle interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Interview Process at Oracle

based on 152 interviews in last 1 year

Interview experience

Rating 4.1
Very Good
View more

Difficulty level

Easy 10%
Moderate 81%
Hard 9%

Duration

Less than 2 weeks 67%
2-4 weeks 18%
4-6 weeks 7%
6-8 weeks 4%
More than 8 weeks 4%

People are getting interviews through

based on 296 Oracle interviews
Job Portal
Campus Placement
Referral
Company Website
Recruitment Consultant
Walkin
43%
18%
15%
5%
2%
1%
16% candidates got the interview through other sources.
High Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.

Interview Questions from Similar Companies

Amdocs Interview Questions
4.0
 361 Interviews
Zoho Interview Questions
4.4
 215 Interviews
SAP Interview Questions
4.3
 193 Interviews
Adobe Interview Questions
4.2
 157 Interviews
Chetu Interview Questions
3.3
 122 Interviews
View all

Oracle Reviews and Ratings

based on 4.4k reviews

3.8

Rating in categories

 3.6

Skill development

 4.1

Work-Life balance

 3.2

Salary & Benefits

 4.0

Job Security

 3.8

Company culture

 2.9

Promotions/Appraisal

 3.5

Work Satisfaction

Reviews
Explore 4.4k Reviews and Ratings
Lead Financial Analyst

Bangalore / Bengaluru

5-10 Yrs

₹ 10.1-11 LPA

Oracle EBS/ Fusion Finance (Technical/ Functional Consultant)

Bangalore / Bengaluru,

Hyderabad / Secunderabad

5-10 Yrs

₹ 3.8-11.5 LPA

ODI Developer

Bangalore / Bengaluru

4-9 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
2.4k salaries
23.0 Lakhs

₹9.6 L/yr - ₹36.0 L/yr

Senior Consultant
2.2k salaries
17.2 Lakhs

₹8.9 L/yr - ₹28.0 L/yr

Senior Member of Technical Staff
2k salaries
26.5 Lakhs

₹11.5 L/yr - ₹40.7 L/yr

Principal Consultant
1.9k salaries
25.2 Lakhs

₹13.0 L/yr - ₹36.0 L/yr

Senior Application Engineer
1.6k salaries
19.6 Lakhs

₹8.0 L/yr - ₹29.4 L/yr

Explore more salaries
Compare Oracle with

SAP

4.3
Compare

Salesforce

4.1
Compare

IBM

4.1
Compare

MongoDB

4.2
Compare