i
Kyndryl
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Top trending discussions
posted on 6 Jul 2024
UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.
UNION removes duplicate rows from the result set, while UNION ALL includes all rows
UNION is slower than UNION ALL because it has to perform a distinct operation
UNION requires that all SELECT statements have the same number of columns with compatible data types
I approach performance tuning of a stored procedure by analyzing query execution plans, optimizing indexes, and rewriting inefficient code.
Analyze query execution plans to identify bottlenecks
Optimize indexes to improve data retrieval speed
Rewrite inefficient code to reduce unnecessary processing
Consider parameter sniffing and data distribution for optimal performance
A recursive CTE (Common Table Expression) is a query that references itself within the query definition.
Allows for hierarchical data querying
Uses a base case and recursive member in the query
Example: querying a table with parent-child relationship using recursive CTE
I applied via Approached by Company and was interviewed before Oct 2023. There were 2 interview rounds.
The SAP journey involves implementing, customizing, and optimizing SAP software to meet business needs.
Start with understanding the business requirements and goals
Implement SAP software modules based on the requirements
Customize the software to fit the specific needs of the organization
Optimize the system for efficiency and effectiveness
Provide training and support to users for successful adoption
I applied via Naukri.com and was interviewed in Mar 2021. There were 5 interview rounds.
posted on 25 Oct 2024
Solid principles are a set of design principles for writing clean, maintainable code.
Single Responsibility Principle - A class should have only one reason to change. Example: A class that handles user authentication should not also handle database operations.
Open/Closed Principle - Classes should be open for extension but closed for modification. Example: Using interfaces to allow for different implementations without ...
Design patterns are reusable solutions to common problems in software design.
Design patterns help in creating flexible, maintainable, and scalable software.
Examples of design patterns include Singleton, Factory, Observer, and Strategy.
They provide a common language for developers to communicate and understand each other's code.
Design patterns can be categorized into creational, structural, and behavioral patterns.
I applied via Approached by Company and was interviewed in Mar 2021. There was 1 interview round.
Modified and Macaulay duration are measures of bond price sensitivity to changes in interest rates.
Modified duration measures the percentage change in bond price for a 1% change in yield.
Macaulay duration is the weighted average time to receive all cash flows from a bond.
Both measures help investors assess interest rate risk and make informed investment decisions.
For example, a bond with a longer Macaulay duration will...
posted on 29 Jan 2024
I was interviewed in Jul 2023.
posted on 28 Jun 2024
I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.
JavaScript methods are built-in functions that can be called on objects to perform specific tasks.
Methods are called using dot notation, like object.method().
Some common methods include toString(), toUpperCase(), and includes().
Methods can also be used to manipulate arrays, such as push(), pop(), and splice().
based on 1 interview
Interview experience
based on 1 review
Rating in categories
System Administrator
1.2k
salaries
| ₹2.9 L/yr - ₹12 L/yr |
Associate Technical Engineer
633
salaries
| ₹3.5 L/yr - ₹6.5 L/yr |
Project Manager
622
salaries
| ₹6.7 L/yr - ₹29 L/yr |
Infrastructure Specialist
557
salaries
| ₹4.1 L/yr - ₹24 L/yr |
SME
435
salaries
| ₹9.5 L/yr - ₹27 L/yr |
IBM
Accenture
TCS
Wipro