Filter interviews by
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy and inconsistencies.
There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.
Example: If we have a table with customer details and orders, we can normalize i...
Stored procedures are precompiled SQL statements stored in a database for reuse.
Stored procedures help improve performance by reducing network traffic.
They can be used to encapsulate business logic in the database.
Stored procedures can be parameterized for flexibility.
They provide a layer of security by controlling access to data.
Examples: sp_GetCustomerById, sp_UpdateEmployeeSalary
Top trending discussions
I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.
I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.
SQL server
SQL DBA
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
Easy on cyber security
An index is a data structure that improves the speed of data retrieval operations in a database by allowing quick access to specific data.
Indexes are used to quickly locate data without having to search every row in a database table.
They are created on specific columns in a table to speed up queries that filter or sort by those columns.
Examples of indexes include primary keys, unique keys, and non-unique indexes.
Behavioural and culture fit
posted on 20 Jan 2025
I applied via Campus Placement
Basic maths questions
Basic topics movies vs series
I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 interview rounds.
Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.
Window functions are used to calculate running totals, moving averages, and rank values.
They are applied to a set of rows defined by an OVER clause.
Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
CTE stands for Common Table Expression, a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTE is defined using the WITH keyword followed by a name and a SELECT statement.
It can be used to simplify complex queries, improve readability, and reduce code duplication.
CTE can also be recursive, allowing for hierarchical queries.
Example: WITH sales AS (SELECT * FROM order...
I appeared for an interview in Dec 2024.
2nd with VP which is easy but he seems not okay with my ECTC
based on 1 interview
Interview experience
Assistant Manager
559
salaries
| ₹5 L/yr - ₹14 L/yr |
Manager
258
salaries
| ₹6.6 L/yr - ₹22 L/yr |
Business Development Associate
170
salaries
| ₹1.6 L/yr - ₹3.6 L/yr |
Business Development Officer
170
salaries
| ₹3 L/yr - ₹5.1 L/yr |
Business Development Manager
135
salaries
| ₹2.5 L/yr - ₹8 L/yr |
HDFC Bank
ICICI Bank
Axis Bank
Kotak Mahindra Bank