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

Clear (1)

Oracle Product Development Engineer Interview Questions and Answers

Updated 12 Oct 2023

Oracle Product Development Engineer Interview Experiences

1 interview found

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

I applied via Campus Placement and was interviewed in Sep 2023. 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 Resume tips
Round 2 - Coding Test 

3 codes were asked based on data structures and python API fetching. 13 aptitude MCQs were asked aswell

Round 3 - Technical 

(1 Question)

  • Q1. Basics of Oops,OS concepts,few data structure questions and few questions from the resume
Round 4 - HR 

(1 Question)

  • Q1. Introduction,tell me about yourself,tell me about your family and general behavioural questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, thorough with the basics and don't deep dive into DSA. Moderate level coders are preferred with a decent cgpa. Communication skills are checked aswell

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I was interviewed before Jun 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 180 minutes
Round difficulty - Easy

It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy

  • Q1. 

    Find the Duplicate Number Problem Statement

    Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...

  • Ans. 

    Find the duplicate number in an array of integers from 0 to (N-2).

    • Iterate through the array and keep track of the frequency of each number using a hashmap.

    • Return the number with a frequency greater than 1 as the duplicate number.

    • Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.

  • Answered by AI
  • Q2. 

    Reverse String Operations Problem Statement

    You are provided with a string S and an array of integers A of size M. Your task is to perform M operations on the string as specified by the indices in array A...

  • Ans. 

    Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.

    • Iterate through the array of indices and reverse the substrings accordingly

    • Ensure the range specified by each index is non-empty

    • Return the final string after all operations are completed

  • Answered by AI
Round 2 - Video Call 

Round duration - 60 Minutes
Round difficulty - Easy

It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.

Interview Preparation Tips

Eligibility criterianaAccenture interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes

Application resume tips for other job seekers

Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

6 Questions

  • Q1. What is fan trap? How to solve it? Give one example.
  • Ans. 

    Fan trap is a situation in which a query involving multiple tables results in a Cartesian product.

    • Fan trap occurs when a table is connected to multiple tables in a one-to-many relationship.

    • It can be solved by creating a bridge table or by using aggregate functions.

    • For example, if a customer table is connected to an orders table and a products table, a fan trap can occur when trying to retrieve information about custome...

  • Answered by AI
  • Q2. Two tables are joined. But joined type are not mentioned, then how much records will retrieve using select statement.
  • Q3. How to use dynamic break in report?
  • Ans. 

    Dynamic break in report allows for automatic page breaks based on data.

    • Define a break field in the report design

    • Set the break field to trigger a page break when its value changes

    • Use dynamic break to automatically adjust page breaks based on data

    • Example: A report on sales by region can use dynamic break to create a new page for each region

  • Answered by AI
  • Q4. Use of foreach function in report.
  • Ans. 

    Foreach function is used to iterate through an array of strings in a report.

    • Foreach function is used to loop through each element in an array of strings.

    • It can be used to display each element in a report.

    • Example: foreach(string item in stringArray){ Console.WriteLine(item); }

  • Answered by AI
  • Q5. What is Aggregate awareness? When we use it? Syntax of it.
  • Ans. 

    Aggregate awareness is a feature in Business Objects that allows reports to be optimized for performance by using aggregate tables.

    • Aggregate awareness is used when creating reports in Business Objects

    • It allows the report to use aggregate tables instead of detailed tables for improved performance

    • Syntax: AGGR_AWARE(, ,

      )

    • Example: AGGR_AWARE(Product, Sum(Sales), Sales_Fact_Table)

  • Answered by AI
  • Q6. @prompt function syntax and it's use.
  • Ans. 

    The @prompt function syntax is used to display a prompt message to the user and receive input.

    • The syntax is @prompt('message', 'default value')

    • The message is the prompt message to be displayed to the user

    • The default value is optional and will be displayed in the input field

    • The function returns the value entered by the user

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - they ask question on basics and concepts more, rest interview is easy.

I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic coding questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident , easy to crack

Interview Questionnaire 

1 Question

  • Q1. Mostly related to the technology I applied for. Some coding related questions. Questions related to our expertise to test us.

I applied via Company Website and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. String manipulation , collections, framework understanding

Interview Preparation Tips

Interview preparation tips for other job seekers - For QA Automation - Basics of OOPS concept,collections,strings are enough

I applied via Company Website and was interviewed before Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basics of c, matrix multiplication, sql,he said to write group by query and swapping program without using third variable

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well with basics of the mentioned languages in the resume.

I applied via Campus Placement and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself?

Interview Preparation Tips

Interview preparation tips for other job seekers - Before going to the interview the most important things to be done which works like miracles..
1. Sit in the meditative state for 2-5 mins just before the interview.
2.Think about all the blessings and all that you have and thank for having that.
3. Go with the mind set of being ethical and say to yourself that you are going to crack this interview no matter what (Easy,Medium or difficult)

Thank you
I would be happy if many people can take advantage of these advices.
Contribute & help others!
anonymous
You can choose to be anonymous

Oracle Interview FAQs

How many rounds are there in Oracle Product Development Engineer interview?
Oracle interview process usually has 4 rounds. The most common rounds in the Oracle interview process are Resume Shortlist, Coding Test and Technical.

Recently Viewed

INTERVIEWS

Jubilant Agri and Consumer Products

No Interviews

INTERVIEWS

Gyansys Infotech

No Interviews

INTERVIEWS

Fidelity Investments

No Interviews

INTERVIEWS

EdgeVerve Systems

No Interviews

INTERVIEWS

Tejas Networks

No Interviews

INTERVIEWS

Navin Fluorine International

No Interviews

INTERVIEWS

India Glycols

No Interviews

INTERVIEWS

Berger Paints

No Interviews

INTERVIEWS

Asian Paints

No Interviews

INTERVIEWS

Next Education India

No Interviews

Tell us how to improve this page.

Oracle Product Development Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
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
 • 871 Interviews
Amdocs Interview Questions
3.7
 • 532 Interviews
Zoho Interview Questions
4.3
 • 516 Interviews
Cisco Interview Questions
4.1
 • 397 Interviews
View all
Oracle Product Development Engineer Salary
based on 7 salaries
Lock Unlock
₹7.5 L/yr - ₹26.1 L/yr
94% more than the average Product Development Engineer Salary in India
View more details
Senior Software Engineer
2.3k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Senior Consultant
2.1k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Principal Consultant
2k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Senior Application Engineer
1.4k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.7
Compare

Salesforce

4.0
Compare

IBM

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent