SQL Server quiz

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

How do you execute a stored procedure named `usp_GetOrders` with a parameter?

1. How do you execute a stored procedure named `usp_GetOrders` with a parameter?
2. What does `THROW` do in T-SQL?
3. What is T-SQL?
4. What is the purpose of square brackets around an identifier, like `[Status]`, in T-SQL?
5. What tool is most commonly used to write and run T-SQL queries with a graphical interface, including execution plan visualization?
6. What is the default transaction isolation level in SQL Server?
7. What is a nonclustered index?
8. What is a clustered index in SQL Server?
9. What does `SCOPE_IDENTITY()` return?
10. What is Azure SQL Database?
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. Which T-SQL construct is used for structured error handling around a block of statements?

More quizzes