Add office photos
Filter interviews by
Kotak Mahindra Bank Oracle SQL and PLSQL Developer Interview Questions and Answers
Kotak Mahindra Bank Oracle SQL and PLSQL Developer Interview Experiences
1 interview found
Anonymous
(1 Question)
- Q1. All basic plsql
Top trending discussions
Interview questions from similar companies
DEEPAK BISHOYI
I applied via Approached by Company and was interviewed in Feb 2024. There were 2 interview rounds.
(5 Questions)
- Q1. PLSQL basic to advanced.
- Q2. Explain collections in details?
- Ans.
Collections in PL/SQL are data structures used to store multiple elements of the same data type.
Collections can be nested tables, varrays, or associative arrays.
Nested tables are like one-dimensional arrays with no upper bounds.
Varrays are like arrays with a maximum size that is specified at declaration.
Associative arrays are like lookup tables where each element is accessed using a unique key.
Collections can be used t...
- Q3. Bulk collect concept
- Ans.
Bulk collect is a feature in PL/SQL that allows for fetching multiple rows of data at once.
Improves performance by reducing context switches between the PL/SQL engine and SQL engine
Reduces network traffic by fetching multiple rows in a single round trip
Can be used with SELECT INTO or FETCH INTO statements
- Q4. Decode and case
- Q5. Tuning of sql and some sql code
Bank product related questions and carrer expericnce .
Selected
I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.
All the basic questions of SQL like joins, index, different between in where and having etc
(1 Question)
- Q1. Salary discussion
Sql based question, tables, joins, working experience.
Interview Preparation Tips
Delete and truncated difference
I applied via Referral and was interviewed in Aug 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. What are joins and types of joins?
- Ans.
Joins are used to combine data from two or more tables based on a related column.
Types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer join returns all row...
- Q2. What is index how to you creat an index?
- Ans.
An index is a database object that improves the speed of data retrieval operations on a table.
Indexes are created on columns of a table.
Creating an index involves specifying the table name, column name, and index type.
Types of indexes include clustered, non-clustered, unique, and full-text indexes.
Interview Preparation Tips
Skills evaluated in this interview
Kotak Mahindra Bank Interview FAQs
Tell us how to improve this page.
Kotak Mahindra Bank Interviews By Designations
- Kotak Mahindra Bank Assistant Manager Interview Questions
- Kotak Mahindra Bank Deputy Manager Interview Questions
- Kotak Mahindra Bank Relationship Manager Interview Questions
- Kotak Mahindra Bank Manager Interview Questions
- Kotak Mahindra Bank Relationship Officer Interview Questions
- Kotak Mahindra Bank Credit Manager Interview Questions
- Kotak Mahindra Bank Senior Manager Interview Questions
- Kotak Mahindra Bank Assistant Acquisition Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Plsql Developer Interview Questions
- Senior Plsql Developer Interview Questions
- SQL Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- SQL and PL SQL Developer Interview Questions
- SQL Server Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Assistant Manager
12.6k
salaries
|  ₹1 L/yr - ₹5 L/yr |
|
Deputy Manager
11.2k
salaries
| ₹1.6 L/yr - ₹8.4 L/yr |
|
Manager
5.3k
salaries
| ₹4 L/yr - ₹12 L/yr |
|
Senior Manager
3.5k
salaries
| ₹6.5 L/yr - ₹19 L/yr |
|
Relationship Manager
2.3k
salaries
| ₹1.6 L/yr - ₹10 L/yr |
HDFC Bank
ICICI Bank
Axis Bank
State Bank of India
Calculate your in-hand salary
- Home >
- Interviews >
- Kotak Mahindra Bank Interview Questions >
- Kotak Mahindra Bank Oracle SQL and PLSQL Developer Interview Questions
