Capgemini Senior Software Engineer Interview Questions, Process, and Tips

Q1. What is constructor overloading
Add your answer

Q1. There is no proper response from HR. They will schedule the call without our knowledge. HR team was not responsive. they have scheduled the second round. That round was not happened. Then I tried multiple ...read more
Add your answer
Q2. How to remove duplicate rows in a table without using distinct?
Ans. 
Use a self join to remove duplicate rows in a table without using distinct.
• Join the table with itself on the columns that define duplicates

• Filter out rows where the primary key is the same but other columns are different

• Select only distinct rows based on the primary key
Answered by AI
Add your answer
Q3. Can we create more than a foreign key in single table?
Ans. 
Yes, it is possible to create multiple foreign keys in a single table.
• Multiple foreign keys can be created in a single table by referencing different columns in the same or different tables.

• Each foreign key constraint must be defined separately with appropriate references.

• Foreign keys help maintain referential integrity between tables in a database.

• Example: Creating foreign keys in a 'Orders' table to reference 'Custom
Answered by AI
Add your answer
Q4. Explain about partitions
Ans. 
Partitions are divisions of a hard drive or storage device that allow for separate areas to store data.
• Partitions help organize data and prevent it from mixing together.

• Each partition can have its own file system and operating system.

• Partitions can be resized, created, or deleted using disk management tools.

• Examples include creating a separate partition for the operating system and another for personal files.
Answered by AI
Add your answer

Q1. Remove duplicates from an array
Ans. 
Remove duplicates from an array of strings
• Create a Set to store unique elements

• Iterate through the array and add each element to the Set

• Convert the Set back to an array to get the unique elements
Answered by AI
Add your answer
Q2. Questions on JS and react
Add your answer

Q1. All basic about reactjs and javascript
Add your answer
Q2. React life cycle methods
Add your answer
Q3. React hooks explanation
Ans. 
React hooks are functions that let you use state and other React features without writing a class.
• React hooks were introduced in React 16.8.

• They allow you to use state and other React features in functional components.

• useState() is a hook that allows you to add state to functional components.

• useEffect() is a hook that allows you to perform side effects in functional components.

• Custom hooks can be created to reuse logic
Answered by AI
Add your answer
Q4. Js es6 features
Add your answer
Q5. Splice and slice difference
Ans. 
Splice is used to add or remove elements from an array, while slice is used to extract a portion of an array into a new array.
• Splice can add elements to an array, remove elements from an array, or replace elements in an array.

• Slice creates a new array by extracting elements from an existing array based on start and end index parameters.

• Example of splice: array.splice(2, 0, 'new element') - adds 'new element' at index 2

• ...read more
Answered by AI
Add your answer

It was nice and good

Learn concept of DSA and Design Pattern

Q1. Java 8 and collection, Thread
Add your answer
Q2. Springboot, Microservices and Data base queries
Add your answer