BNP Paribas Interview Questions, Process, and Tips

Q1. SQL questions to find last 5 rows
Ans. 
Use SQL query with ORDER BY and LIMIT to find last 5 rows
• Use ORDER BY clause to sort the rows in descending order based on a column

• Use LIMIT 5 to retrieve only the last 5 rows
Answered by AI
Add your answer
Q2. Unix- top command
Add your answer

Q1. Explain ingress
Ans. 
Ingress is a Kubernetes resource that manages external access to services within a cluster.
• Ingress allows you to route external HTTP and HTTPS traffic to services based on defined rules.

• It acts as a layer 7 load balancer for routing traffic to different services within the cluster.

• Ingress controllers like Nginx or Traefik are used to implement and manage Ingress resources.

• TLS termination, path-based routing, and host-b...read more
Answered by AI
Add your answer
Q2. How do you reduce docker image size
Ans. 
To reduce docker image size, remove unnecessary files, use multi-stage builds, minimize layers, and use smaller base images.
• Remove unnecessary files and dependencies

• Utilize multi-stage builds to separate build dependencies from runtime dependencies

• Minimize the number of layers in the Dockerfile

• Use smaller base images like Alpine instead of larger ones like Ubuntu
Answered by AI
Add your answer

General aptitude question

Q1. Technical questions on SQL in depth.
Add your answer
Q2. What is joints? write a code to join multiple table?
Ans. 
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Use JOIN keyword to combine tables based on a common column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

Q1. General pusonal questions
Add your answer

Q1. Behavioural Questions like Motivation Questions, Job fit, culture fit
Add your answer

Q1. Job fit, motivation, experience check
Add your answer

Q1. Conditional formatting, pivot table, pie chart, if else, sumif, countif exercises
Add your answer

Pricing case study and knowing the products that you do pricing of