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 Interview Questions, Process, and Tips for Experienced

Updated 19 Feb 2025

Top Oracle Interview Questions and Answers for Experienced

View all 156 questions

Oracle Interview Experiences for Experienced

Popular Designations

315 interviews found

Interview Questionnaire 

3 Questions

  • Q1. About past experience and how could you benefit present company from past experience ?
  • Q2. What do you know about Oracle? Why do you want to join us ?
  • Q3. Achievements, difficulties, feedbacks from past organization?

Technical Analyst Interview Questions asked at other Companies

Q1. Write a program to get a employee list whose salary is greater than 50k and grade is above from A, Use Java 8 stream to get the list
View answer (2)

I applied via Naukri.com and was interviewed in Jul 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Deep Technical
  • Q2. Scenario based

Interview Preparation Tips

Interview preparation tips for other job seekers - - Strong in the technical area
- Ready to solve the scenario-based questions
- Strong in OCI fundamentals

Senior Cloud Engineer Interview Questions asked at other Companies

Q1. What all things we need to consider while creating a VM
View answer (2)

Assistant Financial Controller and Reporting Interview Questions & Answers

user image Anonymous

posted on 17 Nov 2021

I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

6 Questions

  • Q1. IFRS-16 Accounting - Leases
  • Q2. Differences between Previous and Current Revenue Recognition
  • Ans. 

    The current revenue recognition standards have changed compared to the previous standards.

    • Previous standards recognized revenue when it was realized or realizable and earned, while current standards focus on the transfer of control of goods or services.

    • Under previous standards, revenue could be recognized over time using percentage-of-completion method, while current standards require the use of input or output methods...

  • Answered by AI
  • Q3. What is Deferred Revenue and Accrued Revenue
  • Ans. 

    Deferred revenue is income received in advance for goods or services that will be delivered in the future. Accrued revenue is income earned but not yet received.

    • Deferred revenue is a liability on the balance sheet.

    • It represents revenue that has been received but not yet earned.

    • Examples of deferred revenue include prepaid subscriptions, advance payments for services, or gift cards.

    • Accrued revenue is an asset on the bala...

  • Answered by AI
  • Q4. What is Deferred Tax Liabilities and can it shown under Non Current Assets
  • Ans. 

    Deferred Tax Liabilities are future tax obligations that arise due to temporary differences between accounting and tax rules.

    • Deferred Tax Liabilities are recorded on the balance sheet as a non-current liability.

    • They represent taxes that a company will have to pay in the future when the temporary differences reverse.

    • Temporary differences can arise from items such as depreciation, inventory valuation, and revenue recogni...

  • Answered by AI
  • Q5. Fair Value Accounting of Investments
  • Ans. 

    Fair value accounting is a method used to measure and report the value of investments based on their current market prices.

    • Fair value accounting is used to provide more accurate and relevant information about the value of investments.

    • It involves measuring the value of investments based on their current market prices.

    • This method is used for both financial assets and liabilities.

    • Fair value accounting helps in assessing t...

  • Answered by AI
  • Q6. What is Excepted Credit Loss - What are the 2 methods that the Standard prescribes
  • Ans. 

    Expected Credit Loss (ECL) is a measure of the potential loss that a financial institution may incur due to default or impairment of its credit exposures.

    • ECL is a key concept in financial accounting and reporting.

    • It is used to estimate the amount of credit losses that a financial institution is likely to experience in the future.

    • The two methods prescribed by the Standard are the General Approach and the Simplified Appr...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best. ......................................................

Software Developer Interview Questions & Answers

user image Heena Rahangdale

posted on 13 Nov 2021

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

Interview Questionnaire 

1 Question

  • Q1. Java concepts in details,Java coding questions, Selenium web driver ,Few of Manual testing concepts, Testscenario writing, Test Frameworks

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare coding in any language well.solve leetcode/hackerrank.

Top Oracle Software Developer Interview Questions and Answers

Q1. Triplets with Given Sum Problem Given an array or list ARR consisting of N integers, your task is to identify all distinct triplets within the array that sum up to a specified number K. Explanation: A triplet is a set {ARR[i], ARR[j], ARR[k... read more
Add answer

Software Developer Interview Questions asked at other Companies

Q1. Maximum Subarray Sum Problem Statement Given an array of integers, determine the maximum possible sum of any contiguous subarray within the array. Example: Input: array = [34, -50, 42, 14, -5, 86] Output: 137 Explanation: The maximum sum is... read more
View answer (41)

Oracle interview questions for popular designations

 Software Developer

 (67)

 Software Engineer

 (38)

 Application Developer

 (37)

 Senior Software Engineer

 (32)

 Member Technical Staff

 (24)

 Applications Engineer

 (23)

 Senior Consultant

 (18)

 Associate Consultant

 (17)

Interview Questionnaire 

1 Question

  • Q1. 4 rounds of interview. First one is telephonic with basic technical questions, for initial screening. Then the second round will be completely technical. In-depth skill assessment. Then the managerial roun...

Quality Assurance Engineer Interview Questions asked at other Companies

Q1. Coding with any language 1. Count the no of occurrence of each character in string( ignore case)(ignore wild card characters)
View answer (1)

Get interview-ready with Top Oracle Interview Questions

I applied via Recruitment Consulltant and was interviewed before Mar 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Write an SQL query to copy the structure of a table to another table, but without copying data
  • Ans. 

    SQL query to copy table structure without data

    • Use CREATE TABLE AS SELECT statement

    • Include WHERE clause to avoid copying data

    • Example: CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=0

  • Answered by AI
  • Q2. Print first non-repeating character in the given string.
  • Ans. 

    Print the first non-repeating character in a given string.

    • Create a hash table to store the frequency of each character in the string.

    • Iterate through the string and update the frequency of each character in the hash table.

    • Iterate through the string again and return the first character with a frequency of 1.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You will never feel 100% ready, just do it when an opportunity comes.

Skills evaluated in this interview

Application Developer 2 Interview Questions asked at other Companies

Q1. Design the DB, how to handle the user requests during peak hours in University.
View answer (1)

Jobs at Oracle

View all

Senior Lead Consultant Interview Questions & Answers

user image Sidhartha wadhwa

posted on 31 Oct 2021

I applied via Recruitment Consultant and was interviewed in May 2021. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. You should have full knowledge of ur profile

Interview Preparation Tips

Interview preparation tips for other job seekers - Be positive with each answer

Senior Lead Consultant Interview Questions asked at other Companies

Q1. What is Robotics teaching? What is the STEM stand for?
View answer (1)

fresher interview

user image Ali Aziz_Muzzi_QualityEducation

posted on 21 Mar 2022

I applied via Approached by Company and was interviewed before Nov 2021. There were 2 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 - One-on-one 

(2 Questions)

  • Q1. Tell me about hiring strategy for for hiring 3 manger 6 lead and 40 team members in one month
  • Q2. Assessment wasgiven to mee for tech hiring plan presentation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very clear and take pause think through your experience and then answer do not jump on direct to answer

Talent Advisor Interview Questions asked at other Companies

Q1. Sourcing methods and experience
View answer (1)

Deal Manager Interview Questions & Answers

user image Anonymous

posted on 29 Nov 2021

I applied via Recruitment Consultant and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About my job skills.. knowledge about contracts, NDA, dealing with various parties.

Interview Preparation Tips

Interview preparation tips for other job seekers - have a positive mindset and all the best:)

Oracle Interview FAQs

How many rounds are there in Oracle 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, One-on-one Round and Resume Shortlist.
How to prepare for Oracle 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 Java, Oracle, Javascript, Python and SQL.
What are the top questions asked in Oracle interview for experienced candidates?

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

  1. 1. Write a program to remove duplicate elements from String and mention the cou...read more
  2. 4. What is marker interface? Example of marker interface. Why it is us...read more
  3. 2. Write a program to capitalise all the first letter of a word in a senten...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.

Oracle Interview Process for Experienced

based on 157 interviews

Interview experience

4.1
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Amazon Interview Questions
4.1
 • 5.1k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
Google Interview Questions
4.4
 • 870 Interviews
Cisco Interview Questions
4.1
 • 397 Interviews
SAP Interview Questions
4.2
 • 308 Interviews
Salesforce Interview Questions
4.0
 • 272 Interviews
Adobe Interview Questions
3.9
 • 251 Interviews
View all

Oracle Reviews and Ratings

based on 5.2k reviews

3.7/5

Rating in categories

3.5

Skill development

4.0

Work-life balance

3.1

Salary

3.9

Job security

3.7

Company culture

2.7

Promotions

3.4

Work satisfaction

Explore 5.2k Reviews and Ratings
Java and Cloud Software Developer

Bangalore / Bengaluru

3-8 Yrs

₹ 15-30 LPA

UI Software Developer

Bangalore / Bengaluru

3-8 Yrs

₹ 15-30 LPA

Oracle Cloud Operation Engineer (rotation)

Bangalore / Bengaluru

6-10 Yrs

₹ 15-30 LPA

Explore more jobs
Senior Software Engineer
2.3k salaries
unlock blur

₹10.2 L/yr - ₹40 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹9 L/yr - ₹25 L/yr

Principal Consultant
2k salaries
unlock blur

₹10.9 L/yr - ₹36 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹13.5 L/yr - ₹45 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹8.5 L/yr - ₹34 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