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 is the default transaction isolation level in SQL Server?

1. What is the default transaction isolation level in SQL Server?
2. What is the purpose of a foreign key constraint like `FOREIGN KEY (CustomerId) REFERENCES dbo.Customers(CustomerId)`?
3. Which built-in function returns the current date and time in SQL Server?
4. How do you execute a stored procedure named `usp_GetOrders` with a parameter?
5. What tool is most commonly used to write and run T-SQL queries with a graphical interface, including execution plan visualization?
6. What does the `WHERE` clause do relative to `HAVING` in a query with `GROUP BY`?
7. What is the T-SQL equivalent of declaring and assigning a local variable?
8. What does the `IDENTITY(1,1)` property on a column do?
9. What is T-SQL?
10. What does `BEGIN TRANSACTION` / `COMMIT TRANSACTION` do?
11. What is Azure SQL Database?
12. What is the difference between `DELETE` and `TRUNCATE` in SQL Server?

More quizzes