AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Capgemini
Compare
Filter interviews by
Capgemini Consultant Interview Questions and Answers for Freshers
17 Interview questions
Partition is the division of a physical or logical structure into multiple parts.
Partitioning helps in organizing data, improving performance, and increasing efficiency.
Examples include disk partitioning in a computer system, partitioning of a database table for better management, and partitioning of a hard drive for separate storage areas.
Oracle database structure refers to the organization of data in tables, indexes, views, and other database objects.
Consists of tables, which store data in rows and columns
Includes indexes for faster data retrieval
Views provide virtual representations of data from one or more tables
Constraints ensure data integrity and enforce rules
Stored procedures and functions for processing data
A cursor is a database object used to retrieve data from a result set one row at a time.
Cursor is used in SQL to fetch and manipulate data row by row
Examples of cursor include FETCH, OPEN, CLOSE, and DECLARE
Cursor is often used in stored procedures and triggers
Materialized views are precomputed views stored on disk for faster query performance.
Materialized views store the results of a query on disk so that the query can be run faster in the future.
They are updated periodically to reflect changes in the underlying data.
Materialized views are commonly used in data warehousing and reporting applications.
Examples of materialized views include summary tables, aggregated data...
What people are saying about Capgemini
I have used design patterns such as Singleton, Factory, and Observer in my projects.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notifie...
Custom exceptions can be written by creating a new class that extends the Exception class.
Create a new class that extends the Exception class
Add a constructor to the custom exception class
Throw the custom exception using 'throw new CustomException(message)'
throw is a keyword used to throw an exception, throws is used in method signature to declare exceptions thrown, and Throwable is a superclass for all exceptions and errors.
throw is used to throw an exception in a try-catch block
throws is used in method signature to declare exceptions that the method can throw
Throwable is a superclass for all exceptions and errors in Java
HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.
HashMap internally uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.
If multiple keys hash to the same index, a linked list is used to handle collisions.
HashMap uses the hashCode() method ...
A choice router is a device or software that directs incoming data packets to the appropriate destination based on predefined rules or user preferences.
A choice router is used in computer networks to manage and control the flow of data.
It examines the header information of incoming packets to determine the best path for forwarding the data.
Choice routers can be hardware devices or software programs.
They can be con...
Sub flow in Mule is a reusable flow that can be called from other flows.
Sub flow is a separate flow that can be called from other flows
It helps in reusing the same logic in multiple flows
Sub flow can have its own set of input and output parameters
It can be used to encapsulate complex logic and make the main flow more readable
Example: A sub flow for database connection that can be called from multiple flows
Capgemini Consultant Interview Experiences for Freshers
33 interviews found
Anonymous
Basic technical question
Basic coding syntax 30 mints
(1 Question)
- Q1. What is loop? what is inheritance?
- Ans.
A loop is a programming construct that repeats a set of instructions until a specific condition is met. Inheritance is a mechanism in object-oriented programming where a new class inherits properties and behaviors from an existing class.
A loop allows a set of instructions to be executed repeatedly based on a condition. Examples include for loops, while loops, and do-while loops.
Inheritance allows a new class (subclass)...
(1 Question)
- Q1. Why should I hire you?
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
1.Sort by salary from employee list using stream.
2.Concat two array and remove duplicate.
3.
(5 Questions)
- Q1. What are the Design patterns have you used?
- Q2. Difference between throw , throws and throwable ?
- Q3. How do you write custom exception?
- Q4. Internal working of hashmap
- Q5. Feature of micro services
- Ans.
Microservices are a software development technique that structures an application as a collection of loosely coupled services.
Each service is self-contained and can be developed, deployed, and scaled independently
Promotes flexibility, scalability, and resilience in software development
Allows for different technologies to be used for different services
Enables teams to work on different services simultaneously
Facilitates...
Skills evaluated in this interview
(2 Questions)
- Q1. Why react is faster, default parameters, can you call async function in useEffect
- Ans.
React is faster due to virtual DOM, default parameters provide fallback values, async functions can be called in useEffect
React is faster than traditional DOM manipulation because it uses a virtual DOM to minimize actual DOM updates
Default parameters in JavaScript allow you to specify default values for function parameters if no value is provided
Async functions can be called in useEffect hook in React to perform asynch...
- Q2. ES6 features, react hooks
Interview Preparation Tips
Skills evaluated in this interview
Sreelakshmi Nair
(3 Questions)
- Q1. Excel knowledge-Macros
- Q2. Intership knowledgeable
- Q3. Communication skill
Selected
I applied via Campus Placement and was interviewed in Apr 2024. There were 3 interview rounds.
Basic General aptitude
Oops concepts, java 8 features
(1 Question)
- Q1. Salary discussion and scenario based questions
Interview Preparation Tips
Lavanya N
(1 Question)
- Q1. 1. Polymorphism in Java
- Ans.
Polymorphism in Java allows objects of different classes to be treated as objects of a common superclass.
Polymorphism allows methods to be called on objects of different classes that share a common superclass.
There are two types of polymorphism in Java: compile-time polymorphism (method overloading) and runtime polymorphism (method overriding).
Example of runtime polymorphism is when a subclass overrides a method of its...
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Oct 2022. There were 4 interview rounds.
(2 Questions)
- Q1. Technical question based on experience
- Q2. Write a java program
(3 Questions)
- Q1. Questions on ur project
- Q2. Internal structure of collections
- Ans.
Internal structure of collections refers to the organization and arrangement of data within a collection.
Collections can be organized using various data structures such as arrays, linked lists, trees, and hash tables.
The choice of data structure depends on the type of data being stored and the operations that need to be performed on the collection.
For example, an array is a good choice for collections with fixed size a...
- Q3. Multithreading program
- Ans.
Multithreading allows concurrent execution of tasks, improving performance and resource utilization in applications.
Multithreading enables parallel execution of tasks, enhancing application responsiveness.
Example: In a web server, one thread handles requests while another processes data.
Threads share the same memory space, which can lead to race conditions if not managed properly.
Synchronization mechanisms like mutexes...
(2 Questions)
- Q1. Question on salary expectations
- Q2. If there is any Location constraint
Interview Preparation Tips
Skills evaluated in this interview
mukul rajpurohit
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What is oracle database structure?
- Ans.
Oracle database structure refers to the organization of data in tables, indexes, views, and other database objects.
Consists of tables, which store data in rows and columns
Includes indexes for faster data retrieval
Views provide virtual representations of data from one or more tables
Constraints ensure data integrity and enforce rules
Stored procedures and functions for processing data
- Q2. What is partition?
- Ans.
Partition is the division of a physical or logical structure into multiple parts.
Partitioning helps in organizing data, improving performance, and increasing efficiency.
Examples include disk partitioning in a computer system, partitioning of a database table for better management, and partitioning of a hard drive for separate storage areas.
(2 Questions)
- Q1. Salary expectations
- Q2. Ehy you want to join our company
Skills evaluated in this interview
I applied via AmbitionBox and was interviewed in Nov 2022. There were 2 interview rounds.
(2 Questions)
- Q1. What is sub flow in mule?
- Ans.
Sub flow in Mule is a reusable flow that can be called from other flows.
Sub flow is a separate flow that can be called from other flows
It helps in reusing the same logic in multiple flows
Sub flow can have its own set of input and output parameters
It can be used to encapsulate complex logic and make the main flow more readable
Example: A sub flow for database connection that can be called from multiple flows
- Q2. What is a choice router?
- Ans.
A choice router is a device or software that directs incoming data packets to the appropriate destination based on predefined rules or user preferences.
A choice router is used in computer networks to manage and control the flow of data.
It examines the header information of incoming packets to determine the best path for forwarding the data.
Choice routers can be hardware devices or software programs.
They can be configur...
Interview Preparation Tips
Skills evaluated in this interview
priya ravi
Selected
I applied via Naukri.com and was interviewed before Jul 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What is cursor and explain wd eg
- Ans.
A cursor is a database object used to retrieve data from a result set one row at a time.
Cursor is used in SQL to fetch and manipulate data row by row
Examples of cursor include FETCH, OPEN, CLOSE, and DECLARE
Cursor is often used in stored procedures and triggers
- Q2. What are materialised views
(2 Questions)
- Q1. Expected CTC and joining date
- Ans.
I expect a competitive CTC based on my skills and market standards, and I can join immediately or as per your requirement.
My expected CTC is aligned with industry standards for my experience level.
For example, based on my research, a CTC of $X would be appropriate.
I am flexible with my joining date and can start immediately or within two weeks.
I am open to discussing the CTC further based on the overall compensation pa...
- Q2. Formalities for joining
Capgemini Interview FAQs
The duration of Capgemini Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 10 interview experiences
Difficulty level
Duration
Top Skills for Capgemini Consultant
Consultant Interview Questions from Similar Companies
Capgemini Consultant Reviews and Ratings
based on 4.9k reviews
Rating in categories
Hyderabad / Secunderabad,
Pune
+16-10 Yrs
₹ 2-14.5 LPA
|
Consultant
58.6k
salaries
|  ₹8.9 L/yr - ₹16.5 L/yr |
|
Associate Consultant
51.2k
salaries
| ₹4.5 L/yr - ₹10 L/yr |
|
Senior Consultant
50k
salaries
| ₹12.4 L/yr - ₹21 L/yr |
|
Senior Analyst
22.1k
salaries
| ₹3.1 L/yr - ₹7.5 L/yr |
|
Senior Software Engineer
21.6k
salaries
| ₹4.7 L/yr - ₹12.9 L/yr |
Wipro
Accenture
Cognizant
TCS
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Interview Questions for Fresher
