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 5.1k Reviews

Filter interviews by

Oracle Senior Plsql Developer Interview Questions, Process, and Tips

Updated 8 Feb 2024

Oracle Senior Plsql Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain how an Select statement is parsed in Oracle database
  • Ans. 

    The parsing of a SELECT statement in Oracle database involves several steps.

    • The statement is first checked for syntax errors.

    • The query is then parsed to identify the objects involved and their relationships.

    • The optimizer determines the most efficient execution plan.

    • The plan is executed and the result set is returned.

  • Answered by AI
  • Q2. Explain how an insert/update is parsed in Oracle database
  • Ans. 

    An insert/update statement in Oracle database is parsed by the SQL parser to check syntax and semantics.

    • The SQL parser first checks the syntax of the insert/update statement to ensure it follows the rules of the SQL language.

    • Next, the parser checks the semantics of the statement, which involves verifying the existence and accessibility of the tables and columns referenced in the statement.

    • During parsing, the parser als...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. How do access elements in XML/JSON data
  • Ans. 

    To access elements in XML/JSON data, use appropriate methods like XPath for XML and dot notation for JSON.

    • For XML data, use XPath expressions to navigate and extract specific elements or attributes.

    • For JSON data, use dot notation to access nested objects or arrays.

    • In PL/SQL, you can use XMLTable or JSON_TABLE functions to extract data from XML or JSON respectively.

  • Answered by AI
  • Q2. Explain different pragma objects
  • Ans. 

    Pragma objects in PL/SQL provide compiler directives for controlling program behavior.

    • Pragma AUTONOMOUS_TRANSACTION: Allows a subprogram to execute SQL statements independently of the calling program.

    • Pragma EXCEPTION_INIT: Associates an exception name with an Oracle error number.

    • Pragma INLINE: Suggests the compiler to inline the code of a subprogram at the call site.

    • Pragma RESTRICT_REFERENCES: Specifies the purity leve...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Where do you see yourself in 5 years from now

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How can a Spring Boot project be created to develop an API that returns specified data?
  • Q2. What is the code to print a right-angled triangle of numbers based on a given input number?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Can you explain about Platform Events?
  • Ans. 

    Platform Events are a feature in Salesforce that allow developers to deliver secure, scalable, and customizable event notifications.

    • Platform Events are based on the publish-subscribe model, where publishers send events and subscribers receive them.

    • They are used to communicate changes in Salesforce data or custom events within an organization.

    • Developers can define custom event objects and trigger events using Apex or de...

  • Answered by AI
  • Q2. Tell me about Asynchronous Apex? Difference between Batch Apex and Queueable Apex
  • Ans. 

    Asynchronous Apex allows you to run processes in the background, without user interaction. Batch Apex and Queueable Apex are two types of Asynchronous Apex.

    • Asynchronous Apex allows you to process large amounts of data asynchronously, without impacting the user interface.

    • Batch Apex is used to process large data sets that can be divided into smaller batches for processing.

    • Queueable Apex allows you to submit jobs for asyn...

  • Answered by AI
  • Q3. Explain Future method? and why we need (Callout= true) along with that annotation?
  • Ans. 

    Future method is used to run code asynchronously. Callout=true is needed to make HTTP callouts from future methods.

    • Future methods are used to run code asynchronously in Salesforce.

    • They are annotated with @future annotation.

    • Callout=true is needed to make HTTP callouts from future methods.

    • Without Callout=true, making HTTP callouts from future methods is not allowed.

  • Answered by AI
  • Q4. Data Security in Salesforce and types in it.
  • Ans. 

    Data security in Salesforce involves various types of security measures to protect sensitive information.

    • Salesforce provides various security features such as user authentication, data encryption, and access controls.

    • Types of data security in Salesforce include object-level security, field-level security, and record-level security.

    • Salesforce also offers tools like Salesforce Shield for enhanced data security and compli...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Salary expectations
Round 2 - One-on-one 

(1 Question)

  • Q1. Introduction self
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It went well. Easy questions were asked

Round 2 - Coding Test 

We have to first explain how we are planning to solve the problem and can start coding

Round 3 - HR 

(2 Questions)

  • Q1. Multi threading
  • Q2. Algorithms in data structures
  • Ans. 

    Algorithms in data structures are essential for efficient data manipulation and retrieval.

    • Algorithms in data structures help in organizing and managing data effectively.

    • Examples include sorting algorithms like quicksort and searching algorithms like binary search.

    • Understanding algorithms in data structures is crucial for optimizing performance in software development.

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
6-8 weeks
Result
Not Selected

I applied via Company Website

Round 1 - Aptitude Test 

Very difficult aptitude questions

Round 2 - Coding Test 

Resources coding round

Round 3 - Technical 

(2 Questions)

  • Q1. Very difficult questions
  • Q2. Coding program is very difficult
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Questions on react , majorly focus on basics

Round 2 - Technical 

(1 Question)

  • Q1. Question on coding react
Round 3 - Technical 

(1 Question)

  • Q1. Machine coding round
Round 4 - HR 

(1 Question)

  • Q1. Cultural fit questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2023. There were 3 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 - Coding Test 

One to one interview along with coding round.
Basic questions for python based on list touple dictionary.
Numpy, Pandas, CSV and operation.
SQL queries basic like join query
Having query.

Round 3 - One-on-one 

(5 Questions)

  • Q1. Managerial round Use case base
  • Q2. Completely based on your work experience discussion along with some basic logical use case.
  • Q3. This including salary expectancy questions
  • Q4. Previous projects questions
  • Q5. Core logic of previous work
  • Ans. 

    The core logic of my previous work involved developing a web application using Python and Django framework.

    • Developed a web application using Python and Django framework

    • Implemented various features and functionalities based on client requirements

    • Handled database operations and data manipulation using Django ORM

    • Worked on front-end development using HTML, CSS, and JavaScript

    • Collaborated with a team of developers to ensure

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Dassault Systemes Python Developer interview:
  • Python
  • SQL
  • Use case based
Interview preparation tips for other job seekers - Stick to basics, Be as you are.
Quick answer not expected but give appropriate answer
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Embedded systems questions
Round 2 - HR 

(1 Question)

  • Q1. Salary expectations
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Worst company ever, where the interviewer himself does not know what are the requirements for the position they are hiring for. The interviewer interviewed me for .Net architect, and suddenly I found mysel...
  • Q2. You are just a resource waiting to be deployed on project. All they want to know is that why you are not deployed even if you haven't faced any client interview in the field of your expertise.

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont' join this bullshit company. There are plenty of good companies outside.

Oracle Interview FAQs

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

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

  1. Explain how an Select statement is parsed in Oracle datab...read more
  2. Explain how an insert/update is parsed in Oracle datab...read more
  3. How do access elements in XML/JSON d...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Oracle interview
Referral
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
 • 10.3k Interviews
Accenture Interview Questions
3.9
 • 8k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
IBM Interview Questions
4.1
 • 2.4k Interviews
Google Interview Questions
4.4
 • 846 Interviews
Cisco Interview Questions
4.2
 • 395 Interviews
SAP Interview Questions
4.2
 • 303 Interviews
Salesforce Interview Questions
4.1
 • 267 Interviews
Adobe Interview Questions
4.0
 • 248 Interviews
View all
Oracle Senior Plsql Developer Salary
based on 11 salaries
₹15 L/yr - ₹21.5 L/yr
74% more than the average Senior Plsql Developer Salary in India
View more details

Oracle Senior Plsql Developer Reviews and Ratings

based on 2 reviews

3.8/5

Rating in categories

3.4

Skill development

3.8

Work-Life balance

3.0

Salary & Benefits

3.4

Job Security

3.8

Company culture

3.0

Promotions/Appraisal

3.4

Work Satisfaction

Explore 2 Reviews and Ratings
Senior Software Engineer
2.3k salaries
unlock blur

₹10 L/yr - ₹40 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹9 L/yr - ₹24.4 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

₹12 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.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