i
Kyndryl
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
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
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.
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().
posted on 24 Nov 2022
I applied via Recruitment Consulltant and was interviewed in Oct 2022. There were 4 interview rounds.
Best practices, issues faced, and their mitigation in the role of Lead Consultant
Implementing regular communication channels to ensure effective collaboration among team members
Establishing clear project goals and objectives to guide the team's efforts
Identifying and addressing potential risks and challenges proactively
Leveraging industry best practices and lessons learned from previous projects
Encouraging continuous l...
posted on 15 Jan 2025
I applied via Approached by Company and was interviewed before Jan 2024. There was 1 interview round.
System Administrator
1.2k
salaries
| ₹2.9 L/yr - ₹12.1 L/yr |
Project Manager
628
salaries
| ₹7.1 L/yr - ₹28.7 L/yr |
Associate Technical Engineer
607
salaries
| ₹4 L/yr - ₹6.5 L/yr |
Infrastructure Specialist
542
salaries
| ₹5.3 L/yr - ₹22 L/yr |
SME
445
salaries
| ₹7.4 L/yr - ₹25 L/yr |
IBM
Accenture
TCS
Wipro