These are SQL questions of the kind Accenture actually asks — the patterns that keep coming back in Accenture'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.
Accenture SQL concept questions
What is a CHECK constraint? Give an example and explain how it differs from NOT NULL and UNIQUE.
Asked in
What does the COALESCE function do in SQL? Give an example.
Asked in
Accenture SQL query questions
Given the employees table where manager_id points to another row in the same table, write a query to find employees who earn more than their own manager.
Asked in
employees5 rows
| emp_id | name | salary | manager_id |
|---|---|---|---|
| 1 | Asha | 90000 | NULL |
| 2 | Ravi | 95000 | 1 |
| 3 | Meera | 60000 | 1 |
| 4 | Kiran | 70000 | 2 |
| 5 | Zoya | 99000 | 2 |
How to use this page: Accenture 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 Accenture SQL rounds test — and the Accenture exam guide covers the rest of their selection process.