SQL Server quiz

Test your SQL Server knowledge with a free interactive quiz — 50 questions with answers and explanations. No signup needed to play.

What does the `WHERE` clause do relative to `HAVING` in a query with `GROUP BY`?

1. What does the `WHERE` clause do relative to `HAVING` in a query with `GROUP BY`?
2. What does `BEGIN TRANSACTION` / `COMMIT TRANSACTION` do?
3. What is a nonclustered index?
4. What does `SCOPE_IDENTITY()` return?
5. What is the T-SQL equivalent of declaring and assigning a local variable?
6. Which clause limits the number of rows returned in a SQL Server SELECT, in place of LIMIT used by MySQL/Postgres?
7. What tool is most commonly used to write and run T-SQL queries with a graphical interface, including execution plan visualization?
8. What does `MERGE` accomplish in a single T-SQL statement?
9. Which built-in function returns the current date and time in SQL Server?
10. What does `THROW` do in T-SQL?
11. Which SQL Server data type would you use to store a precise date and time with higher precision than the legacy DATETIME type?
12. What is `NVARCHAR` used for, as opposed to `VARCHAR`?

More quizzes