These are SQL questions of the kind Capgemini actually asks — the patterns that keep coming back in Capgemini's online tests and technical interview rounds for freshers. My advice: treat this page as a mock test. Attempt every question on paper first, then reveal. If any answer surprises you, the lesson it comes from is linked right below — go read it, then come back.
Capgemini SQL concept questions
Explain insert, update, and delete anomalies with an example, and briefly explain how normalization addresses them.
Asked in
What is a trigger in SQL? When would you use one, and what is a risk of overusing triggers?
Asked in
Capgemini SQL query questions
Write a CREATE TABLE statement for a students table with the following columns: student_id (integer primary key, auto-increment), name (required, cannot be null), email (must be unique), and enrolled_date (a date that defaults to the current date if not specified).
Asked in
How to use this page: Capgemini rarely asks a question you've never seen — they ask standard patterns with a twist. Master the pattern in the SQL course lessons, and the twist stops mattering.
Keep practising: SQL Basics, Joins, GROUP BY & HAVING and Subqueries cover what most Capgemini SQL rounds test.