Free practice test
SQL Interview Mock 2
Mock 2 of the SQL Interview Test Series: 15 questions on core SQL querying in SQL Server (T-SQL): a comma join without a join condition, row multiplication in joins, NULLs in GROUP BY, DISTINCT with ORDER BY, NULL in arithmetic and + vs CONCAT, ISNULL vs COALESCE, correlated subqueries, error 512, EXCEPT for new and changed rows, second normal form, foreign keys and error 547, what indexes cost, what ROLLBACK undoes, running totals with SUM() OVER, and listing duplicate emails. Mixed formats (query output, find-the-bug, pick-the-query, theory, multi-select and numeric), each with a full teaching explanation after you submit.
- Answers save as you go. Move between questions freely, and mark any to come back to.
- The clock starts when you begin, and the test submits itself at 00:00.
- Keyboard: press A–D to choose an option; ← and → move between questions.
- Questions
- 15
- Time
- 20 min
- Right answer
- +1
- Wrong answer
- 0
15 marks in all · pass mark 9
Checking your account so your result is saved correctly.