Practice test

SQL Interview Mock 5

Mock 5 of the SQL Interview Test Series: 15 Medium questions from a SQL Server (T-SQL) interview round: filling missing days with GENERATE_SERIES, STRING_AGG with WITHIN GROUP, IN vs EXISTS, latest rows per group with ties, NTILE, percentages with SUM(SUM()) OVER, sorting NULLs, set-operator precedence, unique columns that allow many NULLs, Nested Loops vs Merge Join vs Hash Match, TRY...CATCH and XACT_STATE, deadlocks, scalar UDF inlining, replacing a WHILE loop with one UPDATE, and gaps and islands. 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