Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

VIEW WINNERS
- ABECA 2025
  
  VIEW WINNERS
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
Participate in ABECA 2026

Add office photos

Engaged Employer

Oracle

Compare

3.7

based on 5.6k Reviews

Video summary

Filter interviews by

Oracle Consultant Interview Questions and Answers

Updated 28 Oct 2024

Oracle Consultant Interview Experiences

11 interviews found

Consultant Interview Questions & Answers

Anonymous

posted on 28 Oct 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Coding Test

2 sum problem along with grilling on dbms

Consultant Interview Questions & Answers

richa srivastav

posted on 13 Jun 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

6-8 weeks

Result

Selected

I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical

(2 Questions)

Q1. What is UDA? Give an example from your projects.

Add your answer

Q2. Give an example of a business rule from your project.

Add your answer

Consultant Interview Questions & Answers

Anonymous

posted on 6 Jul 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - One-on-one

(1 Question)

Q1. HCM basics, SQL, Tables

Add your answer

Round 2 - Technical

(1 Question)

Q1. Projects worked on

Add your answer

Consultant Interview Questions & Answers

Anonymous

posted on 30 May 2024

Interview experience

Average

Difficulty level

Process Duration

Result

Round 1 - One-on-one

(1 Question)

Q1. General questions

Add your answer

Round 2 - One-on-one

(1 Question)

Q1. About previous role taken

Add your answer

What people are saying about Oracle

View All

zealousbroccolini

works at

Motherson Technology Services

Oracle SCM 3YOE – Mexico onsite offer: ₹90K/month + perks. Fair or should I negotiate?

Current Role: Oracle SCM Consultant (3YOE), ₹6.5LPA in India.(Including allowances ) Mexico Offer: ~₹90K/month + housing, car, petrol, flights. Handling apps/hardware(sometimes when other person not available). Offer delayed (15-20 days). Manager says "low exp = low pay." Questions: 1. Is ₹90K + perks fair for 3YOE in Mexico? 2. Should I push for more due to extra responsibilities? 3. Onsite experience for 4 years vs. ₹10LPA in India – which is better long-term? 4. Red flags? Delay normal? Need advice! #OracleSCM #Onsite #Mexico

Got a question about Oracle?

Ask anonymously on communities.

Consultant Interview Questions & Answers

Anonymous

posted on 20 May 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - Coding Test

Python, java, ds, decision tree

Round 2 - Technical

(2 Questions)

Q1. What is list do?

Ans.

List is a data structure that stores a collection of items in a specific order.

Lists can be used to store items of the same or different data types.
Items in a list can be accessed by their index.
Lists can be modified by adding, removing, or updating items.
Examples: shopping list, to-do list, list of students in a class.

Answered by AI

Add your answer

Q2. What is oops concept?

Add your answer

Skills evaluated in this interview

Consultant Interview Questions & Answers

arun jaya

posted on 7 Feb 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Technical

(1 Question)

Q1. Javascript,html,css

Add your answer

Consultant Interview Questions & Answers

Anonymous

posted on 18 Apr 2023

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - Resume Shortlist

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

Round 2 - Technical

(2 Questions)

Q1. Why are you looking for a change ?

Add your answer

Q2. What are your expectations

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Do well

Are these interview questions helpful?

Consultant Interview Questions & Answers

Anonymous

posted on 18 Nov 2022

Round 1 - Resume Shortlist

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

Round 2 - One-on-one

(2 Questions)

Q1. What is Volte Call flow ?

Ans.

Volte Call flow is the sequence of events that occur during a Voice over LTE call.

Volte call is initiated by the user's device sending a SIP invite to the network
The network responds with a SIP 180 ringing message to the user's device
Once the call is answered, the network sends a SIP 200 OK message to the user's device
Media is then established between the two devices using RTP protocol
The call is terminated by either p...

Answered by AI

Add your answer

Q2. What is IMS architecture ?

Ans.

IMS architecture refers to the design and structure of IBM's Information Management System software.

IMS is a hierarchical database management system.
It is used for transaction processing and data management.
IMS architecture includes components such as IMS DB, IMS DC, and IMS TM.
IMS DB is responsible for managing the database, while IMS DC handles online transaction processing.
IMS TM is used for managing transactions ac...

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your resume and Data Call flow. Be confidant on what you have done in your previous job.

Skills evaluated in this interview

Consultant Interview Questions & Answers

Anonymous

posted on 3 Jun 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Walk-in and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Aptitude Test

General aptitude test with logical thinking and GK

Round 2 - Group Discussion

General economics and finance

Round 3 - One-on-one

(2 Questions)

Q1. Easy good to go

Add your answer

Q2. All about personal

Add your answer

Consultant Interview Questions & Answers

Anonymous

posted on 6 May 2022

I applied via LinkedIn and was interviewed before May 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist

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

Round 2 - Technical

(1 Question)

Q1. Questions were based on PL/sql concepts

Add your answer

Round 3 - Technical

(1 Question)

Q1. Most of the concept related to Oracle Procedural Sql

Add your answer

Round 4 - Technical

(1 Question)

Q1. Most of the questions on oracle procedural sql

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure all the basic concepts are clear and focus on query writing

Oracle Interview FAQs

How many rounds are there in Oracle Consultant interview?

Oracle interview process usually has 2 rounds. The most common rounds in the Oracle interview process are Technical, One-on-one Round and Resume Shortlist.

How to prepare for Oracle Consultant 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 Oracle, Finance, Accounting, Consulting and Agile Coaching.

What are the top questions asked in Oracle Consultant interview?

Some of the top questions asked at the Oracle Consultant interview -

What is Volte Call flo...read more
What is IMS architectur...read more
what is oops conce...read more

Tell us how to improve this page.

Oracle Interviews By Designations

Interview Questions for Popular Designations

4.3/5

based on 9 interview experiences

Difficulty level

Moderate 100%

Duration

Less than 2 weeks 50%

6-8 weeks 50%

Automatic Data Processing (ADP) Consultant Interview Questions

4.0

• 7 Interviews

Microsoft Corporation Consultant Interview Questions

3.9

• 6 Interviews

SAP Consultant Interview Questions

4.2

• 3 Interviews

Adobe Consultant Interview Questions

3.9

• 2 Interviews

Salesforce Consultant Interview Questions

4.0

• 2 Interviews

VMware Software Consultant Interview Questions

4.4

• 2 Interviews

SPRINKLR Consultant Interview Questions

3.0

• 2 Interviews

OpenText Technologies Consultant Interview Questions

3.6

• 1 Interview

View all

Oracle Consultant Salary

based on 400 salaries

₹8 L/yr - ₹32.1 L/yr

33% more than the average Consultant Salary in India

View more details

Consultant Jobs at Oracle

Principal NSAW Consultant- Night Shift

Hyderabad / Secunderabad

8-10 Yrs

₹ 10-27 LPA

Principal NSAR Consultant- Night Shift

Hyderabad / Secunderabad

3-8 Yrs

₹ 5.5-21 LPA

Explore more jobs

Oracle Salaries in India

Senior Software Engineer 2.7k salaries	₹10.8 L/yr - ₹42 L/yr
Principal Consultant 2.2k salaries	₹10.9 L/yr - ₹38.2 L/yr
Senior Consultant 2.2k salaries	₹9.2 L/yr - ₹25 L/yr
Senior Member of Technical Staff 1.9k salaries	₹13.5 L/yr - ₹47 L/yr
Software Developer 1.5k salaries	₹8.4 L/yr - ₹31.6 L/yr