Capgemini Analyst Interview Experience | Experience 2

 

Date -14 May 2021

Duration - 25 mins

Technical Questions

Q1. what is RDBMS.

An RDBMS is a type of database management system (DBMS) that stores data in a row-based table structure which connects related data elements. An RDBMS includes functions that maintain the security, accuracy, integrity and consistency of the data. This is different than the file storage used in a DBMS.


Q2. How to find maximum and minimum salary from table.

SELECT MAX(SALARY) FROM TABLENAME;
SELECT MIN(SALARY) FROM TABLENAME;

Q3.  What is the difference between array and linked list.

Array :

An array is a collection of elements of a similar data type.

Array elements store in a contiguous memory location.

Linked List : 
A linked list is a collection of objects known as a node where node consists of two parts, i.e., data and address.
Linked list elements can be stored anywhere in the memory or randomly stored.




Q4.What is a data structure?

A data structure is a particular way of organizing data in a computer so that it can be used effectively.
Eg. array , linked list,stack,queue etc.


Q5. Explain oops concepts.

Inheritance - When one object acquires all the properties and behaviors of a parent object, it is known as inheritance. It provides code reusability. It is used to achieve runtime polymorphism.
Encapsulation - Binding (or wrapping) code and data together into a single unit are known as encapsulation. For example, a capsule, it is wrapped with different medicines.
Polymorphism - If one task is performed in different ways, it is known as polymorphism. For example: to convince the customer differently, to draw something, for example, shape, triangle, rectangle, etc.
Abstraction - Hiding internal details and showing functionality is known as abstraction. For example phone call, we don't know the internal processing.

Q6. Explain about your project.

Follow STAR approach in answering the questions. 
Situation
Task
Approach
Result
1.Project Introduction
Give an introduction of your project, what problem you tried to solve with your project.
2.Modules Description:
Divide your project in various modules and describe modules to the interviewer.
3.Advantages and main functionality of your project
describe your main functionality of the project and main problem you want to solve.
4.Tools,Technologies and platform used
This is also a very important aspect when explaining a project. Tools, Technologies, and platforms used will help the interviewer understand better about the working of the project. As well as it will create an impact on how new is your project. Try to explain it very short and be to the point.
5.Personal Contribution in the project
Interviewer is interested to know what have you done in the project and what part you have worked on.

Q7. What difficulties you faced during your project

The interviewer wants to know about how you handle difficult situations that you might face while working on various projects and how you think out of the box to tackle them while delivering project with perfection both in terms of quality and time.

Q8. Define acid properties.
 

Atomicity: The term atomicity defines that the data remains atomic. It means if any operation is performed on the data, either it should be performed or executed completely or should not be executed at all. It further means that the operation should not break in between or execute partially. In the case of executing operations on the transaction, the operation should be completely executed and not partially.
Consistency: The word consistency means that the value should remain preserved always. In DBMS, the integrity of the data should be maintained, which means if a change in the database is made, it should remain preserved always. In the case of transactions, the integrity of the data is very essential so that the database remains consistent before and after the transaction. The data should always be correct.
Isolation: The term 'isolation' means separation. In DBMS, Isolation is the property of a database where no data should affect the other one and may occur concurrently. In short, the operation on one database should begin when the operation on the first database gets complete. It means if two operations are being performed on two different databases, they may not affect the value of one another. In the case of transactions, when two or more transactions occur simultaneously, the consistency should remain maintained. Any changes that occur in any particular transaction will not be seen by other transactions until the change is not committed in the memory.
Durability: Durability ensures the permanency of something. In DBMS, the term durability ensures that the data after the successful execution of the operation becomes permanent in the database. The durability of the data should be so perfect that even if the system fails or leads to a crash, the database still survives. However, if gets lost, it becomes the responsibility of the recovery manager for ensuring the durability of the database. For committing the values, the COMMIT command must be used every time we make changes.

HR Questions:

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. 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

Q3.What are your strengths?

During the interview process, it’s likely that the hiring manager will ask you to describe your strengths at some point. Many candidates probably wonder how to answer what are your strengths without bragging too much or risk appearing narcissistic.You want to craft your answer with a high degree of self-awareness and professionalism. 
It’s important to be prepared for this question and have a statement ready. Even if you aren’t asked this question, you will be aware of your strengths and what you can bring to the position.

THANK YOU 
HAPPY LEARNING