AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Bajaj
Finserv
Compare
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
Bajaj Finserv SQL Developer Interview Questions and Answers
Bajaj Finserv SQL Developer Interview Experiences
2 interviews found
(2 Questions)
- Q1. Tell me about joins?
- Q2. What is stored procedure
- Ans.
A stored procedure is a set of SQL statements that can be saved and reused in a database.
Stored procedures help improve performance by reducing network traffic.
They can be used to encapsulate complex logic and business rules.
Stored procedures can be called from applications or other stored procedures.
Example: CREATE PROCEDURE GetCustomerDetails AS SELECT * FROM Customers WHERE Country = 'USA';
I applied via LinkedIn and was interviewed in Aug 2022. There were 2 interview rounds.
(2 Questions)
- Q1. All questions SQL scenario. Like Use cases in sql
- Q2. Asking questions they asking deep knowledge
Interview Preparation Tips
Interview questions from similar companies
Software Developer Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 10 May 2015
Interview Questionnaire
11 Questions
- Q1. What is the difference between multi tasking, multi processing and multi programming operating systems with examples ?
- Ans.
Multi tasking, multi processing, and multi programming are different approaches to managing tasks in an operating system.
Multi tasking allows multiple tasks to run concurrently on a single processor.
Multi processing involves multiple processors running tasks simultaneously.
Multi programming allows multiple programs to be loaded into memory and executed concurrently.
Examples of multi tasking operating systems include Wi...
- Q2. Tell me about memory allocation (stack vs. heap)?
- Ans.
Memory allocation refers to the process of assigning memory to programs during runtime.
Stack allocation is done automatically and is limited in size.
Heap allocation is done manually and is larger in size.
Stack memory is used for local variables and function calls.
Heap memory is used for dynamic memory allocation.
Memory leaks can occur if heap memory is not properly managed.
- Q3. You have two threads one printing even numbers in order and other odd numbers. Design an algorithm so that it prints numbers in natural order?
- Ans.
Use a shared variable and synchronization mechanisms to ensure natural order printing of numbers.
Create two threads, one for printing even numbers and the other for printing odd numbers.
Use a shared variable to keep track of the current number to be printed.
Implement synchronization mechanisms like locks or semaphores to ensure only one thread can access the shared variable at a time.
Each thread should check if it is i...
- Q4. Print a matrix in spiral order?
- Ans.
Printing a matrix in spiral order
Start from the first element and print it
Move in a spiral order towards the center of the matrix
Repeat until all elements are printed
- Q5. Thread class and Runnable Interface?
- Ans.
Thread class and Runnable Interface are used for multithreading in Java.
Thread class is a predefined class in Java that provides methods to create and control threads.
Runnable interface is used to define a task that can be executed by a thread.
Thread class implements Runnable interface.
Thread class provides more control over threads than Runnable interface.
Example: Thread t = new Thread(new MyRunnable()); t.start();
Exa...
- Q6. What’s the difference between a Linked List and an ArrayList and give me an example of when to use which?
- Ans.
Linked List is a dynamic data structure while ArrayList is a static data structure.
Linked List is best for frequent insertion and deletion operations.
ArrayList is best for frequent access operations.
Linked List uses more memory than ArrayList.
ArrayList is faster than Linked List for accessing elements.
Use Linked List when you need to frequently add or remove elements from the list.
Use ArrayList when you need to frequen...
- Q7. Questions of OS concepts?
- Q8. A role play scenario was given. With a clear instruction on I don’t need to know the basis and the hypothetical assumption was presented. I was told that I was expected to respond to the given scenario, in...
- Q9. Why are you interested in a career in investment banking?
- Ans.
I am not interested in a career in investment banking.
I am more interested in a career in software development
I enjoy problem-solving and creating innovative solutions through coding
Investment banking does not align with my passion and skill set
- Q10. Why have you chosen to apply to J.P. Morgan?
- Ans.
I have chosen to apply to J.P. Morgan because of their reputation, global presence, and opportunities for growth.
J.P. Morgan has a strong reputation in the financial industry.
They have a global presence with offices in multiple countries.
The company offers various opportunities for career growth and development.
J.P. Morgan is known for its innovative technology solutions in the financial sector.
I am impressed by their ...
- Q11. Have you ever made a mistake? Tell us about it?
- Ans.
Yes, I have made a mistake in my previous project.
I underestimated the complexity of a task and ended up missing the deadline.
I failed to properly test a feature, resulting in a bug that affected user experience.
I accidentally deleted an important file without having a backup.
I misunderstood a requirement and implemented a feature incorrectly.
Interview Preparation Tips
Total Questions: 1
General Tips: Interview Process: Aptitude test, followed by 3 rounds of interview. Interview process was very good. Just be positive to clear the interview.
Check this link before appearing for interview with JP Morgan. It will help -----
Skills: Algorithm, Data structure, Stack
College Name: Na
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Motilal Oswal Financial Services
Anonymous
posted on 9 Jan 2022
I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Web Api, authentication
Interview Preparation Tips
Prepare and be procise
What people are saying about Bajaj Finserv
Software Developer Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 5 Jul 2021
Interview Questionnaire
1 Question
- Q1. All questions are related to ds and algorithm. Implications of data structure
Software Developer Interview Questions & Answers
TSYS|Total System Services
Anonymous
posted on 11 Jul 2023
Selected
I applied via Campus Placement and was interviewed before Jul 2022. There were 6 interview rounds.
Simple aptitude test ............
3 question leetcode medium .......
(1 Question)
- Q1. Basic programming based questions
(1 Question)
- Q1. Project based questions
(1 Question)
- Q1. Basic personal questions
Software Developer Interview Questions & Answers
TSYS|Total System Services
Anonymous
posted on 14 Feb 2024
(1 Question)
- Q1. Oops, mvc, design principles
Software Developer Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 14 Feb 2024
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
(6 Questions)
- Q1. Discuss about your current project
- Q2. Questions related to current project
- Q3. How to monitor heap memory area? And how objects are removed from heap memory
- Ans.
Heap memory can be monitored using tools like profilers. Objects are removed from heap memory through garbage collection.
Use profilers like VisualVM or Java Mission Control to monitor heap memory usage
Analyze heap dumps to identify memory leaks and optimize memory usage
Garbage collection automatically removes unreferenced objects from heap memory
Different garbage collection algorithms like Mark and Sweep, Copying, and ...
- Q4. How to handle an application running on different instances?
- Ans.
Handling an application running on different instances involves load balancing, monitoring, and synchronization.
Implement load balancing to distribute the workload evenly across instances.
Monitor the performance and health of each instance to ensure optimal operation.
Use synchronization techniques to maintain consistency and avoid conflicts between instances.
Implement failover mechanisms to handle instances going offli...
- Q5. Can you design a load balancer which can handle multiple addition of new instances or pods?
- Ans.
Yes, a load balancer can handle multiple addition of new instances or pods.
A load balancer distributes incoming traffic across multiple instances or pods.
To handle multiple additions, the load balancer should be able to dynamically update its routing configuration.
Load balancers can use various algorithms to distribute traffic, such as round-robin, least connections, or weighted distribution.
Load balancers can also per...
- Q6. How to implements caching in your application?
- Ans.
Caching improves application performance by storing frequently accessed data in memory.
Identify the data that needs to be cached
Choose a caching strategy (e.g., in-memory cache, distributed cache)
Implement caching logic in the application code
Set appropriate cache expiration policies
Handle cache invalidation when data changes
(1 Question)
- Q1. Can you design a distributed system which can handle load of 1M requests per second?
- Ans.
Yes, a distributed system can handle 1M requests per second by using load balancing, horizontal scaling, and caching.
Implement load balancing to distribute incoming requests across multiple servers.
Use horizontal scaling by adding more servers to handle the increased load.
Implement caching to store frequently accessed data and reduce the load on the backend.
Optimize the system by using efficient algorithms and data str...
Interview Preparation Tips
Skills evaluated in this interview
Software Developer Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 25 Oct 2023
Aptitude round it is very easy
(1 Question)
- Q1. Basic question there different from other
Interview Preparation Tips
Software Developer Interview Questions & Answers
JPMorgan Chase & Co.
Raghav Arora
posted on 22 Oct 2023
Very easy questions on stack and simple string questions
(1 Question)
- Q1. Project discussion
(1 Question)
- Q1. Why do u want to join us
Bajaj Finserv Interview FAQs
Tell us how to improve this page.
Bajaj Finserv Interviews By Designations
- Bajaj Finserv Sales Officer Interview Questions
- Bajaj Finserv Assistant Manager Interview Questions
- Bajaj Finserv Sales Manager Interview Questions
- Bajaj Finserv Sales Executive Interview Questions
- Bajaj Finserv Collections Manager Interview Questions
- Bajaj Finserv Assistant Sales Manager Interview Questions
- Bajaj Finserv Area Sales Manager Interview Questions
- Bajaj Finserv Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
Bajaj Finserv SQL Developer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Sales Officer
1.3k
salaries
|  ₹1.5 L/yr - ₹4.2 L/yr |
|
Assistant Manager
1.3k
salaries
| ₹1.8 L/yr - ₹6.7 L/yr |
|
Sales Executive
1.2k
salaries
| ₹1.5 L/yr - ₹4.2 L/yr |
|
Sales Manager
1.1k
salaries
| ₹3.5 L/yr - ₹7.6 L/yr |
|
Manager
936
salaries
| ₹4.5 L/yr - ₹10 L/yr |
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
Cholamandalam Investment & Finance
- Home >
- Interviews >
- Bajaj Finserv Interview Questions
