BNP Paribas SQL Developer Interview Questions, Process, and Tips

The assessment consisted of two moderate-level questions related to data structures and algorithms, focusing on strings and 2D arrays, within a time frame of 45 minutes. In the web development section, there were 15 questions each from React and Angular.

Q1. What is object-oriented programming (OOP), and can you explain the concepts of shallow copy and deep copy? Additionally, what technology stack would you choose for a project, and what are the reasons behin...read more
Ans. 
OOP is a programming paradigm based on the concept of objects, with shallow copy creating a new object with references to the original, and deep copy creating a new object with copies of the original's values.
• OOP is a programming paradigm that focuses on objects and classes.

• Shallow copy creates a new object that references the original object's data.

• Deep copy creates a new object with copies of the original object's da...read more
Answered by AI
Add your answer
Q2. What are the features of the project?
Ans. 
The project features include real-time data processing, machine learning algorithms, and user-friendly interface.
• Real-time data processing for instant updates

• Machine learning algorithms for predictive analysis

• User-friendly interface for easy navigation
Answered by AI
Add your answer

Q1. Wht is tuple and how it is dif from list
Ans. 
A tuple is an immutable collection of elements, while a list is a mutable collection in Python.
• Tuples are created using parentheses (), while lists are created using square brackets []

• Tuples are immutable, meaning their elements cannot be changed once defined

• Lists are mutable, allowing for elements to be added, removed, or modified

• Tuples are typically used for fixed collections of items, while lists are used for dynami
Answered by AI
Add your answer

Q1. Coin change problem
Add your answer

Q1. .net related questions
Add your answer

Q1. Functional knowledge
Add your answer

Q1. Discussion of salary and position
Add your answer

Q1. Tell about a time where you had competing demands from stakeholders.
Add your answer

HireVue, a few coding and some aptitude

Q1. Questions about Devops
Add your answer
Q2. Questions about project
Add your answer

Q1. Why do you want to work here
Ans. 
I am passionate about software development and believe this company offers a great learning opportunity.
• I admire the company's innovative projects and cutting-edge technologies.

• I am impressed by the company's positive reputation in the industry.

• I am excited about the opportunity to work with a talented team of developers.

• I believe this internship will provide me with valuable experience and skills for my future career.
Answered by AI
Add your answer
Q2. What do you think about your college
Ans. 
I think highly of my college as it provided me with a strong foundation in software development.
• My college has a reputable computer science program with experienced faculty members.

• The curriculum included hands-on projects and internships to enhance practical skills.

• I was able to participate in coding competitions and hackathons organized by the college.

• The college also offered networking opportunities with industry pr...read more
Answered by AI
Add your answer
Q3. Where do you see yourself in 5years
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on impactful projects.
• Continuing to enhance my technical skills and knowledge through continuous learning and training

• Taking on more leadership responsibilities and mentoring junior developers

• Contributing to the success of the company by delivering high-quality software solutions

• Exploring new technologies and trends in the software devel...read more
Answered by AI
Add your answer

Nice interview with the friendly interviewer

Q1. Tell me about your self
Add your answer