Practice test

SQL Interview Mock 4

Mock 4 of the SQL Interview Test Series: 15 Medium questions from an intermediate SQL Server (T-SQL) interview round: an INNER JOIN after a LEFT JOIN, range joins with BETWEEN, ROLLUP and GROUPING, counting with CASE, NULLIF for divide by zero, recursive CTEs, COUNT(DISTINCT) with OVER, moving-average window frames, EXCEPT and NULL, implicit conversions and index seeks, parameter sniffing, TRUNCATE TABLE myths, update locks, what a user-defined function can't do, and DECIMAL precision and scale. 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