AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
BNP Paribas SQL Developer Interview Questions and Answers
BNP Paribas SQL Developer Interview Experiences
1 interview found
Anonymous
I applied via Approached by Company and was interviewed in Dec 2021. There were 5 interview rounds.
(3 Questions)
- Q1. Basics of SQL, types of joins, cursors, triggers
- 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...
- 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
(4 Questions)
- Q1. Similar questions to TR1, but this time with more depth and at advanced level
- 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...
- 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
- 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
(2 Questions)
- Q1. Basic questions on project structure, development approach
- 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...
(1 Question)
- Q1. Casual meeting wrt expectations from project, work culture, etc.
(1 Question)
- Q1. CTC, location negotiation
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Referral and was interviewed before Nov 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. What is bond?
- Q2. What is Fund Accounting?
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Demonetization
- Q2. Banking sector questions
Interview Preparation Tips
Experience: Basic aptitude test. East to clear.
Duration: 1 hour
Total Questions: 25
Skills: Reasoning Ability, Mathematical Logic, Logical Reasoning, General Knowledge
College Name: Sri Bhagawan Mahaveer Jain
Ishita Verma
I applied via Referral
Interview Questionnaire
4 Questions
- Q1. Brief introduction,,
- Q2. Why markets?
- Ans.
Markets offer dynamic and challenging environments that require constant adaptation and innovation.
Markets provide opportunities for growth and expansion
Competition in markets drives innovation and efficiency
Markets offer diverse career paths and opportunities for personal development
- Q3. 2-3 puzzles,
- Q4. Economics questions
Interview Preparation Tips
Experience: No. of Interviews: 1
I think they were looking for Mathematical and analytical ability, Awareness about and aptitude for finance related stuff (news items, their analysis, my understanding etc.)
Tips: Being prepared: In markets there is no substitute to knowing your stuff. You can‟t faff your way through as the questions will be technical
Skills: Financial Markets, Aptitude, Analytical Skills, Mathematical Aptitude
College Name: IIM Bangalore
I applied via Naukri.com and was interviewed before Jun 2019. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. It was more about the personal and case study which they asked me
Interview Preparation Tips
I would suggest if got an opportunity with this firm go ahead
Associate Interview Questions & Answers
JPMorgan Chase & Co.
SHUBHAM VINAYAK KALE shubham
posted on 4 Dec 2016
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Interview Questionnaire
8 Questions
- Q1. Project/DDP based questions
- Q2. Any coding done in curriculum, explain the most complex one
- Ans.
Yes, I have coded in curriculum. The most complex one was a project on building a web application using React and Node.js.
Built a full-stack web application using React and Node.js
Implemented user authentication and authorization using JSON Web Tokens (JWT)
Used MongoDB as the database and Mongoose as the ODM
Implemented real-time updates using Socket.IO
Deployed the application on Heroku
Handled errors and implemented log...
- Q3. What is 'Big data'? Why is it called 'Big'
- Ans.
Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big data is characterized by its volume, velocity, and variety
It is used in various industries such as healthcare, finance, and retail
Examples of big data include social media data, sensor data, and transactional data
It is called 'big' because it involves processing massive amounts of data
Big data requires ...
- Q4. Why do you want to switch to IT sector from your respective branch
- Ans.
I am passionate about technology and eager to learn new skills in the IT sector.
I have always had a keen interest in technology and enjoy working with computers.
I believe the IT sector offers more opportunities for growth and advancement in my career.
I have seen the impact of technology on various industries and want to be a part of that innovation.
I have taken courses in programming and networking to prepare myself fo...
- Q5. I did a course on compute simulation and had extra curricular in chess, so was asked to simulate a chess game
- Q6. Two friends A & B meet after long time, A asks B about his family. B says he has 3 children, product of their ages is 36, and sum of their ages is equal to the (point towards a house on street) house numbe...
- Q7. A rat has 3000 gm of rice, he has to travel a distance of 3000m, he eats 1gm rice/m, his maximum carrying capcity is 1000 gm,how should he travel the distance to reach with maximum rice left
- Q8. A new software has 3 functions SelectSum(), log() and exp(). You have a table of 1000 data points, how will you find product of all points using only the above mentioned functions
- Ans.
To find the product of all data points using SelectSum(), log(), and exp() functions.
Use the log() function to convert the product into a sum of logarithms
Apply the SelectSum() function to calculate the sum of logarithms
Finally, use the exp() function to convert the sum back into the product
Interview Preparation Tips
Experience: Aptitude part has easy questions, including number series, picture series, interest rate and some quant based questions.
The coding part is difficult.2-3 coding questions, Codes will be related to linked lists , trees or sorting.
Tips: Try to get maximum marks in aptitude, which should be fine with some practice . One of the code will be easy, so complete it and make a try for second
Duration: 1 hour
Total Questions: 30
Round: Puzzle Interview
Experience: very easy puzzles, I was able to solve all puzzles in first attempt
Tips: Be confident in your approach they are locking for approach more than result
Round: Technical Interview
Experience: I answered all resume based questions, he liked my choice of projects, though they were not exactly related to the profile. He liked me and said I would recommend you directly to HR round
Tips: Prepare in details about all points in resume, course work mentioned and projects, Based on performance in this interview, they decide to whether to take one more technical interview or send directly to HR
Skills: Behavioural Skills, Puzzle Solving Capability, Approaching A Problem, Basic Coding
College Name: IIT Madras
Shubham Jain
I appeared for an interview in Dec 2016.
Interview Questionnaire
5 Questions
- Q1. Write the algorithm for reversing the string
- Q2. Write an algorithm to select the number between min and maximum from a number series and that number shouldn't be a multiple of 10
- Q3. This was puzzle: you have 2 eggs and 100 floors. Eggs will start break beyond a particular floor. You can throw eggs from any of the floor. How will you minimise the total number of throws.
- Q4. Assume yourself as CEO of a company. You have vacancies and you are conducting interviews. 4 candidates (1. An IITian, 2. A woman, 3. Gay, 4.Physically handicapped) are equally capable and qualified have a...
- Ans.
As the CEO, I would select the candidate based on their qualifications and skills, regardless of their background or personal characteristics.
I would focus on the qualifications, skills, and experience of each candidate.
I would consider their ability to contribute to the company's goals and objectives.
I would ensure a fair and unbiased selection process.
I would prioritize diversity and inclusion in the workplace.
I woul...
- Q5. My interview was just after demonetization. So question was, assume you are CEO of Paytm. What will be your key values and what will be your strategy to add more customers.
Interview Preparation Tips
Experience: Aptitude part was pretty straightforward. Make sure you don't loose too much time on one question. Most of the questions were very easy. Number series, men working hours, probability and simple math calculations are enough to crack the test.
Coding part will definitely have one easy question (mostly will be on sorting algos). Basic coding knowledge is enough for this part.
Tips: Aptitude : Speed is the key. Since questions are easy, one who gets more than others will be shortlistled for the Interviews.
Coding: Make sure you solve atleast 1 problem correctly. And then try to attempt others.
Duration: 1 hour
Total Questions: 28
Round: Behavioural Interview
Experience: They also asked basic interview hr questions. Be prepared with your stories. If One of your story can make you look out of the stand, it will definitely work for this round. Strengths, weakness and where do you see yourself after 5 years.
Tips: Be confident. And be ready to defend your answers.
Skills: Math Puzzles, Algorithms And Data Structures, HR Skills, Inter Person Communication Skills
College Name: IIT Madras
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Dec 2016. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Tested DSA and Aptitude
- Q2. Checked design aspect questions
- Q3. What do you know about company
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Interview Questionnaire
13 Questions
- Q1. Tell me about yourself?
- Q2. Tell me about your family or life before college?
- Ans.
I grew up in a small town with my parents and younger sister. We were a close-knit family.
Grew up in a small town
Close-knit family
Parents and younger sister
Participated in community events
Enjoyed outdoor activities
- Q3. What do you do in free time?
- Q4. What would you expect from this company?
- Q5. Questions related to family and past life?
- Q6. Do you have any family member or friend in Bangalore?
- Ans.
Yes, I have a cousin who lives in Bangalore.
I have a cousin who has been living in Bangalore for the past 5 years.
We keep in touch and he has shown me around the city during my visits.
He works in the IT industry and enjoys the vibrant culture of Bangalore.
- Q7. How will you find loop in the circular linked list?
- Q8. How will you perform pre-fix and post-fix operation for the given string expression?
- Q9. What is data analytics(cause I had mentioned it on the resume)? Just explain the basic and tell them how it can help us make decision/inference
- Ans.
Data analytics is the process of examining data sets to draw conclusions about the information they contain.
Data analytics involves collecting, cleaning, and analyzing data to identify patterns and trends.
It can help businesses make informed decisions by providing insights into customer behavior, market trends, and operational efficiency.
For example, a retail company can use data analytics to analyze sales data and ide...
- Q10. In my final year project I have used random forest. So he asked me to explain random forest. And other projects related questions
- Q11. What is your strength and weakness? why J P Morgan Chase? What do you expect from this company? I am from Mechanical Engineering, so she asked me why non-core?
- Ans.
Strengths include adaptability and teamwork. Weaknesses include public speaking. Non-core background allows for diverse perspective. JPMorgan Chase's reputation and opportunities attract me.
Strengths: adaptability, teamwork
Weakness: public speaking
Non-core background brings diverse perspective
Attracted to JPMorgan Chase's reputation and opportunities
- Q12. Few behavioral questions: What will you do if you have enough money and good idea to start your own company?
- Ans.
I would pursue my entrepreneurial dream and start my own company.
I would conduct market research to validate my idea and identify potential competitors.
I would create a business plan outlining my goals, strategies, and financial projections.
I would secure funding through investors or loans.
I would assemble a team of talented individuals with diverse skills and experiences.
I would continuously evaluate and adapt my busi...
- Q13. How would you resolve team conflict between your idea and other idea, supported by majority?
- Ans.
I would listen to both sides, gather more information, and try to find a compromise that satisfies everyone.
Listen to both sides and understand their perspectives
Gather more information about both ideas
Try to find common ground and a compromise that satisfies everyone
Encourage open communication and respect for each other's ideas
Consider the potential impact and benefits of each idea
Involve a neutral third party if nec...
Interview Preparation Tips
Experience: The company came to our campus on day 3 and agreed to take walk-ins.
Therefore resume shortlisting was the procedure.
They had a cut off of 7 CGPA.
Tips: It would be good if you have some coding background with few projects. It could anything from class projects to your internships, extra-curricular or final year projects. Don't forget to mention what all programming language you know on your resume.
Round: Technical + HR Interview
Experience: The first round consists of two panels. One of them was asking HR. And the other was asking technical questions. They were just looking whether you have the basic technical knowledge and if given an offer you will join or not.
Tips: For technical knowledge, you can refer OOPs basic concepts, standard coding interview problems, geeksforgeeks, cracking the coding interview by Laxman Gayle etc. It would be better if you can first practice hr questions among your friends instead of going directly to interview. I found a youtube channel explains technical relatively easier and simpler way. you can follow that. Just try to show that you are interested in that company.
For HR questions, one can prepare from 64 HR questions.
For the basic OOPs concepts, one can read first 10 chapters from E.Balaguruswamy but any other OOPs book will also be fine.
Confidence is the key ace any interview!!
Round: HR Interview
Experience: This round was mainly to check your personality. He was trying to know whether you will fit in the company or not. Most of the question was from my personal life. They will see whether you are serious about your life or not.
Tips: Be ready to give them instances of your life where you did things differently. Try to show that you are passionate about the company. Try to show you have a clear vision in your life and working hard to achieve that.
Round: HR Interview
Experience: This round was just a formality. The HR from the second round interview introduced me to the third interviewer. He asked few question related to the family.
Tips: One important thing I would like to is that NEVER ASSUME THAT WHATEVER YOU TOLD TO YOUR PREVIOUS INTERVIEWER WILL BE KNOWN TO THE NEXT INTERVIEW. So, if you think some specific points will help you do good in an interview...just let him know. I could be anything your project, conference, paper presentation or your past life as well.
Skills: Programming, Object Oriented Programming (OOP) Basics, Team Working Ability, Passion, Data Strrutures, Algorithm
College Name: IIT Madras
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Aug 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Other than the general interview questions, summary of our existing profile is asked.
Interview Preparation Tips
BNP Paribas Interview FAQs
Some of the top questions asked at the BNP Paribas SQL Developer interview -
Tell us how to improve this page.
BNP Paribas Interviews By Designations
- BNP Paribas Senior Associate Interview Questions
- BNP Paribas Associate Interview Questions
- BNP Paribas Associate 1 Interview Questions
- BNP Paribas Assistant Manager Interview Questions
- BNP Paribas Intern Interview Questions
- BNP Paribas Senior Software Engineer Interview Questions
- BNP Paribas Business Analyst Interview Questions
- BNP Paribas Team Lead Interview Questions
- Show more
Interview Questions for Popular Designations
Interview Questions from Similar Companies
|
Senior Associate
2.3k
salaries
|  ₹5.8 L/yr - ₹13.1 L/yr |
|
Assistant Manager
1.5k
salaries
| ₹10.7 L/yr - ₹18 L/yr |
|
Associate 1
1.1k
salaries
| ₹3.3 L/yr - ₹7.2 L/yr |
|
Associate
905
salaries
| ₹3.4 L/yr - ₹7 L/yr |
|
Senior Software Engineer
586
salaries
| ₹14.3 L/yr - ₹23 L/yr |
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
Cholamandalam Investment & Finance
- Home >
- Interviews >
- BNP Paribas Interview Questions
