Add office photos
i
Bajaj Finserv
CompareProud winner of ABECA 2024 - 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
Top trending discussions
Interview questions from similar companies
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
Software Developer Intern Interview Questions & Answers
JPMorgan Chase & Co.
Anonymous
posted on 24 Oct 2024
I applied via AmbitionBox and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. What challenge you faced in the professional environment and how you resolved it?
- Q2. How your prior work experience relates to this role requirement?
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
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.
(2 Questions)
- 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...
- 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...
- 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
Interview Preparation Tips
Plsql Developer Interview Questions & Answers
TSYS|Total System Services
Anonymous
posted on 11 Mar 2024
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 2 interview rounds.
(1 Question)
- Q1. Mcq questions, create proc for displaying collection values, write func to show values.
(2 Questions)
- Q1. Difference between primary key and unique key. Questions based on unique key and composite key. Write function to return multiple values. Sql queries to print values, update statement to update multiple ro...
- Q2. Performance tuning questions related to hints.
Interview Preparation Tips
Junior Software Developer Interview Questions & Answers
State Street Corporation
Anonymous
posted on 7 Aug 2024
(1 Question)
- 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
Skills evaluated in this interview
(1 Question)
- Q1. Coin change problem
(1 Question)
- Q1. .net related questions
(1 Question)
- Q1. Functional knowledge
(1 Question)
- Q1. Discussion of salary and position
I applied via Campus Placement
(1 Question)
- Q1. Tell about a time where you had competing demands from stakeholders.
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
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
Bajaj Finserv SQL Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Bajaj Finserv SQL Developer Reviews and Ratings
based on 7 reviews
Rating in categories
|
Assistant Manager
1.3k
salaries
|  ₹1.8 L/yr - ₹6.7 L/yr |
|
Sales Officer
1.3k
salaries
| ₹1 L/yr - ₹5 L/yr |
|
Sales Executive
1.2k
salaries
| ₹1 L/yr - ₹6 L/yr |
|
Sales Manager
1k
salaries
| ₹1.5 L/yr - ₹10 L/yr |
|
Manager
864
salaries
| ₹2.7 L/yr - ₹11 L/yr |
HDFC Bank
ICICI Bank
Axis Bank
State Bank of India
- Home >
- Interviews >
- Bajaj Finserv Interview Questions >
- Bajaj Finserv SQL Developer Interview Questions
