BNP Paribas Interview Questions, Process, and Tips

First round was aptitude test, there were questions of medium difficulty

Just after apti round there were 7 coding questions, all of them were about code correction.

Q1. Asked about my introduction, then the interviewer asked me to tell something about my projects.
Add your answer
Q2. He asked me to write some sql queries as well. In which he gave me a question which was a join query question after that he questioned me about subqueries and some theoretical questions from oops concept i...read more
Add your answer

Q1. It was a very good experience till now, in HR round the interviewer asked the questions about sdlc types then some questions related to my project.
Add your answer
Q2. He also asked me questions about working in team which are easy if you know how to work in a team.
Add your answer

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