SQL Advanced
Basic
This test evaluates your advanced knowledge of SQL, covering stored procedures, triggers, indexing, optimization techniques, and complex query design. To master advanced SQL topics, study Advanced SQL Tutorials on SQLShack, learn optimization tips from Mode’s SQL Guide, and watch this advanced SQL Masterclass Video.
1
What is a Common Table Expression (CTE) in SQL?
2
What is the purpose of the WINDOW function in SQL?
3
What is a materialized view?
4
What is the difference between RANK() and DENSE_RANK() functions?
5
What is a recursive CTE?
6
What is the purpose of the PIVOT operator in SQL?
7
What is the difference between INNER JOIN and OUTER JOIN?
8
What is a self-join?
9
What is the purpose of the MERGE statement?
10
What is a covering index?
11
What is the purpose of the EXCEPT operator?
12
What is a table variable?
13
What is the purpose of the OUTPUT clause in SQL Server?
14
What is a filtered index?
15
What is the purpose of the ROW_NUMBER() function?
16
What is a temporal table?
17
What is the purpose of the CROSS APPLY operator?
18
What is a columnstore index?
19
What is the purpose of the TRY...CATCH construct in SQL Server?
20
What is a table-valued function?
21
What is the purpose of the OFFSET-FETCH clause?
22
What is a database snapshot?
23
What is the purpose of the APPLY operator?
24
What is a partitioned view?
25
What is the purpose of the TABLESAMPLE clause?
26
What is a sequence object?