i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Binary search algorithm efficiently finds the target value in a sorted array.
Divide the array in half and compare the target value with the middle element.
If the target value is smaller, search the left half. If larger, search the right half.
Repeat the process until the target value is found or the subarray is empty.
Database optimization involves improving the performance of a database system by reducing response time and resource consumption.
Identify and eliminate redundant data
Index frequently queried columns
Normalize database schema
Optimize queries by using appropriate joins and filters
Use caching mechanisms to reduce database load
Use input validation, output encoding, and proper escaping to prevent XSS attacks.
Sanitize user input by validating and filtering all input data.
Encode output data to prevent malicious scripts from being executed.
Escape special characters in user input before displaying it on the website.
Implement Content Security Policy (CSP) to restrict the sources of content that can be loaded on your website.
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Walk-in and was interviewed before May 2019. There were 5 interview rounds.
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
I applied via Walk-in and was interviewed before Jun 2020. There were 5 interview rounds.
I applied via Company Website and was interviewed before Mar 2021. There were 3 interview rounds.
Java assesment.
I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Mar 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Mar 2020. There was 1 interview round.
Triggers are database objects that automatically execute in response to certain events or changes in data.
Triggers are used to enforce business rules or data integrity.
They can be used to audit changes to data.
Triggers can be set to execute before or after an event, such as an insert, update, or delete operation.
They can be defined on tables, views, or schemas.
Examples of triggers include sending an email notification ...
I applied via Campus Placement and was interviewed before Apr 2020. There were 4 interview rounds.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Consultant
55.4k
salaries
| ₹5.1 L/yr - ₹17.5 L/yr |
Associate Consultant
50.7k
salaries
| ₹3 L/yr - ₹11.9 L/yr |
Senior Consultant
46.7k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
Senior Analyst
21k
salaries
| ₹2.2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹12.6 L/yr |
Wipro
Accenture
Cognizant
TCS