400+ BNP Paribas Interview Questions & Answers | Complete Prep Guide 2025

BNP Paribas Interview Experiences

Popular Designations

178 interviews found

SQL Developer Interview Questions & Answers

Anonymous

posted on 4 Jun 2022

I applied via Approached by Company and was interviewed in Dec 2021. There were 5 interview rounds.

Round 1 - Technical

(3 Questions)

Q1. Basics of SQL, types of joins, cursors, triggers

Add your answer

Q2. Functions and Procedures and differences between them

Ans.

Functions and procedures are both stored database objects used to perform specific tasks in SQL.

Functions return a value while procedures do not.
Functions can be used in SQL statements, whereas procedures cannot.
Functions can have input parameters and return a single value, while procedures can have input and output parameters.
Functions are typically used for calculations or data manipulation, while procedures are used...

Answered by AI

View 2 more answers

Q3. Performance tuning of SQL query

Ans.

Performance tuning of SQL query

Identify slow queries using profiling tools
Optimize query structure and use indexes
Reduce data retrieval by filtering and limiting results
Avoid using subqueries and nested queries
Use appropriate data types and avoid unnecessary conversions

Answered by AI

Add your answer

Round 2 - Technical

(4 Questions)

Q1. Similar questions to TR1, but this time with more depth and at advanced level

Add your answer

Q2. Given sample data on two tables, write down the result sets of all types joins.

Ans.

The result sets of all types of joins in SQL

Inner Join: Returns only the matching rows from both tables
Left Join: Returns all the rows from the left table and the matching rows from the right table
Right Join: Returns all the rows from the right table and the matching rows from the left table
Full Outer Join: Returns all the rows from both tables, including the unmatched rows
Cross Join: Returns the Cartesian product of b

Answered by AI

View 1 more answer

Q3. Write down a procedure to return a certain series (99, 96, 93, ...., 6, 3)

Ans.

Procedure to return a series (99, 96, 93, ...., 6, 3)

Create a temporary table with a single column
Use a loop to insert values into the temporary table
Return the values from the temporary table in descending order

Answered by AI

View 1 more answer

Q4. Extract execution plan of a SQL query

Ans.

To extract execution plan of a SQL query, use EXPLAIN or SHOW PLAN command.

Use EXPLAIN or SHOW PLAN command before the SQL query
EXPLAIN command shows the execution plan in a tabular format
SHOW PLAN command shows the execution plan in a graphical format
Execution plan helps in optimizing the query for better performance

Answered by AI

Add your answer

Round 3 - One-on-one

(2 Questions)

Q1. Basic questions on project structure, development approach

Add your answer

Q2. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)

Ans.

A change request in an application is serviced by the development team through various stages such as business analysis, code analysis, discussion with BA, and requirement freeze.

The development team starts by analyzing the change request to understand its impact on the application.
They perform business analysis to determine the feasibility and potential risks of implementing the change.
Code analysis is conducted to as...

Answered by AI

View 3 more answers

Round 4 - Behavioral

(1 Question)

Q1. Casual meeting wrt expectations from project, work culture, etc.

Add your answer

Round 5 - HR

(1 Question)

Q1. CTC, location negotiation

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Theoretical knowledge is not preferred. Whatever is present in the resume, make sure you have hands-on experience in that.

Skills evaluated in this interview

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)

View answer (4)

Engineer Trainee Interview Questions & Answers

Anonymous

posted on 3 Jan 2025

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - One-on-one

(5 Questions)

Q1. Basic questions on python

Add your answer

Q2. Difference between list tuple

Ans.

Lists and tuples are both data structures in Python, but lists are mutable while tuples are immutable.

Lists are enclosed in square brackets [], while tuples are enclosed in parentheses ().
Lists can be modified after creation, while tuples cannot be modified (immutable).
Lists are typically used for collections of similar items, while tuples are used for fixed collections of items.
Example: list = [1, 2, 3] and tuple = (4

Answered by AI

Add your answer

Q3. Area of room 6D

Ans.

The area of a room can be calculated by multiplying the length by the width.

Calculate the area by multiplying the length and width of the room.
For example, if the length of the room is 10 feet and the width is 12 feet, the area would be 120 square feet.
Make sure to use the same units for length and width when calculating the area.

Answered by AI

Add your answer

Q4. Most emberacing situation u faced in your life

Ans.

Getting caught cheating on a test in high school

Was copying answers from a classmate during a test
Teacher caught me and called me out in front of the whole class
Felt embarrassed and learned my lesson about cheating

Answered by AI

Add your answer

Q5. Behavior questions like what will u do if this happens

Add your answer

Engineer Trainee Interview Questions asked at other Companies

Q1. If 10 people had a meeting and they shake hands only once with each of the others, then how many handshakes will be there in total ?

View answer (8)

BNP Paribas Interview Questions and Answers for Freshers

Senior Engineer Interview Questions & Answers

Pratyush Prakash.

posted on 19 Oct 2024

Interview experience

Excellent

Difficulty level

Hard

Process Duration

2-4 weeks

Result

Selected

I applied via Approached by Company and was interviewed in Sep 2024. There were 5 interview rounds.

Round 1 - Technical

(2 Questions)

Q1. Multi threading print odd even with 2 threads but output should be in sync

Ans.

Use two threads to print odd and even numbers in sync

Create two threads, one for printing odd numbers and one for printing even numbers
Use synchronization mechanisms like mutex or semaphore to ensure output is in sync
Example: Thread 1 prints odd numbers (1, 3, 5, ...) and Thread 2 prints even numbers (2, 4, 6, ...)

Answered by AI

Add your answer

Q2. Largest common prefix in string array

Ans.

Find the largest common prefix among an array of strings.

Iterate through the characters of the first string and compare with the corresponding characters of other strings.
Stop when a mismatch is found or when reaching the end of any string.
Return the prefix found so far.

Answered by AI

Add your answer

Round 2 - Technical

(2 Questions)

Q1. Saga pattern in microservice

Ans.

Saga pattern is a design pattern used in microservices architecture to manage distributed transactions.

Saga pattern breaks down a transaction into a series of smaller, independent steps.
Each step in the saga is a separate transaction that can be rolled back if needed.
If one step fails, compensating transactions can be executed to undo the changes made by previous steps.
Saga pattern helps maintain data consistency in a ...

Answered by AI

Add your answer

Q2. API validation and security

Add your answer

Round 3 - Technical

(2 Questions)

Q1. Micro service inter communication

Add your answer

Q2. Hash map hash set implementation

Ans.

Hash map and hash set are data structures that use hashing to store key-value pairs and unique values respectively.

Hash map uses key-value pairs where keys are hashed to find the corresponding value
Hash set stores unique values using hashing to quickly check for duplicates
Example: HashMap map = new HashMap<>(); HashSet set = new HashSet<>();

Answered by AI

Add your answer

Round 4 - One-on-one