Filter interviews by
I applied via Approached by Company and was interviewed in Dec 2021. There were 5 interview rounds.
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...
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
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
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
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
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...
I applied via Naukri.com and was interviewed before Mar 2022. There was 1 interview round.
Derivatives are financial contracts that derive their value from an underlying asset or benchmark.
Derivatives can be used for hedging or speculation
Examples of derivatives include futures, options, and swaps
SLAB stands for Structured Legal Assistance Box, a type of settlement used in legal cases
SLAB settlements involve the creation of a trust to manage the settlement funds and distribute payments to claimants
I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 4 interview rounds.
Hacker rank situational problem with TI
What people are saying about BNP Paribas
I applied via Recruitment Consulltant and was interviewed before Jan 2023. There were 2 interview rounds.
BNP Paribas interview questions for popular designations
I applied via Naukri.com
Get interview-ready with Top BNP Paribas Interview Questions
BNP Paribas is a French multinational bank and financial services company.
Founded in 2000 through the merger of Banque Nationale de Paris and Paribas
Headquartered in Paris, France
Offers a range of financial services including retail banking, investment banking, and asset management
Operates in over 70 countries worldwide
One of the largest banks in the world by total assets
BGP, EIGRP, and ISIS are routing protocols used in networking.
BGP (Border Gateway Protocol) is used for routing between different autonomous systems.
EIGRP (Enhanced Interior Gateway Routing Protocol) is a Cisco proprietary protocol used for routing within a single autonomous system.
ISIS (Intermediate System to Intermediate System) is a protocol used for routing within a single autonomous system, similar to EIGRP.
BGP us...
VPN is a secure connection between two networks while VLAN is a logical grouping of devices on a network.
VPN stands for Virtual Private Network and is used to securely connect two networks over the internet.
VPN uses encryption to protect data transmitted over the network.
VLAN stands for Virtual Local Area Network and is used to logically group devices on a network.
VLANs can be used to separate traffic on a network for ...
OSI and TCP/IP models are reference models used to describe how data is transmitted over a network.
OSI model has 7 layers, while TCP/IP model has 4 layers
OSI model is theoretical, while TCP/IP model is practical
OSI model is used for teaching and understanding networking concepts, while TCP/IP model is used for actual implementation
Examples of layers in OSI model: Physical, Data Link, Network, Transport, Session, Presen...
MPLS is a protocol for efficient data transfer, MP-VPN is a VPN service using MPLS, and MPLS-TE is a traffic engineering extension of MPLS.
MPLS stands for Multiprotocol Label Switching and is used to efficiently route data packets through a network.
MP-VPN is a VPN service that uses MPLS to securely connect multiple sites or users to a private network.
MPLS-TE is an extension of MPLS that allows for more precise traffic ...
MTU stands for Maximum Transmission Unit. It is the largest size of data packet that can be transmitted over a network.
MTU is measured in bytes.
The default MTU size for Ethernet is 1500 bytes.
To find the MTU size for CE/PE, you can use the ping command with the -f option to set the Do Not Fragment (DNF) bit and gradually increase the packet size until you receive a 'packet needs to be fragmented but DF set' message.
Ano...
BGP attributes are characteristics used to determine the best path for routing traffic between networks.
BGP attributes include: AS Path, Next Hop, Local Preference, Multi-Exit Discriminator (MED), Weight, and Origin.
AS Path identifies the sequence of autonomous systems that the route has passed through.
Next Hop identifies the IP address of the next router in the path.
Local Preference is used to indicate the preferred p...
I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.
I applied via Naukri.com and was interviewed in Oct 2021. There were 5 interview rounds.
The interview question covers job card parameters, cond parameter, gdg and vsams, abends, sorting, and joins.
Job card parameters are used to specify job information such as job name, job class, and accounting information.
COND parameter is used to conditionally execute job steps based on the return code of previous steps.
GDG (Generation Data Group) is a group of related datasets that are created and managed together.
VSA...
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
I applied via LinkedIn and was interviewed before Oct 2022. There were 5 interview rounds.
Questions asked regarding the stock pitch made.
BNP Paribas is a global banking and financial services company with a complex organizational structure.
BNP Paribas operates in over 70 countries worldwide
The company is divided into three main business lines: Retail Banking, Corporate & Institutional Banking, and Investment Solutions
BNP Paribas has a strong presence in Europe, the Americas, and Asia-Pacific regions
Some of the top questions asked at the BNP Paribas interview -
The duration of BNP Paribas interview process can vary, but typically it takes about 2-4 weeks to complete.
based on 154 interviews
Interview experience
based on 1.5k reviews
Rating in categories
Senior Associate
2k
salaries
| ₹3.6 L/yr - ₹14 L/yr |
Assistant Manager
1.3k
salaries
| ₹5.8 L/yr - ₹24 L/yr |
Associate 1
1k
salaries
| ₹2.5 L/yr - ₹9.5 L/yr |
Associate
809
salaries
| ₹2 L/yr - ₹8 L/yr |
Senior Software Engineer
457
salaries
| ₹7.5 L/yr - ₹28 L/yr |
HSBC Group
Standard Chartered
ICICI Bank
HDFC Bank