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
3.7

based on 5k Reviews

Filter interviews by

Oracle Plsql Developer Interview Questions and Answers

Updated 10 Jul 2024

2 interviews found

Sort by: Popular

Plsql Developer Interview Questions

user image Murari Srimaan

posted on 10 Jul 2024

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. SQL based questions
  • Q2. PLSQL based questions

Plsql Developer Interview Questions

user image Anonymous

posted on 8 Mar 2024

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Feb 2024.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Questioned about each and every objects in database. procedures, functions with examples write Fibonacci series using plsql block joins, subqueries written a sq...read more

Plsql Developer Jobs at Oracle

View all

Interview questions from similar companies

Plsql Developer Interview Questions

Kiya.ai user image Anonymous

posted on 20 Mar 2024

Interview experience
1
 Bad
Difficulty level
 Easy
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Referral and was interviewed in Sep 2023.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Useless interview

Interview Preparation Tips

Interview preparation tips for other job seekers - I'll not only talk about interview process but also about company environment. First of all it's not an MNC company it's like typical khokha(Mumbai small shop) kind of company. You need a source to get entry in this company or your knowledge should be on that level. They have huge team of hr but they all are useless. For reference I'm mentioning name riya fernandes(such a arrogant and useless hr). If u ask anything related to company policy or process related questions she won't be able to answer it and will ask you to connect with some senior hr. If she has an issue with u then she will disclose your personal details with everyone like your salary package. She will force you till you decide to leave because in this company hr think they are god. She is just a garbage. Manager will treat you like their slave. No working culture. They will cut some part from your salary in the name of variable pay but won't give ur money untill you decide to leave. Full of politics and drama.most of the people waste their time in gossiping and digging a grave for others. I've mentioned name cause by this people can confirm that I was an employee of this company. People will leave this company couse you will not learn anything here. Most of the people are working in this company since 25 years or 15 years and now people can understand why so much politics. Better to find a good environment because here you'll learn nothing.
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Campus Placement and was interviewed in Aug 2024.

2 Interview Rounds

1

Aptitude Test Round

Aptitude round of 1hr followed by communication round 30mins

2

Technical Round (2 Questions)

  • Q1. Tell me about yourself
  • Q2. Tell me about the projects
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Recruitment Consulltant and was interviewed in May 2024.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Median of a stream
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I was interviewed before Oct 2023.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Longest Valid Parentheses
  • Q2. Find the maximum number in the subarrays of length k.
2

Technical Round (1 Question)

  • Q1. Spiral Matrix Question

6 Interview Rounds

1

Aptitude Test Round

A total time of 1 hour 30 minutes was given for this round, and it was held on the HackerEarth platform.

20 Aptitude questions- logical questions, questions on the diagram, time and train, direction, efficient statement, Venn diagram, few examples of the type of questions:

1. If 2 workers can paint 3 rooms in 4 hours, how many rooms can 1 worker paint in 5 hours

2. If there are 21 blue, 15 black and 17 red ball in a sack, how many minimum ball would you have to remove to ensure that you have removed at least 2 blue ball? (multiple questions of this type can be there)

3. The sum of the 5 numbers in AP is 80. The difference between each is 5. Smallest number?

4. A and B are standing in a row. A is 5th from the left, and B is 13th from the right. After they exchange their positions, A is 11th from left. How many people are in the row?

20 questions on CSE Fundamentals- Questions based on OS - Time Scheduling, Stacks, Find output and error in Java Code, Cpp code and C Code, DBMS, Time complexity, etc.

2 questions based on DSA, out of which you will have to attempt any 1.

For example, the Question was based on the array - in an abandoned city, you are given an array of gold coins, and you have to maximise the number of gold coins while moving in the city and traverse a minimum number of elements in the array.

2

Technical Round (9 Questions)

  • Q1. 1. ARRAYS, STRINGS AND SORTING: Bubble sort, Complexity of all sorting algorithms.
  • Q2. 2. Find the first non repeating character in a string
  • Q3. 3. Remove duplicates from an array
  • Q4. 4. An array and 2 variables x and y are given, print y sub arrays with x elements.
  • Q5. 5. Explain the function pointer.
  • Q6. 6. Explain copy constructor
  • Q7. 7. Deep copy / Shallow copy
  • Q8. 8. Characteristics of static function
  • Q9. 9. What are Abstract classes
3

Technical Round (4 Questions)

  • Q1. 1. Explain Trees and Binary Search Trees.
  • Q2. 2. Difference between Linked List and Tree (where what should be used).
  • Q3. 3. A real-life example of Tree.
  • Q4. 4. Some in-depth questions from standard topics like Linked List, trees, etc. will also be asked.
4

Real Life Situation Round (1 Question)

  • Q1. If a rival company tries to use your code against us what will you do?
5

Puzzles Interview Round (1 Question)

  • Q1. Given 9 ball all of which weigh the same except for one, what is the minimum of weighings necessary to find the ball weighs more (or less)?
6

HR Round (5 Questions)

  • Q1. 1. What are your goals for the next 1 year, your 5-year goals?
  • Q2. 2. What are the recent challenges you faced in life?
  • Q3. 3. What are your hobbies in life besides coding?
  • Q4. 4. Why do you want to join this company?
  • Q5. 5. What work does our company do?

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure your CSE Fundamentals are strong. DSA should be your Top priority and make sure you practice DSA questions. Make sure to revise all the standard questions of DSA for interviews. Round 1 is easy. The Technical round is mainly Project-Based on the projects you mentioned in your resume. For the DSA questions, try and focus on the approach and how it could be made better.

Web Developer Interview Questions

Busibud user image Ratankumar Nag

posted on 1 Jul 2022

I applied via Referral and was interviewed in Jun 2022.

2 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

Html css javascript python

Interview Preparation Tips

Interview preparation tips for other job seekers - Good developers in this web developer and programming skills html css javascript python

Plsql Developer Interview Questions

Kiya.ai user image Anonymous

posted on 20 Mar 2024

Interview experience
1
 Bad
Difficulty level
 Easy
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Referral and was interviewed in Sep 2023.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Useless interview

Interview Preparation Tips

Interview preparation tips for other job seekers - I'll not only talk about interview process but also about company environment. First of all it's not an MNC company it's like typical khokha(Mumbai small shop) kind of company. You need a source to get entry in this company or your knowledge should be on that level. They have huge team of hr but they all are useless. For reference I'm mentioning name riya fernandes(such a arrogant and useless hr). If u ask anything related to company policy or process related questions she won't be able to answer it and will ask you to connect with some senior hr. If she has an issue with u then she will disclose your personal details with everyone like your salary package. She will force you till you decide to leave because in this company hr think they are god. She is just a garbage. Manager will treat you like their slave. No working culture. They will cut some part from your salary in the name of variable pay but won't give ur money untill you decide to leave. Full of politics and drama.most of the people waste their time in gossiping and digging a grave for others. I've mentioned name cause by this people can confirm that I was an employee of this company. People will leave this company couse you will not learn anything here. Most of the people are working in this company since 25 years or 15 years and now people can understand why so much politics. Better to find a good environment because here you'll learn nothing.
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via LinkedIn and was interviewed in Feb 2024.

1 Interview Round

1

Coding Test Round

Zeta interview at codeblock. 3 dsa questions The level of difficulty was medium

Oracle Interview FAQs

How many rounds are there in Oracle Plsql Developer interview?
Oracle interview process usually has 1 rounds. The most common rounds in the Oracle interview process are Technical.
How to prepare for Oracle Plsql Developer 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 PLSQL, Java, Triggers, Oracle SQL and Oracle.
What are the top questions asked in Oracle Plsql Developer interview?

Some of the top questions asked at the Oracle Plsql Developer interview -

  1. questioned about each and every objects in database. procedures, functions with...read more
  2. PLSQL based questi...read more
  3. SQL based questi...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Oracle interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10k Interviews
Accenture Interview Questions
3.9
 • 7.8k Interviews
Amazon Interview Questions
4.1
 • 4.9k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
Google Interview Questions
4.4
 • 807 Interviews
Cisco Interview Questions
4.2
 • 383 Interviews
SAP Interview Questions
4.2
 • 295 Interviews
Salesforce Interview Questions
4.1
 • 260 Interviews
Adobe Interview Questions
4.0
 • 245 Interviews
View all
Oracle Plsql Developer Salary
based on 69 salaries
₹3.3 L/yr - ₹15 L/yr
38% more than the average Plsql Developer Salary in India
View more details

Oracle Plsql Developer Reviews and Ratings

based on 2 reviews

4.9/5

Rating in categories

4.9

Skill development

4.9

Work-Life balance

4.0

Salary & Benefits

4.9

Job Security

4.9

Company culture

4.6

Promotions/Appraisal

4.7

Work Satisfaction

Explore 2 Reviews and Ratings
PLSQL Developer

Pune,

Chennai

+1

5-8 Yrs

₹ 15-22.5 LPA

Java PLSQL Developer

Hyderabad / Secunderabad

1-6 Yrs

Not Disclosed

Java PLSQL Developer

Hyderabad / Secunderabad

3-8 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
2.4k salaries
unlock blur

₹11.8 L/yr - ₹40 L/yr

Senior Consultant
2.2k salaries
unlock blur

₹9.8 L/yr - ₹26.5 L/yr

Principal Consultant
2.1k salaries
unlock blur

₹14 L/yr - ₹36.6 L/yr

Senior Member of Technical Staff
1.9k salaries
unlock blur

₹12 L/yr - ₹44.3 L/yr

Software Developer
1.6k salaries
unlock blur

₹8.2 L/yr - ₹32.9 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

4.0
Compare

Salesforce

4.1
Compare

IBM

4.1
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview