Upload Button Icon Add office photos

Deutsche Bank

Compare button icon Compare button icon Compare
3.9

based on 3.3k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Deutsche Bank Senior Plsql Developer Interview Questions, Process, and Tips

Updated 14 Jun 2024

Deutsche Bank Senior Plsql Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Technical 

(8 Questions)

  • Q1. All basic PLSQL. Hands on Join questions.
  • Q2. Difference between PK & UK. How many Nulls are allowed for UK
  • Ans. 

    PK is Primary Key and UK is Unique Key. PK does not allow nulls while UK allows only one null value.

    • PK is used to uniquely identify each record in a table, while UK ensures that all values in a column are unique.

    • PK does not allow duplicate values, while UK allows duplicate values except for one null value.

    • Example: If a table has a PK on column 'ID', each record must have a unique ID value. If a table has a UK on column...

  • Answered by AI
  • Q3. What is pragma autonomous transactions. How does it work.
  • Ans. 

    Pragma autonomous transactions allow a PL/SQL subprogram to commit or rollback its own transactions independently of its caller.

    • Pragma autonomous transactions are used to execute a transaction independently of the main transaction.

    • It allows a subprogram to commit or rollback its own transactions without affecting the main transaction.

    • Autonomous transactions are often used for logging, auditing, or error handling purpos...

  • Answered by AI
  • Q4. Question on collections
  • Q5. Packages and it's advantages.
  • Ans. 

    Packages in PL/SQL are a way to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.

    • Packages help in modularizing code and promoting code reusability.

    • They provide encapsulation, allowing for better control over access to procedures and functions.

    • Packages improve performance by reducing network traffic and increasing scalability.

    • Example: Creating a pa...

  • Answered by AI
  • Q6. Difference between proc & function
  • Ans. 

    A procedure does not return a value, while a function returns a value.

    • Procedure is used to perform an action, while function is used to compute and return a value.

    • Procedures can have OUT parameters to return values, while functions always return a single value.

    • Functions can be used in SQL queries, while procedures cannot be used in SQL queries.

  • Answered by AI
  • Q7. Que on Cursors, usage
  • Q8. Error handling/exception handling
Round 2 - Personal Interview 

(3 Questions)

  • Q1. How will you deal with conflicts between your colleagues?
  • Q2. How will you handle working under pressure?
  • Q3. Can your personal issues affect your work. How will you manage
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected
Round 1 - Coding Test 

Trapping rain water and median of two sorted array

Round 2 - Technical 

(2 Questions)

  • Q1. Oops and dbms questions?
  • Q2. Code question in Array and string?
Round 3 - HR 

(1 Question)

  • Q1. Tell me about yourself
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I was interviewed in Sep 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference between hashmap and hash table
  • Ans. 

    HashMap is non-synchronized and allows null values, while HashTable is synchronized and does not allow null values.

    • HashMap is non-synchronized, meaning it is not thread-safe, while HashTable is synchronized and thread-safe.

    • HashMap allows null values for both keys and values, while HashTable does not allow null keys or values.

    • HashMap is generally preferred for non-thread-safe applications, while HashTable is used in mul

  • Answered by AI
  • Q2. Significance of equals and hashcode in java
  • Ans. 

    Equals method is used to compare the content of objects while hashcode method is used to generate a unique integer value for an object.

    • Equals method is used to compare the content of objects for equality.

    • Hashcode method is used to generate a unique integer value for an object.

    • Both methods are important for implementing proper object comparison and hashing in Java.

  • Answered by AI
Round 2 - Behavioral 

(2 Questions)

  • Q1. What motivates you to come to office
  • Ans. 

    I am motivated to come to the office by the opportunity to work on challenging projects, collaborate with talented colleagues, and contribute to the success of the team.

    • Challenging projects provide a sense of accomplishment and growth

    • Collaborating with talented colleagues allows for learning and innovation

    • Contributing to the success of the team fosters a sense of purpose and fulfillment

  • Answered by AI
  • Q2. Any scenario where you coached and mentored your collegue in previous organisation?
  • Ans. 

    Yes, I coached a junior developer on implementing design patterns in a project.

    • Provided guidance on how to apply design patterns in code

    • Reviewed their code and provided feedback for improvement

    • Encouraged them to ask questions and seek clarification

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - After applying we were sent a test link which consists of mcq's of Java8, spring boot etc. After that we were called for a walkin drive.There are 2 rounds. One technical and one managerial. Interviewers are friendly and asked basic questions on java and spring.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Mcq+coding which are medium level questions

Round 2 - Technical 

(3 Questions)

  • Q1. Multiple inheritance allowed in java?
  • Ans. 

    No, multiple inheritance is not allowed in Java.

    • Java does not support multiple inheritance for classes to avoid the diamond problem.

    • However, multiple inheritance is allowed for interfaces in Java.

    • Example: class A extends B, C is not allowed, but interface X extends Y, Z is allowed.

  • Answered by AI
  • Q2. Diff btw static and final
  • Ans. 

    Static is used to define class-level variables and methods, while final is used to define constants and prevent inheritance or modification.

    • Static variables and methods belong to the class itself, while final variables cannot be changed once initialized.

    • Static members can be accessed without creating an instance of the class, while final members must be accessed through an instance.

    • Static variables are shared among all...

  • Answered by AI
  • Q3. What is data encapsulation?
  • Ans. 

    Data encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.

    • Encapsulation hides the internal state of an object and only exposes the necessary functionalities through methods.

    • It helps in achieving data abstraction and information hiding.

    • Example: A class 'Car' encapsulates data like speed, color, and methods like accelerate() and brake().

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java, Python, and web development technologies

    • Strong problem-solving skills

    • Team player with excellent communication skills

  • Answered by AI
  • Q2. What are company core values
  • Ans. 

    Company core values are the fundamental beliefs that guide the behavior and decisions of employees.

    • Integrity - acting with honesty and transparency in all dealings

    • Innovation - constantly seeking new and better ways to solve problems

    • Customer focus - prioritizing the needs and satisfaction of customers

    • Teamwork - collaborating effectively with colleagues to achieve common goals

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Explain event driven architecture of node.js
  • Ans. 

    Node.js uses event-driven architecture where events trigger callbacks to handle asynchronous operations.

    • Node.js uses event loop to handle asynchronous operations efficiently

    • Events are emitted by various objects in Node.js like HTTP servers, file system, etc.

    • Callbacks are registered to handle events and execute code when events occur

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via campus placement at Ramaiah Institute of Technology, Bengaluru and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Resume based questions
  • Q2. Situation based questions
Round 2 - Interview with CTO 

(1 Question)

  • Q1. Situation based questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
No response

I applied via Job Portal and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(6 Questions)

  • Q1. What is mixed dml error
  • Ans. 

    Mixed DML error occurs when DML operations on setup and non-setup objects are mixed in a single transaction.

    • Mixed DML operations involve a combination of DML statements on both setup and non-setup objects in a single transaction.

    • This error typically occurs when trying to update a setup object (like User) and a non-setup object (like Account) in the same transaction.

    • To resolve the error, separate the DML operations on s...

  • Answered by AI
  • Q2. Types of asynchrnous class
  • Ans. 

    Types of asynchronous classes include future, batch, queueable, and scheduled classes.

    • Future classes are used for executing code asynchronously in the background.

    • Batch classes are used for processing large data sets in smaller chunks.

    • Queueable classes are used for chaining asynchronous jobs together.

    • Scheduled classes are used for running code at specific times.

  • Answered by AI
  • Q3. Profile permission set
  • Q4. Custom metadat, custom setting
  • Q5. Displayed a lwc component and asked how its code would be >?
  • Q6. How to call child method in parent in lwc
  • Ans. 

    To call a child method in a parent component in LWC, you can use the @api decorator in the child component and import the child component in the parent component.

    • Use @api decorator in the child component to expose the method or property that you want to call from the parent component.

    • Import the child component in the parent component and use the child component's reference to call the method or access the property.

    • Pass...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Experince on lwc
  • Ans. 

    Experience with Lightning Web Components (LWC) in Salesforce development.

    • Developed custom Lightning Web Components for Salesforce applications.

    • Used LWC to create interactive and responsive user interfaces.

    • Utilized LWC to fetch and display data from Salesforce database.

    • Implemented event handling and communication between components using LWC.

    • Followed best practices and design patterns while working with LWC.

    • Integrated L...

  • Answered by AI
  • Q2. How to call lwc from aura
  • Ans. 

    To call LWC from Aura, use the lightning/navigation service.

    • Use lightning/navigation service to navigate to the LWC component

    • Pass the component name and any parameters needed

    • Handle any events or data passed back from the LWC component

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain Encapsulation
  • Ans. 

    Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.

    • Encapsulation helps in hiding the internal state of an object and only exposing necessary functionalities.

    • It allows for better control over the data by preventing direct access from outside the class.

    • Encapsulation also helps in achieving data abstraction and information hiding.

    • Example: In a class representing a car, th...

  • Answered by AI
  • Q2. How to call rest API
  • Ans. 

    To call a REST API, you can use tools like Postman or code in languages like JavaScript or Python.

    • Use tools like Postman to make HTTP requests to the API endpoints

    • In programming languages like JavaScript, use libraries like Axios or Fetch to make API calls

    • Include necessary headers, parameters, and authentication tokens in the request

    • Handle the response data accordingly, whether it's JSON, XML, or other formats

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Sprig MVC, Spring boot and API

Skills evaluated in this interview

I applied via campus placement at Banasthali Vidyapeeth Womens Institute For Studies In Development Oriented Management, Jaipur and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Coding Test 

It had more than 30 aptitude questions and 2 coding questions

Round 2 - One-on-one 

(1 Question)

  • Q1. It was totally a tech round all questions were from Data structure, dbms, java, computer networking

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if you don't know any answer don't take time say it directly with confidence
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I was interviewed in Oct 2024.

Round 1 - Coding Test 

2 questions ...........................................................................................

Round 2 - Technical 

(2 Questions)

  • Q1. Dbms related and computer subjects
  • Q2. Oops related and one coding
Round 3 - HR 

(1 Question)

  • Q1. This was hr and technical both

Interview Preparation Tips

Interview preparation tips for other job seekers - Be well prepared

Deutsche Bank Interview FAQs

How many rounds are there in Deutsche Bank Senior Plsql Developer interview?
Deutsche Bank interview process usually has 3 rounds. The most common rounds in the Deutsche Bank interview process are Technical, Personal Interview and HR.
What are the top questions asked in Deutsche Bank Senior Plsql Developer interview?

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

  1. Difference between PK & UK. How many Nulls are allowed for...read more
  2. What is pragma autonomous transactions. How does it wo...read more
  3. Difference between proc & funct...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
Axis Bank Interview Questions
3.8
 • 1.4k Interviews
IDFC FIRST Bank Interview Questions
4.0
 • 619 Interviews
IndusInd Bank Interview Questions
3.6
 • 587 Interviews
Yes Bank Interview Questions
3.8
 • 411 Interviews
Barclays Interview Questions
3.9
 • 270 Interviews
View all
Associate
4.8k salaries
unlock blur

₹8.8 L/yr - ₹35 L/yr

Senior Analyst
3.9k salaries
unlock blur

₹4 L/yr - ₹16.5 L/yr

Assistant Vice President
3.4k salaries
unlock blur

₹16 L/yr - ₹48.5 L/yr

Analyst
2.1k salaries
unlock blur

₹2 L/yr - ₹11 L/yr

Financial Analyst
1k salaries
unlock blur

₹1.8 L/yr - ₹8.2 L/yr

Explore more salaries
Compare Deutsche Bank with

Barclays

3.9
Compare

JPMorgan Chase & Co.

4.0
Compare

HDFC Bank

3.9
Compare

ICICI Bank

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