Capgemini Analyst Interview Experience | Experience 1

DATE -15 May 2021

Duration - 20 mins

TECHNICAL ROUND

Q1. Introduce yourself

It is the most important question asked in any interview. This decides the flow of your interview and you should highlight the stuff you are most confident about.

Make this relevant to the position

You can mention your internships and projects

Do not go away from the role and don't add irrelevant information.

Sample Answer : 

hello , My name is XYZ from ABC college IT branch.In my 4 years at college I have worked to explore both technical and non technical part in me.I have worked with PQR firm where i have worked on android development. My major work was to work on the UI part of the application. Along with that I have participated in various hackathons and coding challenges. I have worked on few personal projects in my college like...(mention 1-2 in short).

Q2. What is polymorphism?

Polymorphism in OOPs is inseparable and an essential concept of every object-oriented programming language. An object or reference basically can take multiple forms in different instances. As the word suggests, ‘poly’ means ‘many’ and ‘morph’ points at ‘forms’; thus, polymorphism as a whole would mean ‘a property of having many forms.’

The object-oriented programming language processes classes and objects by a single interface. It implements the concepts of function overloading, overriding, and virtual functions. Also, it is typically used for instrumenting inheritance in programming.  

 

Q3. What is factorial ,  fibonacci and palindrome.

Factorial : 

in mathematics, the product of all positive integers less than or equal to a given positive integer and denoted by that integer and an exclamation point. Thus, factorial seven is written 7!, meaning 1 × 2 × 3 × 4 × 5 × 6 × 7. Factorial zero is defined as equal to 1.

Fibonacci :

0, 1, 1, 2, 3, 5, 8, 13, 21, 34, …

Fn = Fn-1 + Fn-2

 

Palindrome :

A palindrome is a word, sentence, verse, or even number that reads the same backward or forward.

122221

NITIN

 

Q4. What is an array?

An array is a collection of items stored at contiguous memory locations. The idea is to store multiple items of the same type together. This makes it easier to calculate the position of each element by simply adding an offset to a base value, i.e., the memory location of the first element of the array (generally denoted by the name of the array). The base value is index 0 and the difference between the two indexes is the offset.

Q5.  What are the differences between for loop and foreach loop.

For Loop :

It runs until the given condition becomes false

It is flexible to iterate in both ascending and

descending order.

For Each Loop : 

It runs until last element in the array.

It runs from starting to end of array. It is

read only loop.No manipulation on data

can be done.

Tips: Mention at least 2 points that clearly specify the difference between the things.

Q6. What is primary and foreign key in dbms

Primary keys : 

A primary key is a column or a set of columns in a table whose values uniquely identify a row in the table. A relational database is designed to enforce the uniqueness of primary keys by allowing only one row with a given primary key value in a table.

Foreign keys : 

A foreign key is a column or a set of columns in a table whose values correspond to the values of the primary key in another table. In order to add a row with a given foreign key value, there must exist a row in the related table with the same primary key value.

Q7. How to create table in SQL.

CREATE TABLE table_name (

column1 datatype,column2 datatype,column3 datatype,....

);

Q8. Explain about your project.

Watch This video for explanation.

 

Q9. Where do you see yourself in 5 years?

This is one of the questions you will see in many interviews. With this the interviewer wants to know what are your professional goals in next 5 years, what are your goals and aspirations and will the company be able to offer what you are looking for. So, get clear about your career goals so that you sound confident when you answer this question to the interviewer.

 

Sample answer:

A few of the goals I’ve set for myself over the next few years include becoming a senior  software developer and would work on major projects and gain knowledge in the same. I’m excited about the opportunities this job would provide me, as I believe they will support my long-term career goals and allow me to grow.

    

THANK YOU

HAPPY LEARNING