Capgemini Interview Questions and Answers

Indexing is used to improve the performance of database queries by allowing for faster data retrieval.

• Indexing creates a data structure that allows for quick lookups of specific values in a database table.

• It helps in reducing the time taken to retrieve data from a database, especially when dealing with large datasets.

• Indexes can be created on one or more columns in a table to speed up search queries.

• Examples of indexes include primary keys, unique keys, and composite indexes.

The flow from admission to discharge involves initial assessment, treatment plan creation, ongoing monitoring, and eventual release.

• Initial assessment of patient's condition upon admission

• Creation of a treatment plan based on assessment

• Ongoing monitoring of patient's progress and adjusting treatment as needed

• Consultation with medical team for updates and decisions

• Final discharge planning and release of patient

Stored procedures are precompiled SQL queries stored in the database for reuse and improved performance.

• Stored procedures can improve performance by reducing network traffic and optimizing query execution.

• They can also enhance security by controlling access to data.

• Stored procedures can be used for complex business logic and data manipulation.

• Examples include creating a stored procedure to retrieve customer information or update inventory levels.

Types of joining include inner join, outer join, left join, right join, and full join.

• Inner join: Returns rows when there is at least one match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full join: Returns rows when there is a match in one of the tables

Pivot tables are used in Excel to summarize and analyze data from a larger table.

• Pivot tables allow you to reorganize and summarize selected columns and rows of data

• They can help in analyzing trends, patterns, and relationships in data

• You can easily create charts and graphs based on the summarized data from a pivot table