i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
Performance tuning is the process of optimizing the performance of a system or application.
Identifying and resolving performance bottlenecks
Optimizing database queries and indexes
Improving hardware and network configurations
Reducing resource usage and improving response time
Monitoring and analyzing system performance
Stored procedure is a precompiled program that is stored in a database and can be called by other programs.
Stored procedures are used to encapsulate business logic and improve performance.
PL/SQL is a procedural language used to write stored procedures in Oracle databases.
Stored procedures can accept input parameters and return output parameters or result sets.
They can also be used to enforce security and data integrity...
I applied via Approached by Company and was interviewed in Sep 2023. There were 3 interview rounds.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row.
They allow you to perform calculations without grouping the rows into a single output row.
Examples of window functions include ROW_NUMBER(), RANK(), and LAG().
Packages in PL/SQL are used to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.
Packages help in modularizing code for easier maintenance and debugging
They provide encapsulation and hide implementation details
Packages can contain multiple procedures, functions, variables, cursors, and exceptions
They improve performance by reducing network traffic
E...
I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.
Oracle pl sql developer
I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.
Factorial of a number is the product of all positive integers up to that number.
To calculate factorial of a number, multiply all positive integers up to that number.
Factorial of 0 is 1.
Example: Factorial of 5 is 5*4*3*2*1 = 120.
Modelling of schema involves designing the structure of a database to organize and represent data.
Identify entities and their relationships
Define attributes for each entity
Establish primary and foreign keys
Normalize the schema to reduce redundancy
Consider performance and scalability
I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.
based on 3 interviews
Interview experience
based on 33 reviews
Rating in categories
Consultant
55.4k
salaries
| ₹5.2 L/yr - ₹18 L/yr |
Associate Consultant
50.7k
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Senior Consultant
46.5k
salaries
| ₹7.5 L/yr - ₹24.8 L/yr |
Senior Analyst
20.8k
salaries
| ₹2.2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS