Capgemini Senior Business Consultant Interview Questions and Answers

Q1. Tableau filters and connections
Add your answer
Q2. SQL cte type of joins
Ans. 
SQL CTE (Common Table Expression) allows for recursive queries and temporary result sets.
• CTE can be used to create temporary result sets that can be referenced within a query.

• CTE can be used to simplify complex queries by breaking them down into smaller, more manageable parts.

• CTE can be recursive, allowing for queries that reference themselves to traverse hierarchical data structures.

• CTE can be used with different type...read more
Answered by AI
Add your answer

Q1. How many joins are in SQL?
Ans. 
The number of joins in SQL can vary depending on the complexity of the query.
• The number of joins in SQL can range from 0 (no joins) to multiple joins in a single query.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Joins are used to combine rows from two or more tables based on a related column between them.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q2. Explain about difference left and inner join? And scenarios questions
Add your answer

Q1. About the Agile
Add your answer
Q2. Behavioral Questions
Add your answer

Q1. About Jira and behavioral questions based on jira?
Add your answer

Written test this includes English questions, about excel, and applitude questions, eassy writing

Q1. About marketing research
Add your answer

Q1. In Agile development what is the DOR
Ans. 
DOR stands for Definition of Ready in Agile development.
• DOR is a checklist of criteria that a user story must meet before it can be considered ready for development.

• It ensures that the team has a shared understanding of the requirements and that the story is feasible and testable.

• DOR helps to prevent scope creep and ensures that the team is working on the most valuable features.

• Examples of DOR criteria include clear ac...read more
Answered by AI
Add your answer