KPMG India Interview Questions, Process, and Tips

Q1. SQL to find duplicates
Ans. 
SQL query to find duplicates in a table
• Use GROUP BY and HAVING clause to identify duplicates

• Select the columns you want to check for duplicates

• Use COUNT() function to count the occurrences of each group
Answered by AI
Add your answer
Q2. SQL to convert case to upper Union and Union all Decorators Generators
Ans. 
SQL query to convert case to upper, Union and Union all, Decorators, Generators
• Use the UPPER() function in SQL to convert case to upper

• UNION combines the result sets of two or more SELECT statements

• UNION ALL also combines the result sets of two or more SELECT statements, including duplicates

• Decorators in Python are used to modify or extend the behavior of functions or methods

• Generators in Python are functions that retu
Answered by AI
Add your answer

Live problem-solving exercise with the interviewers to determine how well we structure problems

24 hour take-home case study

Q1. How cicd pipeline works
Ans. 
CI/CD pipeline automates the process of integrating code changes, testing them, and deploying to production.
• CI/CD stands for Continuous Integration/Continuous Deployment

• It involves automating the steps of building, testing, and deploying code changes

• Tools like Jenkins, GitLab CI/CD, and CircleCI are commonly used for setting up CI/CD pipelines

• Developers commit code changes to a version control system, triggering the pi...read more
Answered by AI
Add your answer

Easy aptitude questions

Q1. They asked basic questions from resume.
Add your answer

Q1. Introduction, strength and weakness simple hr questions
Add your answer