| 1 | What are the main limitations of common table expressions that developers should be aware of? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Intermediate |
| 2 | How do you define multiple common table expressions within a single query? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Beginner |
| 3 | What is a common table expression, and why would you use one instead of a subquery? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Beginner |
| 4 | What is a recursive common table expression, and what kind of problems is it commonly used to solve? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Intermediate |
| 5 | How do you prevent a recursive common table expression from running forever if the underlying data accidentally contains a circular reference? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Intermediate |
| 6 | Can a common table expression be used inside an UPDATE, DELETE, or MERGE statement, and how does that work? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Advanced |
| 7 | How would you use a CTE combined with a window function to identify and remove duplicate rows from a table? SQL Server › Common Table Expressions (CTEs) | SQL Server | Common Table Expressions (CTEs) | Advanced |
| 8 | How would you decide between using a temporary table, a table variable, and a common table expression for a specific intermediate data processing need within a stored procedure? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Advanced |
| 9 | What is a local temporary table in SQL Server, and how is it different from a regular permanent table? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Beginner |
| 10 | What does the ROW_NUMBER function do, and what is a common practical use case for it? SQL Server › Window Functions | SQL Server | Window Functions | Beginner |