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
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
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

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 - Aptitude Test 

Do oops and data structures and sql

Round 3 - Technical 

(1 Question)

  • Q1. About Project questions asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Do spl and oops for OA

I applied via campus placement at Amrita Vishwa Vidyapeetham, Amritapuri Campus and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Coding Test 

The initial round was mixture of video interview and coding round.We will be asked 2 video interview questions and 2 coding questions

Round 2 - Technical 

(5 Questions)

  • Q1. Introduce yourself in five minutes
  • Q2. Tell about your projects and what are the challenges you faced while doing project
  • Q3. If you find any challenge while doing project what is your approch to overcome it
  • Q4. Till now in your career what is your biggest achievement
  • Q5. If you given a string in which numbers are combined how to seperate the longest alphabetical sequence
  • Ans. 

    The longest alphabetical sequence in a string of combined numbers can be separated using string manipulation and iteration.

    • Iterate through the string character by character

    • Check if the current character is alphabetical

    • If it is, start building a substring of alphabetical characters

    • If the next character is also alphabetical, add it to the substring

    • If the next character is not alphabetical, compare the length of the curre...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up bascis of coding
Be clear on what you speak

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
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected

I applied via Approached by Company

Round 1 - Coding Test 

It was spring boot java based online round

Round 2 - One-on-one 

(2 Questions)

  • Q1. Optional in java.
  • Q2. Eager and lazy initialization in simgleton design pattern
  • Ans. 

    Eager initialization creates the instance of Singleton class at the time of class loading, while lazy initialization creates the instance only when it is required.

    • Eager initialization can lead to resource wastage if the instance is never used.

    • Lazy initialization is more efficient as it only creates the instance when needed.

    • Eager initialization is thread-safe by default, while lazy initialization requires synchronizatio...

  • Answered by AI

Skills evaluated in this interview

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.7k salaries
unlock blur

₹8.9 L/yr - ₹35 L/yr

Senior Analyst
3.9k salaries
unlock blur

₹4 L/yr - ₹16.4 L/yr

Assistant Vice President
3.4k salaries
unlock blur

₹15.9 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