Practice test

SQL Interview Mock 6

Mock 6 of the SQL Interview Test Series: 15 questions (11 Medium, 4 Hard) from a SQL Server (T-SQL) interview round: customers who bought every product (relational division), counting GROUPING SETS rows, cycles in recursive CTEs, LAST_VALUE and the default window frame, IS DISTINCT FROM, data type precedence in UNION, random GUIDs as clustered keys, a composite index that removes a Sort, sort spills and memory grants, SNAPSHOT update conflicts, SERIALIZABLE range locks, multiple cascade paths, triggers that handle multi-row inserts, sp_executesql and SQL injection, and keyset pagination. Mixed formats (query output, find-the-bug, pick-the-query, theory, multi-select and numeric), each with a full teaching explanation after you submit. Included in Full Access.

Questions

15

Time

25 min

Right answer

+1

Wrong answer

0

15 marks in all · pass mark 9