Capgemini Team Leader (Technical) Interview Questions and Answers

Q1. Difference between Intercompany and intracompany?
Ans. 
Intercompany refers to transactions between two or more companies within the same group, while intracompany refers to transactions within the same company.
• Intercompany transactions involve entities that are part of the same corporate group.

• Intracompany transactions occur within a single company.

• Intercompany transactions are typically eliminated during consolidation to avoid double counting.

• Intracompany transactions are...read more
Answered by AI
Add your answer

Q1. Disadvantages of high degree of normalization
Ans. 
High degree of normalization can lead to increased complexity, decreased performance, and difficulty in querying data.
• Increased complexity in joins and queries

• Decreased performance due to multiple joins

• Difficulty in querying data across multiple tables

• Increased storage space required for normalized tables

• Potential for data redundancy if not properly managed
Answered by AI
Add your answer
Q2. Difference between table scan and Index scan
Ans. 
Table scan reads all rows in a table, while Index scan reads only specific rows using an index.
• Table scan is slower as it reads all rows sequentially.

• Index scan is faster as it reads only specific rows based on the index key.

• Table scan is used when a large portion of the table needs to be accessed.

• Index scan is used when only a small subset of rows need to be retrieved.

• Example: Table scan for SELECT * FROM table_name; ...read more
Answered by AI
Add your answer
Q3. Some complex queries using correlation and outer joins.
Add your answer

Hackathon kind of technical test