Add office photos
i
HDFC Bank
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
HDFC Bank Plsql Developer Interview Questions and Answers
HDFC Bank Plsql Developer Interview Experiences
1 interview found
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 .
Plsql Developer Jobs at HDFC Bank
Interview questions from similar companies
(2 Questions)
- Q1. Code related quest
- Q2. 1 program is given to write
(1 Question)
- Q1. Scenario based question
Front end Developer Interview Questions & Answers
Kotak Mahindra Bank
Anonymous
posted on 7 May 2024
I applied via LinkedIn and was interviewed in Nov 2023. There were 2 interview rounds.
Was given a bar raiser round where been asked problems on dp, create a crud shopping cart type webapp in react, and one css problem to align all boxes across diagonal
(2 Questions)
Mostly around resume and performance optimisation
- Q1. Verbally design infinte scroll in react
- Ans.
Implementing infinite scroll in React involves dynamically loading content as the user scrolls down the page.
Use a scroll event listener to detect when the user reaches the bottom of the page
Fetch more data from the server and append it to the existing content
Update the state to reflect the new content and trigger a re-render of the component
- Q2. Flatten array deeply nested
- Ans.
Flatten deeply nested array of strings
Use recursion to iterate through each element in the array
Check if each element is an array, if so, recursively call the function
Concatenate the strings from each nested array into a single flat array
Selected
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
1. DS algorithms with linked list questions and dynamic programming
Oracle SQL and PLSQL Developer Interview Questions & Answers
Kotak Mahindra Bank
Anonymous
posted on 26 Sep 2024
(1 Question)
- Q1. All basic plsql
Selected
I applied via Recruitment Consulltant and was interviewed before May 2022. There were 3 interview rounds.
(3 Questions)
- Q1. Tell me full form of html and CSS and types
- Ans.
HTML stands for Hypertext Markup Language and CSS stands for Cascading Style Sheets.
HTML is used for creating the structure and content of a webpage.
CSS is used for styling and formatting the appearance of a webpage.
HTML and CSS are the fundamental building blocks of web development.
HTML tags are used to define elements on a webpage, while CSS is used to apply styles to those elements.
There are different types of HTML
- Q2. Hyper text markup language and cascading style sheets
- Q3. Types is internal, external and inline css
- Ans.
Types of CSS are internal, external and inline.
Internal CSS is defined within the HTML document using the