Add office photos
i
Capgemini
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Database Developer Interview Questions and Answers
Capgemini Database Developer Interview Experiences
4 interviews found
I applied via Naukri.com and was interviewed in Nov 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. All plsql related questions, proc, functions, views, m views, cursors, ref cursor etc
Interview Preparation Tips
Selected
(2 Questions)
- Q1. What is database architecture?
- Ans.
Database architecture refers to the design and structure of a database system.
Database architecture includes the organization of data, storage, retrieval, and security mechanisms.
It involves defining the relationships between data elements and how they are stored and accessed.
Examples of database architectures include hierarchical, network, relational, and object-oriented.
Database architecture also includes the choice ...
- Q2. Difference between delete and truncate
- Ans.
Delete removes rows one by one, while truncate removes all rows at once.
Delete is a DML command, while truncate is a DDL command.
Delete can be rolled back, while truncate cannot be rolled back.
Delete fires triggers, while truncate does not fire triggers.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Example: DELETE FROM table_name WHERE condi
Interview Preparation Tips
Skills evaluated in this interview
Nishant Shrivastav
I applied via Naukri.com and was interviewed in Aug 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Mostly questions asked where subquery is required they wanted to see if we are able to fetch records from database using multiple joins and subquery. Also the theortical part should be crystal clear like n...
Interview Preparation Tips
What people are saying about Capgemini
Interview Questionnaire
1 Question
- Q1. Difference between DDL and DML
- Ans.
DDL is used to create, modify or delete database objects while DML is used to manipulate data within those objects.
DDL stands for Data Definition Language
DML stands for Data Manipulation Language
DDL is used to create, modify or delete database objects like tables, indexes, etc.
DML is used to manipulate data within those objects like inserting, updating, deleting data
Examples of DDL statements are CREATE, ALTER, DROP
Exa...
Interview Preparation Tips
Skills evaluated in this interview
Capgemini interview questions for designations
Interview questions from similar companies
(1 Question)
- Q1. DDL DML DCL TCL
(2 Questions)
- Q1. How to run parallel queries for multiple databases ??
- Ans.
To run parallel queries for multiple databases, use parallel processing techniques and tools.
Use parallel processing techniques such as multi-threading or distributed computing to run queries simultaneously on multiple databases.
Consider using tools like Apache Hadoop or Apache Spark for parallel processing of queries across multiple databases.
Ensure proper resource allocation and optimization to prevent performance is...
- Q2. What is normalisation technique used for database??
- Ans.
Normalization technique is used to organize data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy by storing data in a structured and organized manner.
Normalization ensures data integrity by minimizing data anomalies such as update, insert, and delete anomalies.
There...
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Feb 2022. There were 3 interview rounds.
In it they trying to get the information about basic knowledge about related to database and also they are give to write some queries
Related queries which you did in your past projects and also some queries to write
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Feb 2021. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. About previous project experience
- Q2. SQL concepts
- Q3. Non-sql concepts
- Q4. Devops
Interview Preparation Tips
Oracle Database Administrator Interview Questions & Answers
Accenture
Anonymous
posted on 10 Jan 2025
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me the high level overview of dataguard installation?
- Q2. What are your daily tasks adn what things you handel in your team?
(2 Questions)
- Q1. Architecture of sql
- Ans.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
- Q2. Recovery models
Skills evaluated in this interview
Capgemini Interview FAQs
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 Senior Analyst Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- Database Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Mysql Database Administrator Interview Questions
- SQL Server Database Administrator Interview Questions
- Data Architect Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
Capgemini Database Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Consultant
55.3k
salaries
|  ₹5.2 L/yr - ₹18 L/yr |
|
Associate Consultant
52k
salaries
| ₹2.9 L/yr - ₹11.8 L/yr |
|
Senior Consultant
46k
salaries
| ₹7.4 L/yr - ₹24 L/yr |
|
Senior Analyst
20.5k
salaries
| ₹2 L/yr - ₹7.5 L/yr |
|
Senior Software Engineer
19.9k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Database Developer Interview Questions
