Upload Button Icon Add office photos
Premium Employer

i

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

Deloitte Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Deloitte Senior Plsql Developer Interview Questions, Process, and Tips

Updated 29 Sep 2022

Deloitte Senior Plsql Developer Interview Experiences

1 interview found

I applied via LinkedIn and was interviewed in Aug 2022. 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 - Technical 

(4 Questions)

  • Q1. Did you ever work on query tuning and optimization? What do you see in explain plan?
  • Ans. 

    Yes, I have worked on query tuning and optimization. Explain plan helps in identifying the execution plan of a query.

    • I have experience in identifying and resolving performance issues in SQL queries.

    • I use explain plan to analyze the query execution plan and identify any bottlenecks.

    • I look for factors like full table scans, index usage, and join methods to optimize the query.

    • I also use tools like SQL Trace and TKPROF to ...

  • Answered by AI
  • Q2. How partitions is useful and when to create it
  • Ans. 

    Partitions are useful for managing large tables and improving query performance.

    • Partitions allow for data to be split into smaller, more manageable chunks

    • Queries can be run on specific partitions, improving performance

    • Partitions can be based on various criteria such as date, range, or hash

    • Example: Partitioning a sales table by date can improve query performance for recent sales data

    • Example: Partitioning a customer tabl...

  • Answered by AI
  • Q3. How to debug procedure which has nested procedure in it.
  • Ans. 

    Debugging a procedure with nested procedure.

    • Use DBMS_OUTPUT.PUT_LINE to print debug information

    • Use EXCEPTION block to catch and handle errors

    • Use SQL Developer Debugger to step through the code

    • Check the input and output parameters of the nested procedure

    • Use logging framework to log debug information

  • Answered by AI
  • Q4. How to fetch hierarchical data
  • Ans. 

    Hierarchical data can be fetched using recursive queries or hierarchical queries.

    • Recursive queries use a common table expression (CTE) to repeatedly join a table to itself.

    • Hierarchical queries use the CONNECT BY clause to specify the parent-child relationship.

    • Both methods require a column that identifies the parent of each row, such as an ID or parent ID column.

    • Example: SELECT * FROM employees WHERE manager_id = 123 CO...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand the architecture of database and the process how it works.
Experienced employees has to answer questions very logically

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I was interviewed in Jan 2025.

Round 1 - Group Discussion 

Programming questions related to Python and React.

Round 2 - Group Discussion 

Programmatical problem related to Python and React

Round 3 - HR 

(1 Question)

  • Q1. Salary Discussion
Round 4 - Aptitude Test 

Programming Problems related to react and python.

Round 5 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, Memory Management, Multiprocessing, multithreading, GIL, React Components
Round 6 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Round 7 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Round 8 - Technical 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy
Round 9 - One-on-one 

(1 Question)

  • Q1. Object Oriented Programming, GIL, Multi threading, multiprocessing, React Component, Shallow Copy, Deep Copy, Django ORM, Class Inheritance

Interview Preparation Tips

Interview preparation tips for other job seekers - In the name of the client Round, the internal team will contact you to conduct interview calls known as Preparation Call Round before the Client Round, aimed at creating a positive impression for the client. Typically, no additional rounds follow the HR round, but they conducted five more rounds while merely reiterating the aforementioned details, which led me to cancel my own job application.
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. When you want delete account accosiated with contact. The account should not get deleted.
  • Ans. 

    To delete an account associated with a contact without deleting the account itself.

    • Remove the contact's association with the account before deleting the contact.

    • Check for any other dependencies before deleting the contact.

    • Consider creating a custom field to track the association between the contact and account.

  • Answered by AI
  • Q2. Do have experience in flows, Explain the flows
  • Ans. 

    Flows are declarative automation tools in Salesforce used to automate business processes by collecting data and performing operations.

    • Flows are created using a visual designer in Salesforce.

    • They can automate complex business processes without writing code.

    • Flows can collect data from users, interact with Salesforce, and make decisions based on user input or data.

    • They can be triggered by various events like record change...

  • Answered by AI
Round 2 - Client Interview 

(2 Questions)

  • Q1. When rating is hot update description
  • Ans. 

    When a rating is hot, update the description accordingly.

    • Monitor user feedback and ratings regularly

    • Update the description based on the latest ratings and reviews

    • Consider adding specific details or addressing common concerns mentioned in the feedback

  • Answered by AI
  • Q2. Tell me about yourself
  • Ans. 

    I am a Salesforce Developer with 5 years of experience in designing and implementing custom solutions for clients.

    • 5 years of experience in Salesforce development

    • Strong expertise in designing and implementing custom solutions

    • Proficient in Apex, Visualforce, and Lightning components

    • Certified Salesforce Developer

    • Experience working with clients to understand their requirements and deliver solutions

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is trigger in salesforce
  • Ans. 

    A trigger in Salesforce is a piece of code that is executed before or after specific data manipulation events, such as insert, update, or delete.

    • Triggers are used to perform custom actions on records in Salesforce.

    • Triggers can be written in Apex programming language.

    • Triggers can be executed before or after specific events like insert, update, or delete.

    • Triggers are associated with a specific object in Salesforce.

    • Exampl...

  • Answered by AI
  • Q2. Type of flows in salesforce
  • Ans. 

    There are three types of flows in Salesforce: Autolaunched Flows, Screen Flows, and Scheduled Flows.

    • Autolaunched Flows are triggered by a process or Apex trigger and do not require user interaction.

    • Screen Flows guide users through a series of screens to collect and display information.

    • Scheduled Flows are triggered by a schedule and can automate repetitive tasks.

  • 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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Write a java program to sort an array
  • Ans. 

    Java program to sort an array of strings

    • Use Arrays.sort() method to sort the array of strings

    • Import java.util.Arrays package

    • Example: String[] arr = {"apple", "banana", "orange"}; Arrays.sort(arr);

  • Answered by AI
  • Q2. Collections in java and springboot
  • Ans. 

    Collections in Java and Spring Boot are used to store and manipulate groups of objects.

    • Collections in Java are used to store multiple objects in a single unit.

    • Spring Boot provides support for managing collections through various data structures like List, Set, Map, etc.

    • Collections in Java and Spring Boot help in organizing and manipulating data efficiently.

    • Example: List names = new ArrayList<>();

Answered by AI

Skills evaluated in this interview

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

I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. About Reframework
  • Q2. About project and concepts used

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic aptitude questions. Could be done easily if practiced enough

Round 2 - Technical 

(2 Questions)

  • Q1. Introduce yourself
  • Q2. Array searching
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Java questions , stream api
  • Q2. Whatever you have mention in resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Java basics, memory management, multithreading.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. When have you had a conflict with someone.
  • Ans. 

    I had a conflict with a team member over project priorities.

    • Miscommunication led to conflicting priorities

    • Discussed the issue openly and found a compromise

    • Learned the importance of clear communication in team projects

  • Answered by AI
  • Q2. Tell me you greatest project
  • Ans. 

    Developed a web-based project management tool for tracking tasks and deadlines

    • Used React for front-end development

    • Implemented user authentication and authorization using JWT tokens

    • Utilized Node.js and Express for back-end development

    • Integrated MongoDB for database storage

  • Answered by AI

Software Developer Interview Questions & Answers

ZS user image Rahul Yamsani 010

posted on 22 Dec 2024

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

Challenging questions in mathematics.

Round 2 - Group Discussion 

A constructive discussion about the significance of various topics and additional aspects.

Deloitte Interview FAQs

How many rounds are there in Deloitte Senior Plsql Developer interview?
Deloitte interview process usually has 2 rounds. The most common rounds in the Deloitte interview process are Resume Shortlist and Technical.
What are the top questions asked in Deloitte Senior Plsql Developer interview?

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

  1. Did you ever work on query tuning and optimization? What do you see in explain ...read more
  2. How to debug procedure which has nested procedure in ...read more
  3. How partitions is useful and when to create...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.9
 • 8.2k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.1k Interviews
KPMG India Interview Questions
3.5
 • 798 Interviews
ZS Interview Questions
3.4
 • 482 Interviews
BCG Interview Questions
3.8
 • 196 Interviews
View all
Consultant
33.2k salaries
unlock blur

₹6.3 L/yr - ₹23.2 L/yr

Senior Consultant
20.8k salaries
unlock blur

₹11 L/yr - ₹42 L/yr

Analyst
14.1k salaries
unlock blur

₹3.8 L/yr - ₹12.6 L/yr

Assistant Manager
10k salaries
unlock blur

₹7.8 L/yr - ₹24 L/yr

Manager
7k salaries
unlock blur

₹15.7 L/yr - ₹52 L/yr

Explore more salaries
Compare Deloitte with

Accenture

3.8
Compare

PwC

3.4
Compare

Ernst & Young

3.4
Compare

Cognizant

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