Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Oracle Consultant Interview Questions and Answers for Experienced

Updated 28 Oct 2024

Oracle Consultant Interview Experiences for Experienced

4 interviews found

Consultant Interview Questions & Answers

user image richa srivastav

posted on 13 Jun 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected 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.
  • Q2. Give an example of a business rule from your project.

Consultant Interview Questions & Answers

user image Anonymous

posted on 6 Jul 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. HCM basics, SQL, Tables
Round 2 - Technical 

(1 Question)

  • Q1. Projects worked on

Consultant Interview Questions Asked at Other Companies for Experienced

asked in Deloitte
Q1. How would you pass an entry for travel expenses incurred and paid ... read more
Q2. If a policy is billed monthly and is an annual policy and due to ... read more
asked in Infosys
Q3. How Data Flow in SCOM monitoring Tool? DB name for SCOM and DB qu ... read more
asked in Deloitte
Q4. What is the journal entry for prepaid expenses and how do you tre ... read more
asked in Deloitte
Q5. Scenario : 2 Talend jobs related to each other. If one fails some ... read more

Consultant Interview Questions & Answers

user image Anonymous

posted on 18 Apr 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(2 Questions)

  • Q1. Why are you looking for a change ?
  • Ans. 

    Looking for new challenges and opportunities to grow professionally.

    • Seeking new challenges and opportunities for professional growth

    • Want to expand my skillset and knowledge

    • Interested in working with different clients and industries

    • Seeking a more dynamic and stimulating work environment

  • Answered by AI
  • Q2. What are your expectations
  • Ans. 

    I expect a challenging and dynamic work environment where I can utilize my skills and expertise to provide valuable consulting services.

    • Opportunity to work with diverse clients and industries

    • Collaborative and supportive team environment

    • Continuous learning and professional development

    • Clear expectations and goals

    • Opportunity for growth and advancement

    • Competitive compensation and benefits

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do well

Consultant Interview Questions & Answers

user image 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
Round 3 - Technical 

(1 Question)

  • Q1. Most of the concept related to Oracle Procedural Sql
Round 4 - Technical 

(1 Question)

  • Q1. Most of the questions on oracle procedural sql

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 questions for designations

 IT Consultant

 (4)

 Senior Consultant

 (19)

 Associate Consultant

 (17)

 Staff Consultant

 (11)

 Principal Consultant

 (10)

 Technical Consultant

 (2)

 Functional Consultant

 (2)

 Devops Consultant

 (1)

Consultant Jobs at Oracle

View all

Interview questions from similar companies

Consultant Interview Questions & Answers

Adobe user image harish sridharan

posted on 16 Mar 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Focus on all basic aptitude concepts

Round 2 - Technical 

(1 Question)

  • Q1. Stack parenthesis
Round 3 - HR 

(1 Question)

  • Q1. Have you attended hackerrank
  • Ans. 

    Yes, I have attended Hackerrank for coding challenges and practice.

    • I have completed coding challenges on Hackerrank to practice my skills

    • I have participated in coding competitions on Hackerrank

    • I have used Hackerrank to prepare for technical interviews

  • Answered by AI

I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me something about yourselyoir roles and responsibilities in the last company Current job applied job description Why u left your last company Movie you recently watched About your last company Y...

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview went for 15-20 mins
There rounds of interview (hr, v&a, ops). It depends upon process to process. In some process they might not go for v&a
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Basic coding questions

Round 2 - Coding Test 

Advance Coding Questions related to SpringBoot, Microservice design patterns

Round 3 - HR 

(1 Question)

  • Q1. Basic HR Questions and salary discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Implement custom reduce function in js
  • Ans. 

    Custom reduce function in JavaScript

    • Create a function that takes an array, a callback function, and an initial value as parameters

    • Iterate through the array and apply the callback function to each element, updating the accumulator

    • Return the final accumulator value

  • Answered by AI
  • Q2. Box sizing in css
  • Ans. 

    Box sizing in CSS determines how the total width and height of an element is calculated.

    • Box-sizing property can have values of content-box (default) or border-box

    • content-box includes only the content, border, and padding in the width and height calculations

    • border-box includes the content, padding, and border in the width and height calculations

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Automatic Data Processing (ADP) Consultant interview:
  • Javascript
  • Angular

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Design book my show
  • Q2. Implement Binary First Search
  • Ans. 

    Binary First Search is a search algorithm that explores the nodes in a binary tree in a level-order traversal.

    • Start at the root node and add it to a queue.

    • While the queue is not empty, dequeue a node and visit it. Then enqueue its children.

    • Repeat until all nodes have been visited.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. .net full stack
Round 2 - HR 

(1 Question)

  • Q1. Why do you want to change

Oracle Interview FAQs

How many rounds are there in Oracle Consultant interview for experienced candidates?
Oracle interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the Oracle interview process for experienced candidates are Technical, Resume Shortlist and One-on-one Round.
How to prepare for Oracle Consultant interview for experienced candidates?
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, Accounting, Consulting, Finance and PLSQL.
What are the top questions asked in Oracle Consultant interview for experienced candidates?

Some of the top questions asked at the Oracle Consultant interview for experienced candidates -

  1. Most of the concept related to Oracle Procedural ...read more
  2. What is Volte Call flo...read more
  3. Most of the questions on oracle procedural ...read more

Tell us how to improve this page.

Oracle Consultant Interview Process for Experienced

based on 3 interviews

1 Interview rounds

  • Technical Round
View more
Oracle Consultant Salary
based on 356 salaries
₹6.9 L/yr - ₹23 L/yr
5% more than the average Consultant Salary in India
View more details

Oracle Consultant Reviews and Ratings

based on 38 reviews

4.2/5

Rating in categories

3.8

Skill development

4.1

Work-life balance

3.1

Salary

4.1

Job security

3.9

Company culture

2.8

Promotions

3.6

Work satisfaction

Explore 38 Reviews and Ratings
SCM Techno Functional - ASCP Consultant

Hyderabad / Secunderabad,

Bangalore / Bengaluru

5-10 Yrs

₹ 5.6-25 LPA

Principal Siebel Product Modeling Consultant

Kolkata,

Bangalore / Bengaluru

6-11 Yrs

₹ 17-32 LPA

Principal Siebel Product Modeling Consultant

Hyderabad / Secunderabad,

Pune

+1

6-11 Yrs

₹ 17-32 LPA

Explore more jobs
Senior Software Engineer
2.5k salaries
unlock blur

₹10.3 L/yr - ₹40 L/yr

Principal Consultant
2.1k salaries
unlock blur

₹10.9 L/yr - ₹37 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹9.1 L/yr - ₹25 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹12.1 L/yr - ₹45 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹9.7 L/yr - ₹30 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.8
Compare

Salesforce

4.0
Compare

IBM

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview